PERCENTILE.INC

Calculates the k-th percentile of values in an array or range, where k must be between 0 and 1, and it can be 0 or 1 itself.

Syntax:

PERCENTILE.INC(array, k)

array is required, and is the array or range of cells you want to use to find the percentile.

k is required, and is the the percentile that you want to find.

Example:

If array, found in A1:A10, contains numbers 85, 92, 78, 90, 88, 75, 95, 80, 82, 70 and k, found in B1, contains 0.75:

PERCENTILE.INC(A1:A10, B1)

returns 89.5

	A	B	C
1	85	0.75	89.5
2	92
3	78
4	90
5	88
6	75
7	95
8	80
9	82
10	70

Application:

Let's imagine you are the HR manager for a tech company, and you want to analyze employee salaries to ensure they are competitive. You have the following salary data for 15 employees:

	Employee ID	Salary
	A	B
1	101	$65,000.00
2	102	$72,000.00
3	103	$85,000.00
4	104	$92,000.00
5	105	$105,000.00
6	106	$115,000.00
7	107	$120,000.00
8	108	$125,000.00
9	109	$135,000.00
10	110	$140,000.00
11	111	$155,000.00
12	112	$160,000.00
13	113	$175,000.00
14	114	$190,000.00
15	115	$210,000.00

You want to find the 75th percentile of the salaries. This value will tell you what salary is higher than 75% of the other salaries in the dataset. This is a crucial metric for understanding your salary distribution and making informed decisions about compensation.

The formula to calculate the 75th percentile would be:

PERCENTILE.INC(B1:B15, 0.75)

Where:

B1:B15 is the range containing the salaries.
0.75 is the value for the 75th percentile (or 75%).

Result:

The PERCENTILE.INC function will return a value of $157,500.

Interpretation:

This means that a salary of $157,500 is higher than 75% of the salaries in your company's dataset. When you are looking to hire new talent or give out raises, this data point helps you set salary ranges. For example, if you want to offer a salary that is in the top 25% of your company, you know it should be greater than $157,500.

Result for PERCENTILE.INC(B1:B15, 0.75):

$157,500.00