• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

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
0
Wanu San
Asked:
Wanu San
1 Solution
 
NBVCCommented:
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now