Interquartile range function - which is most appropriate?

[catandhorse1976]

Please advise which is the correct function to calculate the upper (Q3) and lower bounds of the interquartile range?

What's the difference, please, between QUARTILE.EXC and QUARTILE.INC - I am struggling to understand.

Thank you.

 

[Jon Peltier]

It is confusing. I wrote a series of short articles about the different ways to calculate quartiles starting here:

Quartiles for Box Plots - Peltier Tech

Quartiles are widely used, but less widely understood. This set of articles describes quartiles in terms of their use in box plots.

peltiertech.com