semi-interquartile range function?

  • Thread starter Thread starter red_zombie
  • Start date Start date
What is "the" semi-interquartile range function?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| how can i find the semi-interquartile function?
 
What is "the" semi-interquartile range function?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| how can i find the semi-interquartile function?
Click to expand...

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.
 
Q3=QUARTILE(rng,3)
Q1=QUARTILE(rng,1)
semi-interquartile=(QUARTILE(rng,3)-QUARTILE(rng,1))/2

Regards,
Pedro J.
 
Back
Top