Compare mean populations without changing stored types
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.
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
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.
No account. No upload. Just try it.