### Statistical functions

How to use the KURT function

What is the KURT function? The KURT function lets you calculate the kurtosis in Excel. The kurtosis shows the tailedness […]

How to use the HARMEAN function

What is the HARMEAN function? The HARMEAN function lets you calculate the harmonic mean in Excel. What is the harmonic […]

How to use the HYPGEOM.DIST function

What is the HYPGEOM.DIST function? The HYPGEOM.DIST function calculates the hypergeometric distribution. What is a hypergeometric distribution? A hypergeometric distribution […]

How to use the PERCENTRANK.EXC function

What is the PERCENTRANK.EXC function? The PERCENTRANK.EXC function calculates the percentage rank of a given number in a data set. This […]

How to use the PERCENTRANK.INC function

What is the PERCENTRANK.INC function? The PERCENTRANK.INC function calculates the percent rank of a given number compared to the whole […]

How to use the QUARTILE.EXC function

What is the QUARTILE.EXC function? The QUARTILE.EXC function returns the quartile of a data set, use the QUARTILE.EXC function to […]

How to use the LOGNORM.DIST function

What is the LOGNORMDIST function? The LOGNORMDIST function calculates the lognormal distribution of argument x, based on a normally distributed ln(x) […]

How to use the LOGEST function

What is the LOGEST function? The LOGEST function returns an array of values representing the parameters of an exponential curve […]

How to use the LINEST function

What is the LINEST function? The LINEST function returns an array of values representing the parameters of a straight line […]

How to use the GAMMA.DIST function

How to use the GAMMA.DIST function? The GAMMA.DIST function calculates the gamma often used in queuing analysis (probability statistics) that […]

How to use the F.TEST function

What is the F.TEST function? The F.TEST function calculates the two-tailed probability from an F-test, the value shows if the […]

How to use the INTERCEPT function

What is the INTERCEPT function? The INTERCEPT function returns a value representing the y-value where a line intersects the y-axis. […]

How to use the F.DIST.RT function

What is the F.DIST.RT function? The F.DIST.RT function calculates the right-tailed F probability for two tests. This function was introduced in […]

How to use the F.DIST function

What is the F.DIST function? The F.DIST function calculates the F probability for two tests. This function was introduced in […]

How to use the BINOM.INV function

What is the BINOM.INV function? The BINOM.INV function calculates the minimum value for which the binomial distribution is equal to […]

How to use the CHISQ.TEST function

What is the CHISQ.TEST function? The CHISQ.TEST function calculates the test for independence, the value returned from the chi-squared statistical […]

How to use the COVARIANCE.S function

What is the COVARIANCE.S function? The COVARIANCE.S function calculates the sample covariance from two different datasets. What is covariance? Covariance […]

How to use the COVARIANCE.P function

What is the COVARIANCE.P function? The COVARIANCE.P function calculates the covariance in two different data sets. What is covariance? Covariance […]

How to use the CHISQ.INV.RT function

What is the CHISQ.INV.RT function? The CHISQ.INV.RT function was introduced in Excel 2010 and calculates the inverse of the right-tailed […]

How to use the CHISQ.INV function

What is the CHISQ.INV function? The CHISQ.INV function was introduced in Excel 2010 and calculates the inverse of the left-tailed […]

How to use the CHISQ.DIST.RT function

What is the CHISQ.DIST.RT function? The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared […]

How to use the CHISQ.DIST function

What is the CHISQ.DIST function? The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check […]

How to use the BINOM.DIST function

What is the BINOM.DIST function function? The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when […]

How to use the BETA.INV function

What is the BETA.INV function? The BETA.INV function calculates the inverse of the cumulative beta distribution. This function has replaced […]

How to use the BETA.DIST function

What is the BETA.DIST function? The BETA.DIST function calculates the beta distribution. This function was introduced in Excel 2010. What […]

How to use the RANK.EQ function

What is the RANK.EQ function? The RANK.EQ function calculates the rank of a number in a list of numbers, based […]

How to use the CONFIDENCE.T function

What is the CONFIDENCE.T function? The CONFIDENCE.T function calculates the confidence range for a population mean using a Student's t […]

How to use the CONFIDENCE.NORM function

What is the CONFIDENCE.NORM function? The CONFIDENCE.NORM function calculates the confidence interval for a population mean. What is a confidence […]

How to use the MODE.SNGL function

What is the MODE.SNGL function? The MODE.SNGL function calculates the most frequent number in an array or cell range. It […]

How to use the GROWTH function

What is the GROWTH function? The GROWTH function returns estimated exponential growth based on given data. It calculates the y-values […]

How to use the GEOMEAN function

What is the GEOMEAN function? The GEOMEAN function lets you calculate the geometric mean in Excel. The geometric mean is […]

How to use the GAMMA function

What is the GAMMA function? The GAMMA function calculates the GAMMA value. It is an extension of the factorial function […]

How to use the SLOPE function

What is the SLOPE function? The SLOPE function calculates the slope of the linear regression line through coordinates. What is […]

How to use the SKEW function

What is the SKEW function? The SKEW function calculates the skewness of a group of values with an asymmetric tail from […]

How to use the PROB function

The PROB function calculates the probability that values in a range are between a given lower and upper limit. What […]

