Wanu San
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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