Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
STDEV.S. STDEV.S(range) measures how far values typically sit from their average, treating the data as a sample. It’s in the same units as the data. To compare series of different sizes, divide it by the average: the coefficient of variation. A bigger ratio means a bumpier series.
=STDEV.S(C2:C53)/AVERAGE(C2:C53) how much weekly visits vary
Grace Whitfield is planning stock for 2026 and asks which region’s monthly revenue is least predictable. West has the biggest months, but also some very weak ones.
In B15:E15, put the sample standard deviation of each region’s monthly revenue (rows 2 to 13), rounded to 2 decimals. In B16:E16, divide each standard deviation by that region’s average in row 14 (no rounding). Write each row once in column B and fill right.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Month | North | South | East | West | |||
| 2 | 2025-01-01 | 7,330.04 | 7,903.87 | 4,945.99 | 9,006.94 | |||
| 3 | 2025-02-01 | 7,571.92 | 8,866.99 | 3,585.86 | 11,781.49 | |||
| 4 | 2025-03-01 | 5,449.46 | 6,564.36 | 5,395.82 | 12,500.98 | |||
| 5 | 2025-04-01 | 5,751.58 | 10,555.36 | 6,943.64 | 10,369.79 | |||
| 6 | 2025-05-01 | 4,671.59 | 8,333.59 | 6,092.89 | 12,700.02 | |||
| 7 | 2025-06-01 | 7,287.23 | 9,191.92 | 3,644.58 | 12,829.33 | |||
| 8 | 2025-07-01 | 11,271.76 | 11,495.81 | 4,458.33 | 3,748.12 | |||
| 9 | 2025-08-01 | 5,031.77 | 7,722.51 | 4,490.60 | 5,165.57 | |||
| 10 | 2025-09-01 | 8,842.50 | 5,389.63 | 4,484.75 | 6,450.76 | |||
| 11 | 2025-10-01 | 7,236.15 | 5,072.56 | 4,811.09 | 6,981.98 | |||
| 12 | 2025-11-01 | 6,881.10 | 3,907.55 | 4,648.40 | 3,582.10 | |||
| 13 | 2025-12-01 | 7,111.91 | 5,499.10 | 7,261.91 | 5,176.07 | |||
| 14 | Average | 7,036.42 | 7,541.94 | 5,063.66 | 8,357.76 | |||
| 15 | Std dev | |||||||
| 16 | Std dev ÷ average | |||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe