SheetFX
≡
<< Go back to all functions

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.

Function Syntax and Parameters

Syntax: PERCENTILE.INC(data, percentile)

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