Case Detail

Case Summary

How to Perform Sensitivity Analysis with a Data Table

Case Number: 7-404-752, Year Published: 2011, Revision Date: August 25, 2011

HBS Number: KEL151

Request PreviewBuy

Authors: Mark Jeffery

Abstract

This technical note answers a common student question: How to create a multi-dimensional data table in Excel for a return on investment sensitivity analysis? This note accompanies the B&K Distributors case, and is handed out as part of the case debrief.

Number of Pages: 6

Extended Case Information

Teaching Areas: Management, Statistical Methods