Monte Carlo Analysis
Monte Carlo Analysis
(OP)
Do any of you guys out there know of any Excel based programs for carrying out Monte Carlo type risk analysis ?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Monte Carlo Analysis
RE: Monte Carlo Analysis
You may wish to visit the thread Monte Carlo Simulation (Thread768-55453) from the forum:
Project & Configuration Management > Project & Configuration Management > -Engineering Project Management Forum (Forum768)
Best regards,
Matthew Ian Loew
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.
RE: Monte Carlo Analysis
Biber Thermal Design
www.biberthermal.com
RE: Monte Carlo Analysis
If all you want to do is to generate a set of numbers for a variable with a certain
distribution for which you set the mean and the standard deviation, then
select a column of length N, then pick Data Analysis from the Tools menu,
then the Random Number Generator, OK , then fill in the nnumber of variables
=1 for one column, then N for the number of random numbers and type
Normal for distribution ( other options exist , I just like to specify the Sigma
and Mean), and indicate where you want the generated data to be put and Voila!
Hope this helps.
RE: Monte Carlo Analysis
RE: Monte Carlo Analysis