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

Main Article Content

Laurel J. Fish
Dennis Halcoussis
G. Michael Phillips


Monte Carlo Method, Multiple Imputation, Small Samples, Analysis of a Class, Spreadsheets


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.


Download data is not yet available.
Abstract 386 | PDF Downloads 262

Most read articles by the same author(s)

1 2 > >>