Google Sheets statistical functions

• AVERAGEIFReturns the average of a range depending on criteria.StatisticalExcel
• FORECAST.LINEARSeeStatisticalExcel
• RANKReturns the rank of a specified value in a dataset.StatisticalExcel

AVEDEV

Calculates the average of the magnitudes of deviations of data from a dataset's mean.

AVERAGE

Returns the numerical average value in a dataset, ignoring text.

AVERAGE.WEIGHTED

Finds the weighted average of a set of values, given the values and the corresponding weights. .

AVERAGEA

Returns the numerical average value in a dataset.

AVERAGEIFS

Returns the average of a range depending on multiple criteria.

BETA.DIST

Returns the probability of a given value as defined by the beta distribution function. .

BETA.INV

Returns the value of the inverse beta distribution function for a given probability.

BETADIST

See .

BETAINV

See

BINOM.DIST

BINOM.INV

See

BINOMDIST

Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

CHIDIST

Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

CHIINV

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.DIST

Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.

CHISQ.DIST.RT

Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.

CHISQ.INV

Calculates the inverse of the left-tailed chi-squared distribution.

CHISQ.INV.RT

Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.TEST

See

CHITEST

Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.

CONFIDENCE

See

CONFIDENCE.NORM

Calculates the width of half the confidence interval for a normal distribution. .

CONFIDENCE.T

Calculates the width of half the confidence interval for a Student’s t-distribution. .

CORREL

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

COUNT

Returns a count of the number of numeric values in a dataset.

COUNTA

Returns a count of the number of values in a dataset.

COVAR

Calculates the covariance of a dataset.

COVARIANCE.P

See

COVARIANCE.S

Calculates the covariance of a dataset, where the dataset is a sample of the total population. .

CRITBINOM

Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

DEVSQ

Calculates the sum of squares of deviations based on a sample.

EXPON.DIST

Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. .

EXPONDIST

See

F.DIST

Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.

F.DIST.RT

Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.

F.INV

Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.

F.INV.RT

Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.

F.TEST

See .

FDIST

See .

FINV

See

FISHER

Returns the Fisher transformation of a specified value.

FISHERINV

Returns the inverse Fisher transformation of a specified value.

FORECAST

Calculates the expected y-value for a specified x based on a linear regression of a dataset.

FTEST

Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.

GAMMA

Returns the Gamma function evaluated at the specified value. .

GAMMA.DIST

Calculates the gamma distribution, a two-parameter continuous probability distribution.

GAMMA.INV

The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. .

GAMMADIST

See

GAMMAINV

See .

GAUSS

The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. .

GEOMEAN

Calculates the geometric mean of a dataset.

HARMEAN

Calculates the harmonic mean of a dataset.

HYPGEOM.DIST

See

HYPGEOMDIST

Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.

INTERCEPT

Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

KURT

Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.

LARGE

Returns the nth largest element from a data set, where n is user-defined.

LOGINV

Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.

LOGNORM.DIST

See

LOGNORM.INV

See

LOGNORMDIST

Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.

MARGINOFERROR

Calculates the amount of random sampling error given a range of values and a confidence level.

MAX

Returns the maximum value in a numeric dataset.

MAXA

Returns the maximum numeric value in a dataset.

MAXIFS

Returns the maximum value in a range of cells, filtered by a set of criteria.

MEDIAN

Returns the median value in a numeric dataset.

MIN

Returns the minimum value in a numeric dataset.

MINA

Returns the minimum numeric value in a dataset.

MINIFS

Returns the minimum value in a range of cells, filtered by a set of criteria.

MODE

Returns the most commonly occurring value in a dataset.

MODE.MULT

Returns the most commonly occurring values in a dataset. .

MODE.SNGL

See

NEGBINOM.DIST

See

NEGBINOMDIST

Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

NORM.DIST

See

NORM.INV

See

NORM.S.DIST

See

NORM.S.INV

See

NORMDIST

Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

NORMINV

Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

NORMSDIST

Returns the value of the standard normal cumulative distribution function for a specified value.

NORMSINV

Returns the value of the inverse standard normal distribution function for a specified value.

PEARSON

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

PERCENTILE

Returns the value at a given percentile of a dataset.

PERCENTILE.EXC

Returns the value at a given percentile of a dataset, exclusive of 0 and 1. .

PERCENTILE.INC

See

PERCENTRANK

Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK.EXC

Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

PERCENTRANK.INC

Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.

PERMUT

Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.

PERMUTATIONA

Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. .

PHI

The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. .

POISSON

See

POISSON.DIST

Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. .

PROB

Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.

QUARTILE

Returns a value nearest to a specified quartile of a dataset.

QUARTILE.EXC

Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. .

QUARTILE.INC

See

RANK.AVG

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.

RANK.EQ

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

RSQ

Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

SKEW

Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

SKEW.P

Calculates the skewness of a dataset that represents the entire population. .

SLOPE

Calculates the slope of the line resulting from linear regression of a dataset.

SMALL

Returns the nth smallest element from a data set, where n is user-defined.

STANDARDIZE

Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

STDEV

Calculates the standard deviation based on a sample.

STDEV.P

See

STDEV.S

See

STDEVA

Calculates the standard deviation based on a sample, setting text to the value `0`.

STDEVP

Calculates the standard deviation based on an entire population.

STDEVPA

Calculates the standard deviation based on an entire population, setting text to the value `0`.

STEYX

Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

T.DIST

Returns the right tailed Student distribution for a value x. .

T.DIST.2T

Returns the two tailed Student distribution for a value x. .

T.DIST.RT

Returns the right tailed Student distribution for a value x. .

T.INV

Calculates the negative inverse of the one-tailed TDIST function.

T.INV.2T

Calculates the inverse of the two-tailed TDIST function.

T.TEST

Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. .

TDIST

Calculates the probability for Student's t-distribution with a given input (x).

TINV

See

TRIMMEAN

Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

TTEST

See .

VAR

Calculates the variance based on a sample.

VAR.P

See

VAR.S

See

VARA

Calculates an estimate of variance based on a sample, setting text to the value `0`.

VARP

Calculates the variance based on an entire population.

VARPA

Calculates the variance based on an entire population, setting text to the value `0`.

WEIBULL

Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

WEIBULL.DIST

See

Z.TEST

Returns the one-tailed P-value of a Z-test with standard distribution. .

ZTEST

See .

More Google Sheets function categories

• Math84
• Financial50
• Engineering47
• Text41
• Array29
• Date26
• Info18
• Lookup18
• Operator17
• Logical13
• Database12
• Web8
• Google7
• Parser6
• Filter3
• AI1