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.
Conducting Monte Carlo Analysis with Spreadsheet Programs
Sae Technical Papers
SAE 2003 World Congress & Exhibition ; 2003
2003-03-03
Conference paper
English
Conducting Monte Carlo Analysis with Spreadsheet Programs
British Library Conference Proceedings | 2003
|Conduction Monte Carlo Analysis with spreadsheet programs
Automotive engineering | 2003
|Knowledge-based thermal analysis spreadsheet
British Library Conference Proceedings | 2003
|