Solved

# Calculating Percentile Value inside Excel.

Posted on 2016-10-24
37 Views
Last Modified: 2016-10-25
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
Question by:Wanu San
2 Comments

LVL 23

Accepted Solution

NBVC earned 500 total points
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

Author Comment

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

## Join & Write a Comment Already a member? Login.

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

#### 763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!