Menu
Imagine the following column calledd id:
68 69 43 54 56 61 69 70 71 72 77 78 79 85 87 88 89 93 95 96 98 99 99 62 66
If I do the following: percentile(id, 0.9), the output is 97.2. What is going on?
904
Enter the following formula into the cell, excluding quotes: "=PERCENTILE. EXC(A1:AX,k)" where "X" is the last row in column "A" where you have entered data, and "k" is the percentile value you are looking for.
Use PERCENTILE_APPROX if your input is non-integral. Returns an approximate pth percentile of a numeric column (including floating point types) in the group. The B parameter controls approximation accuracy at the cost of memory. Higher values yield better approximations, and the default is 10,000.
A percentile is the value at a particular rank. For example, if your score on a test is on the 95th percentile, a common interpretation is that only 5% of the scores were higher than yours. The median is the 50th percentile; it is commonly assumed that 50% the values in a data set are above the median.
If you put 0.9, you expect that the 90% of the data you give to the function will be under the returned value. 90% of 25 is approximately 22.5, and 97.2 can be a correct answer, because the four highest values are 99 99 98 96 in your set, and 97.2 is between the 22nd (96) and the 23rd (98) ordered numbers.
121
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
