Unit 6 • Lesson 60.9h
Data Tables: Sensitivity Analysis
Students learn to use Data Tables to answer 'What-If' questions instantly—seeing how profit changes across many price/volume combinations at once.
What You'll Learn
- ▶Build a one-variable Data Table to see how profit changes across a range of prices or volumes
- ▶Build a two-variable Data Table to see profit changes across combinations of price and volume
- ▶Interpret sensitivity results to identify which inputs matter most
- ▶Communicate pricing risk using the sensitivity matrix
Key Concepts
One-variable Data Table for single-input sensitivity
Two-variable Data Table for dual-input matrix
Data Table setup: row input cell vs. column input cell
+2 more concepts
Lesson Phases
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Witness the power of 'What-If' analysis: See every pricing outcome at once.
Introduction
Master Data Table mechanics: One-variable and two-variable sensitivity.
Guided Practice
Practice the Data Table setup in a safe simulator.
Independent Practice
Build the Sensitivity Matrix in your Excel workbook.
Assessment
Verify Data Table mechanics and interpret pricing risk.
Closing
Reflect on sensitivity analysis and prepare for integration.
How You'll Learn
Business scenario driving tool necessity
Direct instruction on Data Table mechanics
Safe rehearsal before real workbook build
Independent practice with sensitivity analysis