PERCENTILE

The PERCENTILE function in Google Sheets returns the value at a given percentile of a dataset.

Function Syntax and Parameters

Syntax: PERCENTILE(data, percentile)

Parameters:

• data: The array or range containing the dataset.
• percentile: The percentile value between 0 and 1, inclusive.

Step-by-Step Tutorial

1. Using PERCENTILE with an array or range:
   • Example: =PERCENTILE(A1:A10, 0.75)
   • Result: Returns the value at the 75th percentile of the dataset in cells A1 to A10.

Use Cases and Scenarios

1. Data Analysis: Determine the value at a given percentile to analyze datasets.
2. Financial Calculations: Calculate portfolio returns at specific percentiles.
3. Quality Control: Identify production data that falls within a certain percentile range.

Related Functions

• PERCENTILE_EXC: Returns the exclusive percentile from a dataset.
• PERCENTILE_INC: Returns the inclusive percentile from a dataset.

Related Articles

• 5 Statistical Functions in Google Sheets That Can Supercharge Your Data Analysis
• How to Use Percentile Functions in Google Sheets