Monte Carlo Spreadsheet Simulation using Resampling

Publication Type

Journal Article

Publication Date

2007

Abstract

The ubiquitous spreadsheet can be used to model situations with random values, in what is commonly referred to as Monte Carlo simulation. For simple cases, adding random functions (like ExcelTM’s RAND) is enough. In general business models, complex inverse distribution functions, in combination with RAND, are needed to generate the right random values. But first the modeler must determine the appropriate best-fit distribution to use. This can be a daunting process for undergraduates and typical executives. So for expediency, simulation add-ins (with the additional learning time and possible costs) may be employed. The use of add-ins however makes the modeling less transparent. A more direct alternative is to resample the raw data, which in many cases are not sufficient in numbers to establish statistical goodness of fit. This paper reviews the limitations of current spreadsheet resampling methods and proposes new simple yet effective formulations that better accommodate the classroom and practical real-world applications.

Keywords

Monte Carlo simulation, spreadsheet, resampling

Discipline

Computer Sciences | Numerical Analysis and Scientific Computing

Research Areas

Information Systems and Management

Publication

INFORMS Transactions on Education

Volume

7

Issue

3

First Page

188

Last Page

200

ISSN

1532-0545

Identifier

10.1287/ited.7.3.188

Publisher

INFORMS

Additional URL

http://dx.doi.org/10.1287/ited.7.3.188

Link to Full Text

Share

COinS