Discover what quartiles are in statistics, how to calculate them, and see examples to help you interpret data more ...

For example, if you entered your data set into cells A1 through A100, then your formula should read: =TRIMMEAN (A1:A100,0.5). Press the "Enter" key to calculate the interquartile range.

To find the interquartile range Start by putting the values in order 2.5 3.1 3.4 3.5 3.5 4 4.1 find the median The median is the 4th value which is 3.5 2.5 3.1 3.4 3.5 3.5 4 4.1 ...