Microsoft Excel 2010 is an indispensable tool for any entrepreneur or any small-scale business owner. It is essential for executing important calculations for your business. Out of all, the excel function which is extremely useful is the PERCENTILE.EXC function. PERCENTILE.EXC function computes the “kth percentile” for a data set where k is 0 to 1.
In other words, PERCENTILE.EXC function will skim through a vast set of data and pinpoint the exact number, which helps to segregate the data into your chosen percentiles. On the other hand, Microsoft Excel also includes PERCENTILE.INC function. Although it is less accurate, it comes in handy during many situations.
Calculate percentile in Excel
How to Find Percentile in Excel?
To find percentile in Excel, enter the following formula into the cell, without quotes: “=PERCENTILE. EXC(A1:AX,k)” where “X” is the last row in column “A” where you have entered data, and “k” is the percentile value in the range from 0 to 1. The k percentile is a value below which k percent of values in the data set to fall. A percentile calculated with k = 0.5 means 50% percent of values are less than or equal to the calculated result.
Find Percentile in Excel in 6 steps:
Step 1: Open a fresh worksheet in Microsoft Excel.
Step 2: Go ahead and click on cell “A1”. Enter the values into the cells in column A.
Step 3: Click the “B1” cell.
Step 4: Enter =PERCENTILE.EXC(A1: AX,k) into the cell. Here, “X” denotes the last row in column “A.” You will have to enter the data in column “A.”And, “k” is the percentile value you are looking for. The percentile value for “k” must range between 0-1.Example: If you want to find the value for the 60th percentile, you will use “0.6” as your percentile value.
Step 5: Click “Enter” to complete your formula. Lastly, check the value in “B1.”
How to calculate p50 p75 p90 in excel?
To calculate p50 you need to use the “=PERCENTILE. EXC(A1:AX,k)” formula where “X” is the last row in column “A” where you have entered data, and “k” is 0.5.
To calculate p75 you need to use the “=PERCENTILE. EXC(A1:AX,k)” formula where “X” is the last row in column “A” where you have entered data, and “k” is 0.75.
To calculate p90 you need to use the “=PERCENTILE. EXC(A1:AX,k)” formula where “X” is the last row in column “A” where you have entered data, and “k” is 0.9.