Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th …

The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

Lists all statistical functions, such as the AVERAGE, COUNTBLANK, and MEDIAN functions.

Returns the k-th percentile of values in a range, where k is in the range 0 to 1, inclusive. You can use the PERCENTILE.INC function to establish a threshold of acceptance.

Returns the quartile of a data set, based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups.

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. Syntax PERCENTRANK.EXC (array,x, [significance]) The PERCENTRANK.EXC function syntax has …

The PERCENTRANK function returns the rank of a value in a dataset as a percentage of the dataset -- essentially, the relative standing of a value within the whole dataset. For example, …

A box and whisker chart shows distribution of data into quartiles, highlighting the mean and outliers. The boxes may have lines extending vertically called “whiskers”. These lines indicate …

Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.