Excel case study
Which region needs attention?
Real problems with no formula named for you. You decide what to use.
Marketing exported last quarter's numbers, manager names included. Find the lowest conversion rate in the table. You decide how.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Region | Manager | Conversion Rate |
| 2 | North | Priya | 4.8 |
| 3 | South | Owen | 3.1 |
| 4 | East | Lucas | 5.6 |
| 5 | West | Maya | 2.7 |
| 6 | Central | Farah | 4.1 |
| 7 | Lowest rate |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
Real analysis starts messy, with a column (Manager) you never needed. Deciding what to ignore is half the job.
More case studies
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →