Statistical Analysis Of A Class: Monte Carlo And Multiple Imputation Spreadsheet Methods For Estimation And Extrapolation

Abstract

The Monte Carlo method and related multiple imputation methods are traditionally used in math, physics and science to estimate and analyze data and are now becoming standard tools in analyzing business and financial problems. However, few sources explain the application of the Monte Carlo method for individuals and business professionals who are not immersed in the realm of mathematics or science. This paper introduces these Monte Carlo methods for the non-mathematician and business student, providing examples where the Monte Carlo method is applied when only small samples are available. Statistical analysis and statistically sound extrapolation of sample characteristics to the larger class population can be facilitated by applying Monte Carlo methods and the related concept of multiple imputation, which is also explained. Appendices provide step-by-step instructions for using two popular spreadsheet add-ins to run Monte Carlo based analysis.