Calculating Percentile Value inside Excel.

Hi

I need to calculate the Percentile Values that would represent the Values of

100 Percentile Value
90 Percentile Value
80 Percentile Value
70 Percentile Value
60 Percentile Value
50 Percentile Value
40 Percentile Value
30 Percentile Value
20 Percentile Value
10 Percentile Value
0 Percentile Value



based on the data that I have in Column J. The formulas needs to be kept inside the Orange Box in Column J itself. I have attached the sample excel sheet with the data.

Please check the following thread for reference -
https://www.experts-exchange.com/questions/28977913/What-is-the-Difference-between-Percentile-and-T-Score-where-to-use-which-one.html

I am using Excel 2016 Professional Plus x64

Thanks
Percentile.xlsx
Wanu SanAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
The Percentile Function is =PERCENTILE(Array,k)  where Array is the range and K is the percentile value from 0 to 1

so for your range, the 100 percentile value would be written as

=PERCENTILE($J$30:$J$141,1)

and the 90 would be

=PERCENTILE($J$30:$J$141,0.9)

etc.
1
 
Wanu SanAuthor Commented:
Thanks NBVC. That formula works perfectly for my requirement.

Can you please suggest similar corresponding formula for calculating T-Score as well, in my similar threads ?
https://www.experts-exchange.com/questions/28978631/Calculating-T-SCORE-inside-Excel.html

Thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.