semi-interquartile range function?
how can i find the semi-interquartile function?
|
semi-interquartile range function?
What is "the" semi-interquartile range function?
-- Kind regards, Niek Otten Microsoft MVP - Excel "red_zombie" wrote in message ... | how can i find the semi-interquartile function? |
semi-interquartile range function?
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. |
semi-interquartile range function?
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. |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com