×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# Monte Carlo Analysis3

## 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

### 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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!