Scenario Analysis in Spreadsheets with Excel's Scenario Tool
Ina S. Markham - markhais@jmu.edu
Susan W. Palocsay - palocssw@jmu.edu
MS Department, MSC 0202, College of Business, James Madison University, Harrisonburg, Virginia 22807
Abstract
"What-if" or sensitivity analysis is one of the most important and valuable concepts in management science (MS). To emphasize its practical relevance in a business environment, we teach students in our introductory MS course to analyze "scenarios" with Excel's built-in Scenario tool. This paper demonstrates the application of the Scenario tool with several examples.
Download the PDF
10.1287/ited.6.2.23
Supplement File
Citation Information
Markham, I. S. Palocsay, S. W. 2006. Scenario Analysis in Spreadsheets with Excel's Scenario Tool. INFORMS Trans. Ed. 6(2) 23-31. Available online at http://ite.pubs.informs.org/.
DOI: 10.1287/ited.6.2.23