Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










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 1-4 to 1-100. 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 Formula
I have 4 names, and a grid of 100 boxes. I need those 4 names randomly deposited in the 100 boxes, making sure each name is displayed an equal number of times (25 each) Is there an Excel formula to compute this?

View Replies!   View Related
Basic Random Number Generator
how to create a basic random number generator within an excel spreadsheet?

Basic Lower limit = 0
Basic Upper limit = 100

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 Within Normal Distribution
I would like to create a random number based on that data.

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
How Do I Use VBA Timer Subroutines To Start And Stop Random Number Generator
As you can see below, I've written code that writes random numbers into three columns of a spreadsheet (10 numbers in each column).

What I want to do is create code that will run the random number generator for a period of 1 minute and then stop. I know that I will need to write a timer subroutine to do this but I'm how unsure how to do this.

View Replies!   View Related
Random Name Generator
I'd like a spreadsheet that pulls out a random name.

I'll put in a lookup table, George, Fred, Ralf, Steve, Peter.

Sometimes Fred will come up, sometimes George will.

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 Letter Generator
I know how to use RAND for numbers, but is it possible to use RAND for letters?

View Replies!   View Related
Random Cell Generator ...
I have a list of 200 comments in column B (B1:B200). In a seperate sheet I want to be able to add a function that calls a comment randomly.

So evertime I hit F9 the comment changes.

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: A-F. 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
To Make A Random Word Generator
I know you can make a random number generator pretty easily in excel...but is it possible to make a random word generator? I will give the words I want randomly generated.

View Replies!   View Related
Random Message Box Generator
i want is a way, on clicking a button on my userform, where i can bring up a quote randomly picked from a list of quotes and sayings which I will input.

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
Distribution Functions; Know The Each Number's Rank Within The Range
I don't know anything about the distribution functions, but I have a range of numbers and I need to know each number's rank within the range. I believe that's related to distribution, so if someone could tell me how to go about calculating that (with or without those particular functions)

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 Counting
If I generate a random number in cell A1 ranging from 1 to 3. Can I count how many times the result is equal to 2 if I was to run it 100 times and then show the results in cell A3.

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
Create Random Number From 3-10
I have a formula to generate a random number between 0 and 10.

View Replies!   View Related
Random Number In VBA
How can I make sure that I can generate random numbers that don't repeat using the rnd function in VBA.

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 add-in 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
Random Number Selection...
random number selection...

i have a list of 200 items (rows) and i would like to "randomly" select 30 of them...(next month i will get another 200...)

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): Run-time 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
Select Random Number From List
Say I have a list of 100 numbers (in column A). What formula would I use to have Excel list (in column B) 50 random numbers from the list of 100 or column A?

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 auto-filling 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
Formula- Creates Random Number
i have the formula =CHAR(INT(RAND()*25)+65) which creates random number when dragged from say C1 TO C6 however i need the 3rd 4th or 5th character to be a random number between one and 9 is this possible?

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 1-100 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 (1-55) 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 Add-Ins (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
Copyright © 2005-08 www.BigResource.com, All rights reserved