We found a match
Your institution may have rights to this item. Sign in to continue.
- Title
An Interactive Tool to Teach Monte-Carlo Simulation and VBA.
- Authors
Grinde, Roger B.
- Abstract
This paper presents an author-developed interactive tool that can be used to help students develop and run spreadsheet-based Monte-Carlo Simulation models, with output statistics automatically calculated. The software also provides the instructor the ability to help students learn some aspects of Visual Basic for Applications (VBA). Unlike commercial alternatives, it requires no special installation, and runs on both Windows and OS X versions of Excel. Students can quickly use it productively. The simple results screen and its interactive nature give it some advantages over commercial and native Excel simulation approaches for the classroom environment. Download links for the tool and an example file are provided.
- Subjects
SPREADSHEET software; MICROSOFT Visual Basic (Computer program language); INTERACTIVE computer systems; MONTE Carlo method; CLASSROOM environment
- Publication
Business Education Innovation Journal, 2018, Vol 10, Issue 1, p107
- ISSN
1945-0915
- Publication type
Article