Summarize measurements that contain errors
Enter one formula in G5. Return one row with four results in this order: the sum of numeric observations in B2:B13, their count, their arithmetic mean, and the count of genuine source errors. Ignore genuine errors when calculating the numeric statistics. Range text, numeric-looking text, Boolean values and blanks are not numeric observations. Keep real zeroes and negative amounts. If no numeric values exist, return numeric zero for sum and count and the literal No numeric values for mean. Do not add headings.
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 one formula in G5. Return one row with four results in this order: the sum of numeric observations in B2:B13, their count, their arithmetic mean, and the count of genuine source errors. Ignore genuine errors when calculating the numeric statistics. Range text, numeric-looking text, Boolean values and blanks are not numeric observations. Keep real zeroes and negative amounts. If no numeric values exist, return numeric zero for sum and count and the literal No numeric values for mean. Do not add headings.
No account. No upload. Just try it.