Exercises / Statistics that matter at work · 6 of 6
How many beat the average?
A criteria can include a calculation: ">="&MEDIAN(C2:C9) builds a text such as ">=450" on the fly, so the comparison stays correct as the data changes.
Your taskIn E2, use COUNTIF and AVERAGE to count the stores in B2:B12 whose sales are above the average of B2:B12.
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 | Store | Sales | Measure | Value | |
| 2 | S01 | $1,980.00 | Above average | ||
| 3 | S02 | $2,450.00 | |||
| 4 | S03 | $1,720.00 | |||
| 5 | S04 | $2,121.50 | |||
| 6 | S05 | $2,890.00 | |||
| 7 | S06 | $1,640.00 | |||
| 8 | S07 | $2,215.00 | |||
| 9 | S08 | $1,900.00 | |||
| 10 | S09 | $2,560.00 | |||
| 11 | S10 | $1,850.00 | |||
| 12 | S11 | $2,010.00 |