×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Monte Carlo Analysis
3

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 ?
Replies continue below

Recommended for you

RE: Monte Carlo Analysis

Can you just make your own?

RE: Monte Carlo Analysis

tonycatterall,

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

There are two products that I know of, both Excel add-ins: @Risk and Crystal Ball. Never had the occasion to actually use either of them, but have seen demos.

Biber Thermal Design
www.biberthermal.com

RE: Monte Carlo Analysis

I have used the Monte Carlo method, but not in risk 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

A relatively inexpensive Excel add-in for Monte Carlo analysis can be obtained at:  www.analycorp.com

RE: Monte Carlo Analysis

@Risk ANalysis from Palisade tool is a good pakage running MCS that can be add in Excel and some programming software.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

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.

Join Us             Close