In Sheets, type the formula for the first quartile of the amounts in D2:D13, with the range locked.
In Sheets, type the formula for the first quartile of the amounts in D2:D13, with the range locked.
Answer
=QUARTILE.INC(D2:D13, 1)
The second argument picks the quartile: 1 for Q1 (241.25), 2 for the median, 3 for Q3 (670). INC interpolates the same way as R's type 7.
OpenStax Introductory Statistics 1e §2.4 (CC BY 4.0) — the 1.5·IQR fence rule and five-number summary; data original