Day 44

Task:

You handle compensation analysis in HR at a marketing agency, checking pay equity ahead of a scheduled review. Six base salaries are listed below: five marketing specialists and the department director. In C8, report the median base salary across all six people — the figure HR will actually quote, since the director's salary sits well above the specialists' and would drag a plain average upward. In C9, work out that plain average for comparison, so the gap between the two is visible. In C10, work out the standard deviation of just the five specialists' salaries, to show how tightly clustered a typical specialist's pay actually is.