Statistical Functions

Calculates the mean of the provided numbers.

Averages values that satisfy one condition.

Averages values that meet all of the specified conditions.

Pearson correlation coefficient between two arrays.

COUNT returns the count of cells containing numbers in a range.

COUNTA returns the count of all non-empty cells in a range, including text, numbers, and logical values.

COUNTBLANK returns the count of completely blank cells in a range.

COUNTIF counts cells that match a condition. Give it a range and a criterion (like '>100' or 'East') and it tells you how many cells pass the test.

Counts cells that meet all of the specified conditions.

Predicts a y-value from a linear regression at a given x.

Predicts a y-value from a linear regression at a given x (Excel 2016+).

Fits an exponential curve and returns predicted y-values (array).

Returns regression statistics (slope, intercept, and more) as an array.

MAX finds the highest value in a range.

Finds the largest value where multiple conditions are all true.

Finds the central (50th percentile) value of a dataset.

MIN finds the lowest value in a range.

Finds the smallest value where multiple conditions are all true.

Returns the single most frequently occurring value in a set of numbers.

Returns every value tied for the highest frequency as an array.

Returns the single most frequent value, choosing the lowest on a tie.

Pearson correlation coefficient between two arrays (same as CORREL).

Returns the value at a given percentile (k from 0 to 1, inclusive).

Returns the value at percentile k (0 < k < 1) using the exclusive method.

Returns the value at percentile k (0 <= k <= 1) using the inclusive method.

Returns the specified quartile (0=min, 1, 2=median, 3, 4=max) of a dataset.

Returns quartile 1, 2, or 3 using the exclusive method (endpoints excluded).

Returns the chosen quartile (0=min to 4=max) using the inclusive method.

Gives the rank of a value in a dataset, with ties sharing a rank.

Ranks a value; ties receive the average of the ranks they occupy.

Ranks a value in a list; ties share a rank and the next rank is skipped.

Sample standard deviation (n-1) of a set of numbers.

Sample standard deviation that also counts text and logicals as numbers.

Population standard deviation (n) of a set of numbers.

Population standard deviation that also counts text and logicals as numbers.

SUM calculates the sum of numeric values in a range.

Fits a linear trend and returns predicted y-values (array).

Sample variance (n-1) of a set of numbers.

Sample variance that also counts text and logicals as numbers.

Population variance (n) of a set of numbers.

Population variance that also counts text and logicals as numbers.