How do I use Random Number Generation Tool (Analysis Took Pak)?

Do you mean a formula like:

=RANDBETWEEN(1,100)

Chris

No.....I was hoping to understand the Random Number Generation tool.  

Hi,

Just type =RANDBETWEEN(1,100) in the cell you need the random number

M@

Try reloading the Analysis Tool Pak:

On the Tools menu, click Add-Ins.
In the Add-Ins available box, un-select the check box next to Analysis Toolpak, and then click OK.
Restart Excel
In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.

Is there a reason why you're not using the RANDBETWEEN function?

>>> what do you mean by:

No.....I was hoping to understand the Random Number Generation tool#

If literally that then look at:
http://support.microsoft.com/kb/q828795

Chris

The Excel random number generator used to have problems with its results.  As did many other statistical functions.  I do not follow this debate, merely the messenger.  I use MATLAB for this kind of work so I can not elaborate further.
Yes I know the following article is from 2000.
http://www.agresearch.co.nz/science/statistics/exceluse1.htm

http://www.bettersolutions.com/excel/EUN147/YI231420881.htm
That links to a short article how to use the tool

msheskey...if you could tell me how to fill in the Random Number Generation dialog box to accomplish my task that would be great (10 random numbers between 1-100).  Thank you

If you want some VBA to generate some values then:

Chris

Sub myRand()
Dim MyValue
Dim looper As Integer
Dim str As String

    Randomize
    For looper = 1 To 10
        str = str & Int((100 * rnd) + 1) & vbCrLf
    Next
    MsgBox str
End Sub

Select allOpen in new window

I need to know which distribution you want to use.  The form changes based on the distribution.

Thank you for answering my question and providing the link of the possible shortfalls.