Compare mean populations without changing stored types
Your goal: Keep numeric zeroes, excluded text and explicit mean denominators visible before choosing an averaging rule.
Full task requirements
Enter B13 as a real IF controlled by Boolean H2: TRUE returns empty text and FALSE returns Recorded. Keep B2:B12 as eleven editable stored observations. Fill F2:F13 separately. F2/F3 are numeric count/sum. F4 averages numeric observations including zeroes; F5 checks the same sum/count. F6 excludes numeric zeroes and F7 averages only numeric observations strictly above numeric H3. F8 uses AVERAGEA: every referenced text contributes zero, TRUE contributes one and FALSE zero, while true blanks are ignored. F9 exposes its nonempty denominator. F10/F11 count the actual nonzero/qualifying numeric populations. F12 compares numeric means within 1e-9; F13 independently reconciles the threshold mean. Empty numeric populations return No numbers, No nonzero numbers or No qualifying numbers as specified. Source numbers and the threshold are finite within ±1,000,000; editable text is nonempty text up to 40 Unicode characters, including spaces and numeric/error-looking text. Empty text is produced by the real B13 formula; use Blank for an actual empty source cell. Typed formula errors are outside this error-free comparison. These are reference-range rules, not direct-argument coercion rules.
B13: =IF(H2,"","Recorded")| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |
Choose all numeric observations
Rules for this step
AVERAGE includes numeric zero, ignores referenced text and logical values, and divides by the numeric count.
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