Browse Publications Technical Papers 2003-01-0487
2003-03-03

Conducting Monte Carlo Analysis with Spreadsheet Programs 2003-01-0487

Monte Carlo analysis has been shown to be a powerful tool for evaluating confidence limits and probability distributions for values calculated during the analysis of vehicle accidents. Using this tool has generally required specialized software. This paper presents a method of using the tools provided with most simple spreadsheet programs to conduct Monte Carlo analysis with both evenly distributed and normally distributed variables for cases where the equations can be expressed in closed form. The accuracy one can expect given a particular number of trials is discussed. Example analyses using both even-probability and normal-probability variables are shown.

SAE MOBILUS

Subscribers can view annotate, and download all of SAE's content. Learn More »

Access SAE MOBILUS »

Members save up to 18% off list price.
Login to see discount.
Special Offer: Download multiple Technical Papers each year? TechSelect is a cost-effective subscription option to select and download 12-100 full-text Technical Papers per year. Find more information here.
We also recommend:
JOURNAL ARTICLE

Sensitivity of Monte Carlo Modeling in Crash Reconstruction

2010-01-0071

View Details

TECHNICAL PAPER

On-the-Spot Investigation of Negotiation Patterns of Passing Cars without Right of Way at a Non-Signalized Intersection

2007-01-3599

View Details

TECHNICAL PAPER

Evaluating Uncertainty in Accident Reconstruction with Finite Differences

2003-01-0489

View Details

X