Day 106 · Tuesday, 17 November 2026

From the archive

Intermediate

Flag an Unusual Week of Water Use with AVERAGE and STDEV

Every week's meter reading is different, so "higher than average" flags half of them. What a facilities manager needs to know is whether a week is further from normal than the usual week-to-week wobble can explain, and the standard deviation is that wobble measured. Two of them from the average is the usual line between noise and something worth walking the pipes for.

Task:

You look after facilities for a 60-room hotel, and the water company bills by the cubic metre. The last ten weekly meter readings are in A2:B11. In C2, show "Check" if that week's use is more than two standard deviations away from the ten-week average, in either direction, and "OK" otherwise. Work the average and the standard deviation out of B2:B11 inside the formula, then copy it down to C11.

The daily challenge is part of Pro

A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.