| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
semi-interquartile range function?
how can i find the semi-interquartile function?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| semi log graphs | Charts and Charting in Excel | |||
| INTERQUARTILE IN EXCEL | Charts and Charting in Excel | |||
| Semi-automating the generation of multiple cell range names | Excel Discussion (Misc queries) | |||
| Semi-hang in XL2002 | Excel Discussion (Misc queries) | |||
| Scatter plot with median and interquartile lines | Charts and Charting in Excel | |||
Linear Mode
