If your data range is a1:a10 then the interquantile range equation is =percentile(a1:a10,0.75)-percentile(a1:a10,0.25)
Chat with our AI personalities
interquartile range or mean absolute deviation.
Range = maximum - minimum Interquartile range = Value of 75th percentile - value of 25th percentile. The 75th percentile is the value such that 25% of the observations are bigger and 75% are smaller.
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
If you are talking about statisitics, in a box and whisker graph it is the interquartile range.
The interquartile range :)