PERCENTILE.INC function returns the k-th percentile of a dataset, where k is a value between 0 and 1, inclusive. It returns an interpolated value if the percentile falls between two data points. This function is commonly used in statistical analysis.
- How to use
- Examples of using
PERCENTILE.INCformula not working?
- Similar formulas to
PERCENTILE.INC formula with the syntax shown below, it has 2 required parameters:
- data (required):
The array or range containing the dataset to be analyzed.
- percentile (required):
The value between 0 and 1, inclusive, representing the percentile to be calculated.
ExamplesHere are a few example use cases that explain how to use the
PERCENTILE.INC formula in Google Sheets.
To calculate the first quartile of a dataset, use
=PERCENTILE.INC(data, 0.25). Similarly, to calculate the third quartile, use
PERCENTILE.INC function can be used to identify outliers in a dataset. Any data point that falls more than 1.5 times the interquartile range above the third quartile or below the first quartile is considered an outlier.
You can use the
PERCENTILE.INC function to rank data within a dataset. For example, to find the rank of a specific data point, use
=RANK(data_point, data, 1), where
data_point is the cell containing the data point and
data is the range containing the dataset.
PERCENTILE.INC not working? Here are some common mistakes people make when using the
PERCENTILE.INC Google Sheets Formula:
Using a percentile value outside the range of 0 to 1
percentile parameter in the
PERCENTILE.INC function must be a decimal value between 0 and 1 inclusive. If a value outside this range is used, the formula will return an error.
Not including the entire dataset in the range
When using the
PERCENTILE.INC formula, make sure that the range includes all of the data you want to include in the calculation. If the range is too small, the formula will return an inaccurate result.
Using a range that includes non-numeric values
PERCENTILE.INC function only works with numeric data. If the range includes non-numeric values, the formula will return an error.
The following functions are similar to
PERCENTILE.INC or are often used with it in a formula:
QUARTILE.INCfunction calculates the quartile of a dataset, which is a measure of statistical dispersion. It is commonly used to split a dataset into four equal parts, each containing 25% of the data points. The function takes in two parameters - the dataset as
dataand the quartile number as
quartile_number- and returns the value of the specified quartile. Quartile numbers are specified as follows: 1 for the first quartile (25th percentile), 2 for the second quartile (50th percentile, or median), and 3 for the third quartile (75th percentile).
PERCENTILE.EXCfunction is a statistical function used to find the percentile rank of a given value in a dataset. It returns the k-th percentile of values in a range, where k is a value between 0 and 1 exclusive. This function is similar to the
PERCENTILEfunction, but excludes the percentile value from the calculation.
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.
STDEV.Pfunction is a statistical function that calculates the standard deviation of a population based on a sample of numerical data. It is commonly used to measure the amount of variation or dispersion in a dataset. The formula assumes that the input values represent the entire population, rather than a sample. If the input values represent a sample, you should use the
You can learn more about the
PERCENTILE.INC Google Sheets function on Google Support.