Q3=QUARTILE(rng,3)
Q1=QUARTILE(rng,1)
semi-interquartile=(QUARTILE(rng,3)-QUARTILE(rng,1))/2

Regards,
Pedro J.


On Jul 16, 6:22 pm, "Niek Otten" wrote:
What is "the" semi-interquartile range function?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"red_zombie" wrote in ...

| how can i find the semi-interquartile function?

The interquartile range is commonly used, i.e. the distance between
the 25th and 75th percentiles (Q3 - Q1). N.B. By definition, this
contains 50% of the datapoints in a normally-distributed dataset.
The semi-interquartile range, i.e. (Q3 - Q1)/2, covers 25% of the
datapoints and is even less subject to variation due to scatter.