Excel percentile function calculates the percentile values by
When the percentile value is 0.5, it returns the average of the two middle values for groups with even number of elements
ex: for 2 values
1)5.1
2)6.8
percentile function returns 50% as 5.9
But idealy i want the answer in such a way that it returns the values by order.
Please tell me which excel function to use to get the values like below.
50% and below as - 5.1
50% and above as - 6.8
Bookmarks