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

Michael V Bernot
Michael V Bernot used Ask the Experts™
on
I would like to use the Random Number Generation Tool of the Analysis Tool Pak to generate 10 random numbers between 1 and 100.  I cannot navigate through the Dialog Box (Tools; Data Analysis; Random Number Generation).  Can someone provide information to allow me to accomplish this task?  NOTE: I do not need to know about the Excel functions to accomplish this same task.  Thank you for your help
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
Do you mean a formula like:

=RANDBETWEEN(1,100)

Chris

Author

Commented:
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@
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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?
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
>>> 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

Commented:
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

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

Author

Commented:
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
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
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

Open in new window

Commented:
I need to know which distribution you want to use.  The form changes based on the distribution.
Commented:
the only distribution that is straight forward is the uniform.  Once you have selected Random Number Generator from the analysis toolpak.  Switch the distribution to Uniform.  From there the top box should have 1 variable, the next box should have 10, then the drop down should still say uniform, the next two should say 1 and 100, then you can leave the random seed blank, then choose your output method.

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial