# Random Number Generator Based On Weibull Distribution

Sep 10, 2007
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 9 Replies
ADVERTISEMENT
Oct 29, 2009

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 9 Replies
View Related
May 9, 2003

Confidence level calculation.

Background Info: I am doing a weibull analysis on failure data. Some of the data is right censored. I have already run a maximum likelihood estimate to obtain the estimated weibull parameters with Excel's SOLVER function. I am good on this part.

Now I want to calculate these parameters with a 95% confidence interval. I can't seem to find information on calculating confidence intervals with right censored data.

View 4 Replies
View Related
May 12, 2007

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 9 Replies
View Related
Oct 9, 2008

how to create a basic random number generator within an excel spreadsheet?

Basic Lower limit = 0

Basic Upper limit = 100

View 9 Replies
View Related
Jan 27, 2009

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 9 Replies
View Related
Jul 19, 2006

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 6 Replies
View Related
Feb 27, 2007

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 9 Replies
View Related
Nov 27, 2007

I would like to create a random number based on that data.

View 3 Replies
View Related
Jul 1, 2014

I have code that generates random numbers 1 - 90, what I would like is when the command button is pressed the numbers are generated every 5 seconds, I have attached the workbook.

View 5 Replies
View Related
Nov 27, 2013

I have a set of data with index numbers and the percentage of their occurrence. I want to use this percentage to weight the occurrence of the index numbers and create a random list of say 500 occurrences.

Index %

1 7.95

2 3.28

3 7.37

4 38.45

5 28.62

6 14.12

View 8 Replies
View Related
Oct 14, 2011

I've managed to write a random number generator that produces multiple sets with no repeating numbers per a set.

Now, to step it up a notch, I'm trying to create an even distribution of the numbers generated which is where I could use a hand. Here's my current code:

Code:

Option Base 1

Sub RandomNumberStrings()

Dim rndno As String, strg As String, msg1 As String

Dim r1() As String, r2() As String

[Code]....

Equaling 500 numbers generated as intended, but my target is to get every number with an equal frequency.

View 4 Replies
View Related
Oct 6, 2008

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 9 Replies
View Related
Jun 20, 2009

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 14 Replies
View Related
Jan 22, 2012

I need a formula that generates random names that i have in column a (a2:a30) I need the name to be in b1 to j1 there can't be any duplicate names

View 3 Replies
View Related
Jul 11, 2013

I am organizing a sports tournament and would like excel to randomly generate the teams for it.

We have 20 people who will be organized into 10 teams of two. how to setup the formula to have two people randomly paired together without duplication. The names will be further used in other formulas for points calculations.

So, I have the names as A1:A20 and then would like the teams generated from B1:B10 and C1:C10 with the team being the row and the team members in the B and C columns.

View 1 Replies
View Related
Mar 1, 2012

I am trying to create a random name generator. I have tried something like this...

=INDEX('TM Names'!$A$2:$A$36,INT(RAND()*35+1))

But sometimes it will give you the same name 2 or 3 times in a row. I need it to pull up a different name each time, from a list of names I already have.

View 7 Replies
View Related
Apr 18, 2013

In Column A I have a list of 8 team names.

In column AB I have a list of 28 weeks written in date format.

In column B I'd like to chose one week from the 28 weeks listed in AB at random. But B2 - B9 can not have the same date (ie could not have two dates for the 19th of April).

How exactly is that done?

Alternatively - is it possible to have in Column AA the 8 team names. In Column AB the 28 weeks. In Column A a random team picked from column AA and in Column B a random date picked from Column AB. Both column A and Column B can not have duplicates... There's 28 weeks with 8 teams - therefore I only need 8 unique weeks.

View 5 Replies
View Related
Aug 22, 2007

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 9 Replies
View Related
Feb 12, 2008

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 9 Replies
View Related
Jul 2, 2008

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 9 Replies
View Related
Nov 1, 2009

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 9 Replies
View Related
Nov 16, 2009

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 9 Replies
View Related
Nov 25, 2009

I know how to use RAND for numbers, but is it possible to use RAND for letters?

View 9 Replies
View Related
Sep 19, 2006

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 2 Replies
View Related
Feb 14, 2007

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 5 Replies
View Related
Jul 18, 2007

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 3 Replies
View Related
Mar 8, 2008

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 2 Replies
View Related
Mar 30, 2009

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 12 Replies
View Related
Aug 22, 2013

I have a database of at least 350 products, and would like to know how I can use a form button, when clicked it will randomly display a picture of one of the list of products. I want to use this method for a mystery prize draw.

View 14 Replies
View Related
Mar 17, 2014

create a macro that will generate 2 words from the dictionary. The first word needs to start with the letter B and the second word must start with the letter T.

View 1 Replies
View Related
Jun 17, 2013

I have 12 teams, 4 divisions of 3... they play each team in there division twice, and every other team once... What's the easiest way to make something to randomize this automatically? This is for a contest at work that starts over every 13 weeks.

Obviously there can't be any duplicates week to week.

WeekABCDEFGHIJKL

1BAAEDDHGGKJJ

2BAAEDDHGGKJJ

3CCBFFEIIHLLK

4CCBFFEIIHLLK

5DDDAAAAAAAAA

6EEEBBBBBBBBB

[code]....

View 5 Replies
View Related
Jul 27, 2014

I am looking for a product that uses excel to create a random test form a bank of questions. I have 50 questions in all and I need a random test of 35.

I can and have messed around with the following. Excel 2012

A

B

C

D

1

Random #

Test Number

Small-Sort

Random Question

I could even shorten it a bit by placing like this. MATCH(SMALL($A$2:$A$4,B2),$A$2:$A$4,0). Of course this is only the start and it would have in column B 1-50 and in column C&D 1-35 for the selection process. Then I was going to set up on sheet 2 my list of questions 1-50 and my idea was to use 1.1, 1.2, 1.3, & 1.4 for the answers to question 1 and then vlookup. so that when and if question 1 is part of the 35 random then I could pull the answers over as well. but as I started the 'animal' will get bigger and bigger fast.

View 1 Replies
View Related
May 17, 2008

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 9 Replies
View Related
May 2, 2009

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 9 Replies
View Related
Sep 20, 2008

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 5 Replies
View Related
Apr 24, 2014

I am trying to build an excel spreadsheet for a hockey program I'm coaching that will do the following:

Create 4 teamsThere will be a Team 1 White/Dark, and Team 2 White/DarkUse 2 lists to distribute players evenlyThere are a disproportionate amount of players on each list. There are 8 Majors, 12 Minors. 2 Majors maximum need to be on every team.Every week, the roster will be different (some don't show). I need to be able to hit 'randomize' and exclude certain people, and still have the lines 'relatively' similar This is an essence two 3 vs 3 games, with a white vs. dark on each side of the ice (2 half-ice games). If there are 3 majors on each side (6 in attendance), one side will have a white with 2 majors, the other side will have a dark with 2 majors.

I'd also like a way to keep track of who's played with/against who, so if I can export that data set to ensure I don't get a duplicate team...or a primarily duplicate team.

View 4 Replies
View Related
May 30, 2008

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 9 Replies
View Related
Feb 17, 2014

I am in need of a formula to calculate the even distribution of values between two set values over a set number of columns. For example take a look at the attached screenshot. I have the numbers 2.88 and 2.44 and I need to fill in the empty cells between the two with with an even distribution of numbers in between the two (in descending order) over the 8 columns Screen-shot-2014-02-16-at-3.33.08-PM.jpg

View 1 Replies
View Related
May 16, 2006

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 3 Replies
View Related