How to find percentiles from raw in Excel?
Sorry, I am not taking CFA. But I have a question from my finance class. I have the following data, I would like to find the percentiles in Excel. Anyone can help?
34 23 1 3 5 66 100 22
Sorry, I am not taking CFA. But I have a question from my finance class. I have the following data, I would like to find the percentiles in Excel. Anyone can help?
34 23 1 3 5 66 100 22
By definition, the rank percentile is (N1 + 0.5*N2)/N * 100%
N1 is the number of data less the concerned data and N2 is the frequency of the concerned data. N is the total number of data.
For example, the ranking of 66 can by found by setting N1=6, N2=1 and N=8, so the ranking of 66 is (6+0.5*1)/8 *100%= 81.25%.
In Excel, you can first use RANK() function to find the ranking of each data point, use count() to find the total number of data point and the apply this equation.