Random Number Generator in Excel

R

Random

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I know that in Office 07, I can generate a column with a specified ammount of random numbers with a specified distribution, specified mean, and a specified standard deviation.

How do I do this in Office 08?
 
M

Mike Middleton

Random -

Windows Excel 2007 has the Random Number Generation tool of the Analysis
ToolPak. Mac Excel 2008 does not.

If you need random numbers from a specific probability distribution, someone
may be able to describe a way to obtain them using functions that are
included in Mac Excel 2008.

For example, you can obtain random numbers from a normal distribution using
=NORMINV(RAND(),mean,stdev)

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a limit to the number possibleworksheets in Excel for the mac? 4
Locking Random Numbers so They Aren't Refreshed with Every New Calculations 6
Generating unique random number 2
random files open upon opening excel 2
Value assigned to text 2
Calculating summary statistics in excel 2
excel changes numbers 1
Problem Inserting Hyperlinks 1

Top