Compare a chosen percentile with an allowance
Use numeric percentile G2 from 0 through 1 and allowance G3. G5 is PERCENTILE.INC of numeric B2:B11; G6 counts numeric observations strictly greater than G5; G7 is Review allowance only when G5 exceeds G3, otherwise Within allowance. With no numeric observations, all three outputs return No observations. Ignore referenced text, blanks and booleans; keep numeric zeroes.
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
Use numeric percentile G2 from 0 through 1 and allowance G3. G5 is PERCENTILE.INC of numeric B2:B11; G6 counts numeric observations strictly greater than G5; G7 is Review allowance only when G5 exceeds G3, otherwise Within allowance. With no numeric observations, all three outputs return No observations. Ignore referenced text, blanks and booleans; keep numeric zeroes.
No account. No upload. Just try it.