Contact US

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 Simulation

Monte Carlo Simulation

Monte Carlo Simulation


I need some help. I'm trying to run a true position tolerance analysis using the Monte Carlo method. I have googled it and haven't found much help. can anyone recommend or have some useful information on how to do one of these simulations using excel?

RE: Monte Carlo Simulation

Sure . Monte carlo means that instead of using a structured approach for selecting the settings for factors in a multirun experiment, the factor setting is random in each run.

this has the advantage that if one setting for one factor causes a failed run, at least it is likely to be just one run, instead of several in structured experiment.


Greg Locock

New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?

RE: Monte Carlo Simulation


- tends to excessively explore the near centre region, which is often not very interesting

-needs more runs than say D optimal

-statistically it is not as neat - analysis involves a PCA type approach instead of just adding and subtracting columns


- if you decide to curtail, or expand, the number of runs then it is still meaningful, whereas in a taguchi style designed experiment it is difficult (but not impossible) to make use of runs from a smaller experiment.

-less likely to wipe out many runs due to one bad setting for one factor.


Greg Locock

New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?

RE: Monte Carlo Simulation

You can use Excel to run a Monte Carlo simulation if you have some existing manufacturing data. The inputs would be things like the mean and the standard deviation.

The Excel funtion to use is typically NORMINV(probability, mean, standard_dev). This returns the inverse of the normal cumulative distribution for a specified mean and standard deviation, along with a weight factor (the probability). If you use RAND() in place of probability, and use the expected process capability to predict the standard_dev (such as the total tolerance divided by 3, assuming a 3-sigma process), you can create a series of cells corresponding to each dimension or variable in your stack. Then you have the computer run thousands of trials and show the overall average and standard deviation.

A monkey wrench in your scenario will be if the position tolerance has any modifiers such as "M" -- the extra bonus or shift tolerance can be accounted for, but it gets a little tricky.

John-Paul Belanger
Certified Sr. GD&T Professional
Geometric Learning Systems

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


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