Compare a chosen percentile with an allowance
Your goal: Calculate an inclusive percentile, count observations strictly above it and apply an explicit allowance rule.
Full 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.
Interpolated 90th percentile exceeds the allowanceChoose the true numeric measurements
A/B preserves record identity and measurement type. Original F labels identify percentile G2 and allowance G3.Scroll the worksheet horizontally to inspect later source columns.
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 |
Step 1 of 4
Choose the true numeric measurements
Rules for this step
Select numeric B-column measurements only. Referenced text, text numbers, booleans and blanks do not become observations. Retain numeric zero.