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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INTERQUARTILE IN EXCEL 1
Excel - Interquartile Range Miscalulation 3
Scatter plot with median and interquartile lines 0
how do I identify statistical outliers with excel? 7
Enermax Triathlor 700W Semi-Modular Power Supply 0
Monthly Mortgage payments for a Semi annual compounding rate 11
Formula to calc. semi-annual int. only pmt. with balloon in 10 yr 2
Bond premium amortization using the constant yield method 1

Back
Top