How to use the PHI function

What is the PHI function? The PHI function calculates a number of the density function for a standard normal distribution. What […]

How to use the MINIFS function

What is the MINIFS function? The MINIFS function calculates the smallest value based on a given set of criteria. Related […]

How to use the MINA function

What is the MINA function? The MINA function returns the smallest number from an array or cell range. Text values […]

How to use the NORM.INV function

What is the NORM.INV function? The NORM.INV function calculates the inverse of the normal cumulative distribution for a given mean […]

How to use the NORM.DIST function

What is the NORM.DIST function? The NORM.DIST function calculates the normal distribution for a given mean and standard deviation. What […]

How to use the VAR.S function

The VAR.S function tries to estimate the variance based on a sample of the population. The function ignores logical and […]

How to use the VAR.P function

What is the VAR.P function? The VAR.P function returns the variance based on the entire population. The function ignores logical […]

How to use the FORECAST.LINEAR function

What is the FORECAST.LINEAR function? The FORECAST.LINEAR function calculates a value based on existing x and y values using linear […]

How to use the AVEDEV function

What is the AVEDEV function? The AVEDEV function calculates the average of the absolute deviations of data points from their […]

How to use the TRIMMEAN function

What is the TRIMMEAN function? The TRIMMEAN function calculates the mean of the interior of a data set. The function […]

How to use the TREND function

What is the TREND function? The TREND function calculates values along a linear trend. Fits a straight line (using the […]

How to use the STDEVPA function

What is the STDEVPA function? The STDEVPA function returns the standard deviation based on the entire population. It evaluates Boolean […]

How to use the STANDARDIZE function

What is the STANDARDIZE function? The STANDARDIZE function calculates a normalized value from a distribution characterized by mean and standard_dev. […]

How to use the STDEV.S function

What is the STDEV.S function? The STDEV.S function returns standard deviation based on a sample. What is Standard Deviation? Standard […]

How to use the STDEV.P function

What is the STDEV.P function? The STDEV.P function returns standard deviation based on the entire population. STDEV.P is an abbreviation […]

How to use the RANK.AVG function

What is the RANK.AVG function? The RANK.AVG function returns the rank of a number in a list of numbers. The […]

How to use the QUARTILE.INC function

What is the QUARTILE.INC function? The QUARTILE.INC function returns the quartile of a data set, based on percentile values from […]

How to use the EXPON.DIST function

What is the EXPON.DIST function? The EXPON.DIST function calculates the exponential distribution representing an outcome in the form of probability. This […]

How to use the CORREL function

What is the CORREL function? The CORREL function calculates the correlation between two groups of numbers. What is the correlation in […]

How to use the AVERAGEA function

What is the AVERAGEA function? The AVERAGEA function returns the average of a group of values. Text and boolean value FALSE […]

How to use the STDEVA function

The STDEVA function estimates the standard deviation from a sample of values. It evaluates Boolean value TRUE as 1, FALSE […]

How to use the MODE.MULT function

What is the MODE.MULT function? The MODE.MULT function calculates the most frequent number in a cell range. It will return […]

How to use the MEDIAN function

What is the MEDIAN function? The MEDIAN function calculates the median based on a set of numbers in Excel. The […]

How to use the PERMUTATIONA function

What is the PERMUTATIONA function? The PERMUTATIONA function returns the number of permutations for a specific number of elements that […]

How to use the PERMUT function

The PERMUT function returns the number of permutations for a set of elements that can be selected from a larger […]

How to use the COUNTBLANK function

The COUNTBLANK function counts empty or blank cells in a range. The picture above demonstrates the COUNTBLANK function entered in […]

How to use the COUNTA function

The COUNTA function counts the non-empty or non-blank cells in a cell reference. Table of Contents COUNTA function Syntax COUNTA […]

How to use the MAX function

The MAX function calculates the largest number in a cell range. The formula in cell D3 extracts the highest number […]

How to use the MAXIFS function

The MAXIFS function returns the largest number based on a condition or criteria. The MAXIFS function was introduced in Excel […]

How to use the LARGE function

The LARGE function calculates the k-th largest value from an array of numbers. Use the LARGE function, for example, to extract […]

How to use the COUNT function

The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments. Formula […]

How to use the AVERAGEIFS function

The AVERAGEIFS function returns the average of cell values that evaluates to TRUE for multiple criteria. Formula in cell F6: =AVERAGEIFS(D3:D8,B3:B8,F3,C3:C8,G3) […]

How to use the AVERAGEIF function

The AVERAGEIF function returns the average of cell values that are valid for a given condition. Formula in cell D3: […]

How to use the MIN function

The MIN function allows you to retrieve the smallest number in a cell range. The formula in cell D3 extracts […]

How to use the AVERAGE function

Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and […]

How to use the FREQUENCY function

Returns how many times values exist in a given range. Note, this function returns an array of values.

How to use the SMALL function

The SMALL function lets you extract a number in a cell range based on how small it is compared to the other numbers in the group.

How to use the COUNTIFS function

Checks multiple conditions against the same number of cell ranges and counts how many times all criteria are met.

How to use the COUNTIF function

Counts the number of cells that meet a specific condition.