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.


    Zugriff

    Zugriff prüfen

    Verfügbarkeit in meiner Bibliothek prüfen

    Bestellung bei Subito €


    Exportieren, teilen und zitieren



    Titel :

    Conducting Monte Carlo Analysis with Spreadsheet Programs


    Weitere Titelangaben:

    Sae Technical Papers


    Beteiligte:
    Bartlett, Wade (Autor:in)

    Kongress:

    SAE 2003 World Congress & Exhibition ; 2003



    Erscheinungsdatum :

    2003-03-03




    Medientyp :

    Aufsatz (Konferenz)


    Format :

    Print


    Sprache :

    Englisch




    Conducting Monte Carlo Analysis with Spreadsheet Programs

    Bartlett, W. / Society of Automotive Engineers | British Library Conference Proceedings | 2003


    Conduction Monte Carlo Analysis with spreadsheet programs

    Bartlett,W. / Mechanical Forensics Engineering Services,US | Kraftfahrwesen | 2003


    Economic Comparison of Processes Using Spreadsheet Programs

    Ferrall, J. F. / Pappano, A. W. / Jennings, C. N. | NTRS | 1986



    Knowledge-based thermal analysis spreadsheet

    Bridge,D.R. / Motor Industry Research Assoc.,MIRA,GB | Kraftfahrwesen | 2003