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

Keywords

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

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.

Downloads

Download data is not yet available.
Abstract 94 | PDF Downloads 87