Statistics
Find a quartile
=QUARTILE.INC(B2:B6,1)How it works in Excel
- B2:B6 is your data.
- 1 means the first quartile. Use 3 for the third.
- For the interquartile range, take quartile 1 from quartile 3.
The idea in general
Quartiles cut sorted data into four equal groups.
What I assumed
- Your numbers are in B2:B6.
Check the result on your own data before relying on it.