Exercises / Statistics that matter at work · 5 of 6
The best-selling shoe size
MODE.SNGL returns the value that appears most often in a range. It answers questions like "which size do we sell most?".
Your taskEach row is one pair sold. In D2, use MODE.SNGL to return the shoe size that appears most often in B2:B15.
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 |
|---|---|---|---|---|
| 1 | Sale | Size | Most common | |
| 2 | 1 | 42 | ||
| 3 | 2 | 40 | ||
| 4 | 3 | 42 | ||
| 5 | 4 | 44 | ||
| 6 | 5 | 41 | ||
| 7 | 6 | 42 | ||
| 8 | 7 | 43 | ||
| 9 | 8 | 39 | ||
| 10 | 9 | 42 | ||
| 11 | 10 | 44 | ||
| 12 | 11 | 41 | ||
| 13 | 12 | 45 | ||
| 14 | 13 | 40 | ||
| 15 | 14 | 42 |