Why is the 90th percentile of the following numbers 0.193204884?
0.193111065
0.188885706
0.191501273
0.193298704
0.18895934
0.192364606
How can the 90th percentile be greater than the greatest number in the set?
I used the formula - =PERCENTILE(R:R,0.9) on excel. [R:R is the excel range which contains the following numbers]
However, the 90th perentile of 1,2,3,4,5 comes out to be 4.6 which seems correct.
2026-03-25 19:10:21.1774465821
Why does the 90th percentile come out to be greater than the greatest number?
136 Views Asked by Bumbble Comm https://math.techqa.club/user/bumbble-comm/detail At
1
Comment continued. R statistical software allows you to choose from among several different definitions of quantile, all widely used. [See documentation.]
Here are results for quartiles using several different
types.The idea is that some compromises are required when trying to partition eleven values into four appropriate groups; also the presence of ties can complicate finding quantiles. There is no universal agreement how best to do this. R uses type 7 as it's default.
So don't be surprised of you encounter discrepancies between a textbook definition and a particular type of software.