Summarise a numeric sample without hiding missing data
Fill G5:G7 separately for B2:B11. G5 counts numeric cells; G6 is their median or No observations when none exist; G7 is sample standard deviation or Need two observations when fewer than two exist. Referenced text, text numbers, blanks and booleans are ignored. Zeroes and signed measurements count.
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.
Make the formula your own.
View task requirements
Fill G5:G7 separately for B2:B11. G5 counts numeric cells; G6 is their median or No observations when none exist; G7 is sample standard deviation or Need two observations when fewer than two exist. Referenced text, text numbers, blanks and booleans are ignored. Zeroes and signed measurements count.
No account. No upload. Just try it.