Flag observations outside the IQR fences
Fill G5:G9 separately: Q1 and Q3 from QUARTILE.INC, lower fence Q1-1.5*(Q3-Q1), upper fence Q3+1.5*(Q3-Q1), then the number of numeric B2:B11 values strictly below or above those fences. Values on a fence remain inside. Ignore referenced text, blanks and booleans. With no numeric observations every output returns No observations. Keep the original records; a flag only requests investigation.
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:G9 separately: Q1 and Q3 from QUARTILE.INC, lower fence Q1-1.5*(Q3-Q1), upper fence Q3+1.5*(Q3-Q1), then the number of numeric B2:B11 values strictly below or above those fences. Values on a fence remain inside. Ignore referenced text, blanks and booleans. With no numeric observations every output returns No observations. Keep the original records; a flag only requests investigation.
No account. No upload. Just try it.