Work through a connected business scenario. Each correct answer unlocks the next mission until the case study is complete. Want a different role, difficulty, or time commitment? Browse all challenges.
Case Study
The Salary Band Audit
Audit pay bands using range stats and conditional averages so the comp review starts with defensible numbers.
Core Skills
Scenario
People Ops needs a fast pay-band sanity check before managers see the draft compensation ranges. You need to verify the floor and ceiling of one cohort, confirm the midpoint of another, and quantify what remote Customer Success pay looks like across the file.
Current Mission
Find the salary floor for the visible People L3 cohort.
What formula returns the lowest salary in the visible People L3 rows?
Dataset
Work from the table below, then submit the formula or result for the current mission.
Salary Band Audit Roster - rows 1-6
Download CSV| Row numbers | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| Header row | |||||||
| 2 | PEO-301 | Maya Brooks | People | L3 | Phoenix | 71200 | L3-People |
| 3 | PEO-302 | Liam Patel | People | L3 | Remote | 73400 | L3-People |
| 4 | PEO-303 | Nina Foster | People | L3 | Austin | 74850 | L3-People |
| 5 | PEO-304 | Cole Ramirez | People | L3 | Remote | 76500 | L3-People |
| 6 | PEO-305 | Tessa Nguyen | People | L3 | Denver | 78900 | L3-People |
| 7 | PEO-306 | Jordan Kim | People | L3 | Phoenix | 80400 | L3-People |
| 8 |
The visible columns and rows follow the active mission so each step stays focused.
Mission
Find the salary floor for the visible People L3 cohort.
Question
What formula returns the lowest salary in the visible People L3 rows?
Hints
Your Answer