| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Third Quartile (75th Percentile
I know the definition of 3rd quartile and I know the formula in excel but
could not figure out how excel calculates it so I can explain it at my trial. My population is relatively small 1.22x, 1.12x, 3.11x and 0.85x. the median is 1.17x the 1st quartile is 1.05x and the 3rd quartile is 1.69x. I tried to figure out how excel calculates these quartiles when the population is not big enough. I really appreciate your help and thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quartile, percentile, and blank cells | Excel Discussion (Misc queries) | |||
| Lookup to return count, median, lower quartile, upper quartile&ave | Excel Discussion (Misc queries) | |||
| New method for PERCENTILE & QUARTILE formulas | Excel Discussion (Misc queries) | |||
| Auto Filter and Quartile/Percentile Functions | Excel Discussion (Misc queries) | |||
| Quartile Function | Excel Discussion (Misc queries) | |||
Threaded Mode
