How to Generate Random NUmbers With Analysis Toolpak

[zanshin777]

How to generate random numbers with analysis toolpak? There are some lines which I don't know on the Random Number Generation dialog box.

+ Number Of Variables
+ Number Of Random Numbers
+ Value And Probabilty Input Raange


There is an example file.

[MrShorty]

This seems to be representative of the tutorials I see online: http://www.bettersolutions.com/excel...I231420881.htm

number of variables is the same as how many columns you want
number of random number is how many rows to fill
value and probability is under "parameters" and it appears that this is filled by the parameters that define the type of random numbers you are generating. You will need to know enough about the desired random number distribution to know what should go into these fields.