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 percentile.

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.

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, you could use …

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 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 …

Options Required. A numerical value that determines which values to ignore in the evaluation range for the function.

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 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 incomes in a population.

Simple formulas can help you find the percentage of a total such as the percentage difference between two numbers. Find the percentage of a total Let's say that you answered 42 questions out of 50 …