Summarise a numeric sample without hiding missing data
Your goal: Keep the numeric count, median and sample standard deviation together; distinguish a missing sample from a measured zero.
Full 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.
Zero, a long tail and numeric-looking textChoose the numeric observations
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 | ||
| 10 | ||
| 11 |
Step 1 of 3
Choose the numeric observations
Rules for this step
A measured zero and a negative number belong to the sample. Referenced text numbers, notes, blanks and logical values do not.
Tap values in the worksheet to include or remove them. Type labels distinguish stored numbers, text, logical values, genuine blanks and genuine errors.
Your selected values will appear here.
- Numeric observations
- 0
- Signed total
- 0
- Mean of this selection
- No observations