View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pjkaraffa@comcast.net is offline
external usenet poster
 
Posts: 1
Default 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.