research Question

Implementing Random Number Generators with Specified Distributions and Distribution Parameters in Excel

Avatar of hypercube
hypercubeFlag for United States of America asked on
Microsoft OfficeMath / ScienceMicrosoft ExcelStatistical Packages* random
7 Comments1 Solution23 ViewsLast Modified:
I'm working with Excel workbooks and running Monte Carlo simulations which require random number generators.  Each random number generator is used to represent real data for which we have history - and so, can extract a likely distribution and its parameters using Analytic Solver.
With that, we can (conceptually) create an Excel formula to generate random numbers with the same distribution.

I find that matching formulations for such RNGs is elusive at times.
I was able to Google and find a formula for the Weibull distribution and am able to extract the needed parameters with an analysis program run on the historical data.  Normal distribution too.  
But, this isn't always the case.

There are really two questions here:

1) What is a formula that I can use in Excel to generate random numbers with a Pearson 5 distribution?
2) Where might one look to find Excel formulas for generating random numbers with each of a variety of distributions?
3) Or is there some transformation technique that generalizes this requirement leading to Excel formulas (I rather have to doubt it).
I want to do this in Excel without commercial add-ins because I have users with production Excel workbooks.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros