Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
PERCENTILE.INC and QUARTILE.INC. PERCENTILE.INC(range, k) returns the value below which a share k of the data falls, with k between 0 and 1: 0.5 is the median. QUARTILE.INC(range, q) is the same for quarters: q = 1 is the 25th percentile, 3 the 75th. Values between two data points are interpolated.
=PERCENTILE.INC(B2:B80,0.95) the delivery time 95% of parcels beat
Elena Petrova wants a rule for flagging large North orders: the value that 90% of Q2 orders stay at or below. She also wants the middle half of orders, from the first to the third quartile.
Using the order values in C2:C52: in F2 put the 90th percentile, in F3 the first quartile and in F4 the third quartile. Use the inclusive versions of the functions. Round each to 2 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Value | North, Q2 | ||||
| 2 | 50271 | 2025-04-01 | 45.60 | 90th percentile | ||||
| 3 | 50273 | 2025-04-02 | 249.63 | First quartile | ||||
| 4 | 50279 | 2025-04-03 | 247.61 | Third quartile | ||||
| 5 | 50283 | 2025-04-04 | 126.25 | |||||
| 6 | 50291 | 2025-04-08 | 313.50 | |||||
| 7 | 50296 | 2025-04-10 | 454.43 | |||||
| 8 | 50302 | 2025-04-11 | 288.00 | |||||
| 9 | 50305 | 2025-04-14 | 384.90 | |||||
| 10 | 50309 | 2025-04-15 | 261.50 | |||||
| 11 | 50311 | 2025-04-15 | 183.50 | |||||
| 12 | 50313 | 2025-04-16 | 386.30 | |||||
| 13 | 50317 | 2025-04-17 | 270.10 | |||||
| 14 | 50318 | 2025-04-17 | 722.40 | |||||
| 15 | 50326 | 2025-04-19 | 1,076.00 | |||||
| 16 | 50335 | 2025-04-22 | 477.60 | |||||
| 17 | 50338 | 2025-04-23 | 66.48 | |||||
| 18 | 50341 | 2025-04-24 | 60.00 | |||||
| 19 | 50344 | 2025-04-24 | 137.78 | |||||
| 20 | 50365 | 2025-05-01 | 468.90 | |||||
| 21 | 50366 | 2025-05-01 | 561.05 | |||||
| 22 | 50373 | 2025-05-05 | 372.30 | |||||
| 23 | 50383 | 2025-05-07 | 55.00 | |||||
| 24 | 50385 | 2025-05-07 | 132.00 | |||||
| 25 | 50387 | 2025-05-08 | 498.30 | |||||
| 26 | 50389 | 2025-05-08 | 216.70 | |||||
| 27 | 50391 | 2025-05-09 | 202.50 | |||||
| 28 | 50404 | 2025-05-14 | 114.00 | |||||
| 29 | 50406 | 2025-05-14 | 273.30 | |||||
| 30 | 50415 | 2025-05-16 | 202.33 | |||||
| 31 | 50422 | 2025-05-19 | 302.40 | |||||
| 32 | 50423 | 2025-05-19 | 218.40 | |||||
| 33 | 50429 | 2025-05-21 | 299.40 | |||||
| 34 | 50432 | 2025-05-22 | 180.00 | |||||
| 35 | 50442 | 2025-05-26 | 262.60 | |||||
| 36 | 50443 | 2025-05-26 | 201.31 | |||||
| 37 | 50452 | 2025-05-29 | 36.10 | |||||
| 38 | 50455 | 2025-05-29 | 75.00 | |||||
| 39 | 50464 | 2025-06-02 | 63.00 | |||||
| 40 | 50465 | 2025-06-03 | 92.20 | |||||
| 41 | 50470 | 2025-06-04 | 190.75 | |||||
| 42 | 50480 | 2025-06-09 | 1,012.80 | |||||
| 43 | 50490 | 2025-06-11 | 194.83 | |||||
| 44 | 50491 | 2025-06-11 | 60.00 | |||||
| 45 | 50497 | 2025-06-13 | 312.00 | |||||
| 46 | 50500 | 2025-06-13 | 1,410.00 | |||||
| 47 | 50507 | 2025-06-17 | 249.40 | |||||
| 48 | 50513 | 2025-06-18 | 639.20 | |||||
| 49 | 50528 | 2025-06-24 | 2,435.00 | |||||
| 50 | 50531 | 2025-06-25 | 412.50 | |||||
| 51 | 50538 | 2025-06-27 | 44.55 | |||||
| 52 | 50544 | 2025-06-30 | 171.00 | |||||
| 53 | ||||||||
| 54 | ||||||||
| 55 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe