This content is not included in
your SAE MOBILUS subscription, or you are not logged in.
Conducting Monte Carlo Analysis with Spreadsheet Programs
Technical Paper
2003-01-0487
ISSN: 0148-7191, e-ISSN: 2688-3627
Annotation ability available
Sector:
Language:
English
Abstract
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.
Recommended Content
Authors
Citation
Bartlett, W., "Conducting Monte Carlo Analysis with Spreadsheet Programs," SAE Technical Paper 2003-01-0487, 2003, https://doi.org/10.4271/2003-01-0487.Also In
Accident Reconstruction from the SAE 2003 World Congress on CD-ROM
Number: SP-1773CD; Published: 2003-03-03
Number: SP-1773CD; Published: 2003-03-03
SAE 2003 Transactions Journal of Passenger Cars - Mechanical Systems
Number: V112-6; Published: 2004-09-15
Number: V112-6; Published: 2004-09-15
References
- Pilana Sabri History of Monte Carlo Method http://stud2.tuwien.ac.at/∼e9527412/history.html
- Computational Science Education Project “Intro to Monte Carlo Methods,” http://csep1.phy.ornl.qov/mc/mc.html
- Schlaifer Robert Analysis of Decisions Under Uncertainty McGrawHill New York 1969
- Hammersley J. Handscomb D. Monte Carlo Methods Chapman & Hall 1965
- Brach Raymond Uncertainty in Accident Reconstruction Calculations SAE Paper 940722
- Tubergen R. The Technique of Uncertainty Analysis as Applied to the Momentum Equation for Accident Reconstruction SAE Paper 950135
- Wood Denis O'Riordain Sean Monte Carlo Simulation Methods Applied to Accident Reconstruction and Avoidance Analysis SAE paper 940720
- Kost Garrison Werner Stephen Use of Monte Carlo Simulation Techniques in Accident Reconstruction SAE Paper 940719
- Rose Nathan Fenton Stephen Hughes Christopher Integrating Monte Carlo Simulation, Momentum-Based Impact Modeling, and Restitution Data to Analyze Crash Severity SAE Paper 2001-01-3347
- Moser A. et al Application of the Monte Carlo Methods for Stability Analysis within the Accident Reconstruction Software PC-CRASH SAE 2003
- Crystal Ball 1515 Arapahoe Street, Suite 131, Denver, CO 80202
- Palisade Corporation 31 Decker Road, Newfield New York, 14867 http://www.palisade.com
- Vanguard Software Corp 1100 Crescent Green, Cary NC 27511 http://www.vanguardsw.com/decisionpro/
- Excel
- http://support.microsoft.com/default.aspx?scid=KB;EN-US;q86523&
- http://archive.ncsa.uiuc.edu/Apps/CMP/RNG/RNG-home.html
- Carter Everett Jr. Walks Random Markov Chains and the Monte Carlo Method Taygeta Scientific Inc. 1340 Munras Ave., Suite 314, Monterey, CA. 93940 www.taygeta.com/rwalks/node5.html
- Rand Corporation 0-8330-3047-7 1955 www.rand.org/
- http://www.random.org/
- Gillespie Thomas Fundamentals of Vehicle Dynamics SAE Warrendale PA 1-56091-199-9 1992
- Bartlett Wade Wright William Masory Oren Brach Raymond Baxter Albert Schmidt Bruno Navin Frank Stanard Terry Quantifying The Uncertainty in Various Measurement Tasks Common to Accident Reconstruction SAE Paper 2002-01-0546
- Hald Anders Statistical Theory with Engineering Applications John Wiley & Sons New York 0471340561 1952
- Lindgren B.W. McElrath G.W. Introduction to Probability and Statistics Macmillan Company 1959
- Díiaz-Emparanza Ignacio Is a Small Monte Carlo Analysis a Good Analysis? Statistical Papers Springer-Verlag 2002
- Ang Alfredo Tang Wilson Probability Concepts in Engineering Planning and Design, Design, Risk, and Reliability II John Wiley and Sons New York 0-471-03201-8 1984