Attached is a very simple tool to help you run an analysis via the Monte Carlo method. Given a model, this tool generates random values and can build a probability distribution of results.
The attached tool brings this capability to the masses, as no coding is required. Simply follow the instructions to identify the proper Copy & Paste sections that would record & aggregate your results, then run the macro to start the analysis.
While I will primarily be posting sports-based examples in this blog, the uses of this approach can be employed in numerous fields. Please drop me an email and let me know how you have employed this tool.
Warning - Widespread use of this kind of analysis should be tempered by knowing what you cannot know.
Monte Carlo Analysis Tool
Original author- Erich
Revision date- 20080920
**Macros must be enabled for full functionality. If you prefer to review the macro code before enabling, open with macros as disabled, open the Visual Basic Editor (Alt+F11) and review the workbook's worksheet and modules.**
.
No comments:
Post a Comment