The `PERCENTILE.INC` function in Excel is used to calculate the k-th percentile of a dataset, where k is a value between 0 and 1 inclusive. This function is useful when you need to determine statistical benchmarks or ranks within a data set.
Here’s how to use the `PERCENTILE.INC` function:
Syntax:
PERCENTILE.INC(array, k)
- array: The range of data or an array of numerical values for which you want to find the k-th percentile.
- k: The percentile value you want to find, expressed as a decimal between 0 and 1 inclusive. For example, use 0.25 for the 25th percentile.
Steps to Use the Function:
- Prepare Your Data:
Make sure your data is organized in a column or row format if you’re using a range.
- Enter the Function:
Click on an empty cell where you want the result to appear, then enter the formula using the syntax mentioned above.
- Example:
Suppose you have a set of data in cells `A1:A10`, and you want to find the 90th percentile:
=PERCENTILE.INC(A1:A10, 0.9)
- Press Enter:
After typing the formula, press Enter, and Excel will calculate and display the 90th percentile for the data in `A1:A10`.
Tips:
- Ensure that the array of data does not contain non-numerical values (like text) as it could result in an error or incorrect calculation.
- If you need percentiles other than those that include 0 and 1, consider using the `PERCENTILE.EXC` function instead.
- Use a cell reference for `k` if you want to easily adjust the percentile without editing the function directly each time.
By using `PERCENTILE.INC`, you can easily perform statistical analysis and rank your data sets directly in Excel.
Unlock Your Potential
Excel
Access
Power BI
