PERCENTILE.INC

The PERCENTILE.INC function in Google Sheets is a statistical function that calculates the k-th percentile of a dataset, based on a specified percentile value. It is useful for analyzing data distributions and finding values at specific percentiles. Discover how to effectively use this function with our comprehensive guide.

Parameters

• data: The range or array containing the dataset from which to calculate the percentile.
• percentile: The value between 0 and 1 representing the desired percentile.

Step-by-Step Tutorial

1. Using PERCENTILE.INC with a range of cells:
   • Example: If A1:A5 has the values 20, 30, 40, 50, 60, and you want to find the value at the 75th percentile, use =PERCENTILE.INC(A1:A5, 0.75).
   • Result: 47.5

Use Cases and Scenarios

1. Data Analysis: Determine the threshold value at a certain percentile.
2. Financial Analysis: Calculate the 90th percentile of stock returns.
3. Healthcare Research: Find the BMI value corresponding to the 95th percentile of a population.

Related Functions

• PERCENTILE: Older version of PERCENTILE.INC that uses a different algorithm for calculating percentiles.
• QUARTILE.INC: Calculates the quartile values of a dataset.

Related Articles

• Statistical Functions for Data Analysis in Google Sheets
• Using Percentile Functions in Google Sheets: A Comprehensive Guide