Exercises / Statistics that matter at work · 1 of 6
The typical salary, not the average
MEDIAN returns the middle value once the numbers are sorted. One very large value pulls the AVERAGE up, but barely moves the median, which is why salaries and house prices are reported as medians.
Your taskThe founder's salary is in the list. In E2, use MEDIAN to return the median salary of B2:B10.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Employee | Salary | Measure | Value | |
| 2 | Analyst | $52,000.00 | Median | ||
| 3 | Designer | $58,000.00 | |||
| 4 | Engineer | $74,000.00 | |||
| 5 | Engineer | $78,000.00 | |||
| 6 | Marketer | $55,000.00 | |||
| 7 | Support | $41,000.00 | |||
| 8 | Sales | $63,000.00 | |||
| 9 | Manager | $89,000.00 | |||
| 10 | Founder | $420,000.00 |