One month of falls-by-location data. Find the "vital few" locations that make up roughly 80% of all falls — and unlock the code.
Teams are given one month of falls-by-location data and must complete a Pareto analysis: calculate each location's share of total falls, order from largest to smallest, and identify which locations make up roughly 80% of all falls (the "vital few").
If you are struggling to understand this puzzle, or simply want to learn more about Pareto charts, here are some useful links:
Falls recorded by location over one month:
| Location | Falls in the month |
|---|---|
| Total | — |
Order the locations from largest to smallest, then calculate each location's % share of total falls and the running cumulative %. Fill in your numbers below (round to the nearest whole %), then check your work.
| Location | Falls | Your % share | Your cumulative % |
|---|
Tick the location(s) whose cumulative % first reaches roughly 80% of all falls — these are the "vital few" that improvement effort should focus on.