Build your own Monte Carlo spreadsheet
This article gives instructions for building a simple but general purpose spreadsheet for collating Monte Carlo (MC) outputs using a VBA macro. Two user defined functions for sampling with and without replacement give the spreadsheet the facility to do a variety of resampling and permutation tests,...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Bond University
|
| Series: | Spreadsheets in Education |
| Online Access: | http://sie.scholasticahq.com/article/4672-build-your-own-monte-carlo-spreadsheet.pdf |