Monte Carlo Spreadsheet Simulation using Resampling
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 wi...
Saved in:
Main Author: | |
---|---|
Format: | text |
Language: | English |
Published: |
Institutional Knowledge at Singapore Management University
2007
|
Subjects: | |
Online Access: | https://ink.library.smu.edu.sg/sis_research/1196 http://dx.doi.org/10.1287/ited.7.3.188 |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
Institution: | Singapore Management University |
Language: | English |
id |
sg-smu-ink.sis_research-2195 |
---|---|
record_format |
dspace |
spelling |
sg-smu-ink.sis_research-21952010-12-22T08:24:06Z Monte Carlo Spreadsheet Simulation using Resampling LEONG, Thin Yin 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. 2007-01-01T08:00:00Z text https://ink.library.smu.edu.sg/sis_research/1196 info:doi/10.1287/ited.7.3.188 http://dx.doi.org/10.1287/ited.7.3.188 Research Collection School Of Computing and Information Systems eng Institutional Knowledge at Singapore Management University Monte Carlo simulation spreadsheet resampling Computer Sciences Numerical Analysis and Scientific Computing |
institution |
Singapore Management University |
building |
SMU Libraries |
continent |
Asia |
country |
Singapore Singapore |
content_provider |
SMU Libraries |
collection |
InK@SMU |
language |
English |
topic |
Monte Carlo simulation spreadsheet resampling Computer Sciences Numerical Analysis and Scientific Computing |
spellingShingle |
Monte Carlo simulation spreadsheet resampling Computer Sciences Numerical Analysis and Scientific Computing LEONG, Thin Yin Monte Carlo Spreadsheet Simulation using Resampling |
description |
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. |
format |
text |
author |
LEONG, Thin Yin |
author_facet |
LEONG, Thin Yin |
author_sort |
LEONG, Thin Yin |
title |
Monte Carlo Spreadsheet Simulation using Resampling |
title_short |
Monte Carlo Spreadsheet Simulation using Resampling |
title_full |
Monte Carlo Spreadsheet Simulation using Resampling |
title_fullStr |
Monte Carlo Spreadsheet Simulation using Resampling |
title_full_unstemmed |
Monte Carlo Spreadsheet Simulation using Resampling |
title_sort |
monte carlo spreadsheet simulation using resampling |
publisher |
Institutional Knowledge at Singapore Management University |
publishDate |
2007 |
url |
https://ink.library.smu.edu.sg/sis_research/1196 http://dx.doi.org/10.1287/ited.7.3.188 |
_version_ |
1770570871832838144 |