Skip to main content
← All challenges

Build an operational review with the right denominator

Fill G5:G7 for the region/state in G2:G3. G5 is the unweighted mean of services with positive case counts; G6 is the case-weighted mean, with explicit empty/negative-weight states; G7 compares numeric G6 with target G4 or carries its text state.

The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.

Practice stays on this device. No worksheet data is uploaded.

A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.

Help recorded: none of these built-in aids opened.

A LITTLE PRACTICE

Make the formula your own.

View task requirements

Fill G5:G7 for the region/state in G2:G3. G5 is the unweighted mean of services with positive case counts; G6 is the case-weighted mean, with explicit empty/negative-weight states; G7 compares numeric G6 with target G4 or carries its text state.

Runs in your browser

No account. No upload. Just try it.

Read the full explanation →