Random Number Generator Based On Weibull Distribution
how to go about generating random numbers based on Weibull distribution in VBA? I had a rough idea for Normal (from link below) which i later extended to Lognormal but am having difficulty with Weibull and Gamma will appreciate any help.
http://www.devx.com/vb2themax/Tip/19233
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Positive Random Number Generator From Normal Distribution
I would like to get random number generator for normal distribution and I’m using: =NORMINV(RAND(),$B$1,$B$2) Where B1 is mean (average) and B2 is SD. This command works, but in the random generating numbers, I’m getting positive and negative numbers (ex. 23,34). how to change command so I can generate positive only numbers?
View Replies!
View Related
Random Number Generator Macro
What I'm trying to do is as follows: Sheet 1 A1 through A6 has STR, DEX, CON, INT, WIS and CHA. B1 through B6 is waiting for results from sheet 2. Sheet 2 A1 is data validation of d4, d6, d8, d10, d12, d20 and d100. A2 through A7 are currently Rand formulae triggered by A1 with B1 adding number of dice (minimum 1) and B2 a modifier value add to the rolled result. D2 through D7 are data validation modifiers of 10 to +10 (0 included). E2 through E7 is the result of A2+C2. The Rand works fine, but every time data is changed Rand recalculates. I'm hoping for a macro executed by a button to generate six random numbers based on the chosen die value of A1 ranging from 14 to 1100. The die roll can never be below 1 and no higher than the chosen die. I then want to transfer the result from E? To sheet 1 B1 to B6 matching its appropriate atribute. I named them Char01_STR, etc on sheet 1 A1 to A6.
View Replies!
View Related
Random Number Generator From 1 To 7 Other Than Cell Value
I have a range of cells that have values from 1 to 7 in them. What I would like to do is to have the next column generate a random number from 1 to 7 that does not generate the number that the cell next to it has. for example if cell A1 has 6 in it, I would like cell b1 to generate a random number other than 6 in it. if cell A2 has 3 in it then cell B2 would generate a number other that 3 (1,2,4,5,6, and 7).
View Replies!
View Related
Random Number With Normal Distribution
in VBA the RND function generates a random number using uniform distribution (every number is as likely as any other). Is there a function to generate a random number using normal distribution where the numbers closest to the mean are more likely to occure then numbers further away from the mean. I've created the following custom function to generate a random number between two given values using uniform distribution. Function RandNum(Min As Double, Max As Double) As Double RandNum = (Max  Min) * Rnd + Min End Function
View Replies!
View Related
Random Names Generator
I like to know if this can be done using vb. If I have a list of names of associates B2 to B32. Can I randomize the list in any order. Then if I need to want that list to only randomize B2 to thru B30 Then if I need to want that list to only randomize B2 to thru B28 And so forth. Sort of being able to pick from a pop up message box or userform that will ask you how many names to randomize in that list.
View Replies!
View Related
Random Password Generator
I wrote this to help me generate a random password for a workbook. I am happy with it so far, but I was wondering if there is a way, to shuffle the order of the variables? So, instead of MyPassword always being A, B, C, D, E etc Sub RandPass() Dim A As String, B As String, C As String Dim D As String, E As String, F As String Dim H As String, I As String, J As String Dim K As String, L As String, M As String Dim MyPassword As String Dim v ReDim v(33 To 47) As Variant A = Chr(Int((UBound(v)  LBound(v) + 1) * Rnd + LBound(v)))..............
View Replies!
View Related
Random Word Generator
Has anyone seen an Excel program that will generate words based on letters entered. For example, if I had 10 cells in a row, and each cell contained a letter (duplicates are okay), what words could be derived from arranging those letters in random sequences. It would need the ability to accept any letter of the alphabet, A thru Z E A L R C T S S U C ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ How many words could it generate, and what are the words? I assume it would have to reference a spelling dictionary. It could be used as a spelling learning game, etc.
View Replies!
View Related
Random Winner Generator
I need a formula that can randomly pick a persons dependent on the amount of entries they have in a competition. For Example PersonEntries Andrew10 Jake15 Louisa4 Fuffy33 In the above case there is 62 entries into the draw. Andrew has 10 chances to win. Is there a formula that I can use that will decide a winner for me dependent on how many chances they have.
View Replies!
View Related
Random Generator With Several Outputs
I need a formula to create random letters down a column: AF. Probability of A=3%, B=6%, C=8%, D=11%, E=14%, F=16%. I've got it worked out to where each letter is a header of a column ("A" is in A1, "B" is in B1, etc.). My question is: how do I consolidate that in one column, so that, "A" for example, reads ABFCBACFBFBECEABCEABCEAFBCEFBCAFEBCFAEBFC...? I'm using the random number generator for the 6 columns...thx
View Replies!
View Related
Random Generator, Change A Line Or Two
I have a random Generator but it only generates values that are different, is it possible to change a line of code to allow it to duplicate the same number? Here is the code I have and it works great but not for duplication: Sub Unique_Numbers() Dim x As Long, y As Long, z As Long, tempnum As Long Dim flag As Boolean Dim i As Integer Dim foundCell As Range Application.ScreenUpdating = False x = Application.InputBox("Enter starting Random Number" _ , "Random Number Generation", 1, , , , , 1) y = Application.InputBox("Enter ending Random Number" _ , "Random Number Generation", 1000, , , , , 1) z = Application.InputBox("How many random numbers would" _ & "you like to generate (
View Replies!
View Related
Random Group Generator Tonight
I am to supply this tomorrow!! I have a column of 60 names that I need to break into 15 groups of 4. {this is actually for making a group of 4 names to get together each month for a dinner discussion} I need to generate a random mix so that each month everyone is with someone new until it begins to overlap. I am a relative elementary user of excel but understand that in some manner the "RAND"[?] function.
View Replies!
View Related
Random Distribution/Allocation
I have a spreadsheet which has a list of staff (column B) and work categories (row 3). Row 4 is updated each day with a count of the incoming work for each work category. I want to be able to randomly distribute (as evenly as possible) the no of work items in Row 4 between the doers (B7:B13). Each item of work also has to be checked so I would also like to randomly distribute the checking between the checkers (B16:B18)....
View Replies!
View Related
Is Random Normal Distribution Possible
i have some number that i want to put in a normal distribution so.. i have age ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) and have the number of times that the kid wake in the night ( 10, 12, 9,11,8,9,7,9,11) and want to do the normal distribution grafic with that .
View Replies!
View Related
Random Value Generation From Skewed Normal Distribution
I would like to generate a random value using a skewed normal distribution. For inputs I have the sample mean, standard deviation, and skewness. I would like to find a way to generate numbers randomly that would fit the skewed normal distribution described by the inputs. Some information about skewed normal distributions can be found here: ...
View Replies!
View Related
Lottery Number Generator
Does anyone know of an Excel macro or function that can generate say 1000 strings of 6 numbers from 1 to 49, without repeating the same combinations? Kind of like the random picks that lottery machines generate.
View Replies!
View Related
Randomly Select From Alphabet Based On Letter Frequency Distribution
I want to randomly select letters from this distribution (to make random words) but I want the more frequent letters in the distribution to be selected more often so that the word I form have the same distribution. I have the feeling there is a simple solution to this but I couldn't see anything other than the frequency function that I thought I might be able to use. I could populate an array with letters present in numbers according to their frequency and then randomly select from it but is there a more elegant solution? .......
View Replies!
View Related
Random Number
How do I make a row of 5 random numbers in A2:A6 that are not the same as each other. It's basically for a Bingo card. I have a formula that can calculate the random numbers =INT(RAND()*15)+1 under the B's for example, but I can't seem to figure out how to make it so they are not the same.
View Replies!
View Related
Random Number Select
I need a macro that will select a random number between 1 and 6. ie select the number of a dice. It needs to input 1 random value into one cell and another random value into another. Like the dice values of a monopoly game.
View Replies!
View Related
Generate Random Number
is if there is a way to generate random numbers between 0001 and 9999. I always need to always have 4 digits. The first couple of numbers can be 0 so that I can maximize the number of variations.
View Replies!
View Related
Recalculating A Random Number
I am using the data analysis addin to generate a random number (using the random number generation) using a normal distribution. The problem is, i want it to recalculate these numbers every time the worksheet is recalculated but the numbers seem to be values only.
View Replies!
View Related
Generate Random Number Between
i have worked in access using vba procedures. i can easily create a form in access that generates a random integer number between 0 and 20 and the user will guess the number between 1 to 20 if the random number is 16 and the user enters 14 the program will display a msg box saying too low or too high. here is the code . Option Explicit Private Const MAX = 20 Private Const MIN = 1 Private iKey As Integer Private lTries As Long Private Function Random() As Integer Random = CInt(Int((MAX  MIN + 1) * Rnd() + MIN)) End Function Private Sub cmdGuess_Click() Dim lGuess As Long now i have to do the same thing in excel create a program that will ask the user to enter numbers between 0 to 20 and see if the random number and user guess is same or not. but i have never worked in excel using vba procedures how can i achieve the same thing in excel using a vba procedures.
View Replies!
View Related
Random Number On Specified Date
I have a random number generater but it creates a new random number whenever I recalculate the sheet or enter something in another cell. I would like it to choose a random number once and not do it again until a condition, specificaly a date, is met.
View Replies!
View Related
Timer On Random Number
how to put time delay on my program? like it will generate again every 9 minute? Private Sub CommandButton1_Click() Dim x As String, i As Byte Randomize x = Format$(Int(Rnd * 1899) + 1, "0000") For i = 1 To Len(x) Me.Controls("TextBox" & i).Value = Mid$(x, i, 1) Next End Sub
View Replies!
View Related
MC W/Random Number Generation
I get the following error whenever I try running a Monte Carlo simulation with iterations in excess of 64000 (The MC simulation calls the 'NormSInv' worksheet function at least once per iteration, and the argument to the 'NormSInv' function is always a standard normal RANDOM number also generated by Excel VBA): Runtime error '1004': Unable to get the NormSInv property of the WorksheetFunction class Why do I inevitably encounter this error ONLY when the number of iterations exceeds 64000, for instance? Simulations with iterations < 64000 run smoothly without a glitch.
View Replies!
View Related
Advanced Random Number Generation
I understand how RAND and RANDBETWEEN work, but have a slightly more complicated random number generation problem that requires a number that isn't solely between two numbers. I have one cell that is randomly generating a number between 0 and 350 (we'll call this value A) and another randomly generating a number between 0 and 15 (value B). Then, I have a third cell (value C) that equals 15 minus B. Where I am having trouble is with a fourth cell (value D). This cell I want to have randomly generate a number between 0 and 350 but it needs to be D less than the value in A or C more than the value in A. Is there an advanced random number generation technique that can solve this?
View Replies!
View Related
Generate A Random 9 Digit Number
I have a spreadsheet with approx 11,000 rows and I would like to generate a unique 9 digit number for each line. I know I could just put 100 000 000 and then increase that by one all the way down but I was wondering if there was any formula or code
View Replies!
View Related
Generating Random Number List
I have a spreadsheet of 1000+ companies and I want to take a random sampling of 100 of them. I would assume this could be accomplished by autofilling a numerical value to each line of data (which I did), then scrambling only the column with the numbers (which I can't figure out), and then selecting the entire text and resorting it to put the numbers back in order and then just work with the first 100 rows (which I can do, if I knew how to make the numbers random).
View Replies!
View Related
Random Secret Number And Then Guessing
The assignment is basically to do a module that first picks a random number between 1100 and then the user should guess what number it is. If the guessed number is below/higher the real number then a MessageBox should appear and say if its too low or to high.
View Replies!
View Related
Random Number Generated By % Criteria
how to use the random number generator to generate unique numbers (155) based on the odd percentages in the attached chart. for example in the chart, chances 1 through 10 are more likely to be generate first rather then the last chance number 55 based on the draft pick odds....
View Replies!
View Related
Static Random Number On Demand
I am using =randbetween(1,100). however everytime i enter a new number elsewhere on the sheet, a new ndom number is made. Could you make a button (or something) that, when pressed, creates a random number in a certain cell?
View Replies!
View Related
Interesting Question  Random Number Generation
it is possible to generate a completely random number generation in excel? Other than using the rand() function and then sorting by top or bottom (as then have affected the sample by choosing which direction it is sorted). And the randbetween() function changes everytime you modify a cell.
View Replies!
View Related
Formula To Return Random Number From A List And Associated Name
My objective is to take two different random counts of numbers written in column b, ranging from B9:B66. However I want to highlight the specific fields listed in the example below, and pull random numbers from those selected fields only. Then I want to pull another set of random numbers in the same column B9:B66, however using a different specific set of fields within column B; as shown in the second random formula string. Use the Press 9 feature to randomly select the two different numbers. What this attempt is trying accommplish is selecting one boy, one girl who have assigned numbers adjacent to their names(name field populated in column c). What am I doing in correctly? HTML Formula written to B70 =INDEX(B9:B66,RANDBETWEEN(1,COUNTA(B9,B13,B15,B16,B17,B20,B21,B23,B25,B31,B33,B34,B35,B37,B38,B39,B41,B42,B44,B45,B47,B50,B51,B52)),1) Formula written to B72 =INDEX(B9:B66,RANDBETWEEN(1,COUNTA(B10,B11,B12,B14,B18,B19,B22,B24,B26,B27,B28,B29,B30,B32,B36,B40,B43,B46,B48,B49,B53,B54,B55,B56)),1)
View Replies!
View Related
Producing Random Number, Then Another With No Common Factors
This is kind of an extension to a previously solved post. For a similar problem I used the attatched file (which someone from here so kindly came up with  but to be honest i dont fully understand), but now im getting onto numbers from 1 to 100 so could get very confusing in the table! RANDOM TABLE2.xlsx Basically I want to produced a random number, (which I have managed) then another number, but it cant have any common factors as the first. So 1st = 10, 2nd = 13 is acceptable but 1st = 22, 2nd = 12 is not. I have managed to do it with smaller values by just typing then out, but this is a very long winded technique, but is there a formula that can do this?
View Replies!
View Related
How Do You Create A Unique Random Number W/o Duplicates
I'm needing to generate a unique random value for a database with 3546 cases. The unique random values cannot be duplicates of each other. I tried the =RANDLOTTO function that I learned of in an old post on this board, but that results in "#NAME?" appearing in the first cell. I tried to install the AddIns (both the Analysis ToolPak and the Analysis ToolPak  VBA, but nothing seems to happen. Is there another way to generate these numbers?
View Replies!
View Related
