NABET, NABET 2014 FACULTY

Font Size: 
Implementing Spreadsheet-Based Monte Carlo Simulations in Business Education: Where and How
Mark H Haney

Last modified: 2014-10-24

Abstract


Monte Carlo simulation is a useful technique for analyzing business situations that have an element of risk or uncertainty. In recent years, academics have begun to use Monte Carlo simulation in the classroom, providing business students with knowledge of this useful technique, and helping them to better understand risk and its effects on business outcomes. This presentation reviews the use of Monte Carlo techniques in business and business education, provides guidance on how to implement Monte Carlo models in spreadsheets without the use of proprietary add-ins or Visual Basic for Applications programming, and suggests several topics in the business curriculum where Monte Carlo simulation activities may be introduced to help students better understand concepts, and/or to better prepare students for real-world practice. Several examples will be demonstrated. Audience members will learn the basic techniques necessary to implement Monte Carlo simulation activities in their classes.


Keywords


Monte Carlo Simulation