# Statistical Functions

## Content

DsExcel.NET provides the following statistical functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [AVEDEV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/avedev) | This function calculates the average of the absolute deviations of the specified values from their mean. |
| [AVERAGE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/average) | This function calculates the average of the specified numeric values. |
| [AVERAGEA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/averagea) | This function calculates the average of the specified values, including text or logical values as well as numeric values. |
| [AVERAGEIF](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/averageif) | This function calculates the average of the specified numeric values provided that they meet the specified criteria. |
| [AVERAGEIFS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/averageifs) | This function calculates the average of all cells that meet multiple specified criteria. |
| [BETA.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/betadist) | This function returns the beta distribution. |
| [BETA.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/betainv) | This function calculates the inverse of the cumulative beta distribution function. |
| [BINOM.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/binomdist) | This function calculates the individual term binomial distribution probability. |
| [BINOM.DIST.RANGE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/binomdistrange) | This function calculates the probability of a trial result using a binomial distribution. |
| [BINOM.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/binominv) | This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| [CHISQ.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/chisqdist) | This function returns the chi-squared distribution. |
| [CHISQ.DIST.RT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/chisqdistrt) | This function calculates the one-tailed probability of the chi-squared distribution. |
| [CHISQ.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/chisqinv) | This function returns the inverse of left-tailed probability of the chi-squared distribution. |
| [CHISQ.INV.RT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/chisqinvrt) | This function calculates the inverse of the one-tailed probability of the chi-squared distribution. |
| [CHISQ.TEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/chisqtest) | This function calculates the test for independence from the chi-squared distribution. |
| [CONFIDENCE.NORM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/confidencenorm) | This function returns a confidence interval for a population mean. |
| [CONFIDENCE.T](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/confidencet) | This function returns the confidence interval for a Student's t distribution. |
| [CORREL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/correl) | This function returns the correlation coefficient of the two sets of data. |
| [COUNT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/count) | This function returns the number of cells that contain numbers. |
| [COUNTA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/counta) | This function returns the number of cells that contain numbers, text, or logical values. |
| [COUNTBLANK](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/countblank) | This function returns the number of empty (or blank) cells in a range of cells on a sheet. |
| [COUNTIF](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/countif) | This function returns the number of cells that meet a certain condition. |
| [COUNTIFS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/countifs) | This function returns the number of cells that meet multiple conditions. |
| [COVARIANCE.P](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/covariancep) | This function returns the covariance, which is the average of the products of deviations for each data point pair in two sets of numbers. |
| [COVARIANCE.S](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/covariances) | This function returns the sample covariance, which is the average of the products of deviations for each data point pair in two sets of numbers. |
| [DEVSQ](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/devsq) | This function calculates the sum of the squares of deviations of data points (or of an array of data points) from their sample mean. |
| [EXPON.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/expondist) | This function returns the exponential distribution or the probability density. |
| [F.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/fdist) | This function returns the F probability distribution. |
| [F.DIST.RT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/fdistrt) | This function calculates the F probability distribution, to see degrees of diversity between two sets of data. |
| [F.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/finv) | This function returns the inverse of the F probability distribution. |
| [F.INV.RT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/finvrt) | This function returns the inverse of the F probability distribution. |
| [F.TEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/ftest) | This function returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different. |
| [FISHER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/fisher) | This function returns the Fisher transformation for a specified value. |
| [FISHERINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/fisherinv) | This function returns the inverse of the Fisher transformation for a specified value. |
| [FORECAST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/forecast) | This function calculates a future value using existing values. |
| [FORECAST.LINEAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/forecastlinear) | This function returns a future value based on existing values |
| [FREQUENCY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/forecastlinear) | This function calculates how often values occur within a range of values. This function returns a vertical array of numbers. |
| [GAMMA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/gamma) | This function returns the gamma function value. |
| [GAMMA.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/gammadist) | This function returns the gamma distribution. |
| [GAMMA.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/gammainv) | This function returns the inverse of the gamma cumulative distribution. |
| [GAMMALN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/gammaln) | This function returns the natural logarithm of the Gamma function, G(x). |
| [GAMMALN.PRECISE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/gammalnprecise) | This function returns the natural logarithm of the gamma function. |
| [GAUSS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/gauss) | This function calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean. |
| [GEOMEAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/geomean) | This function returns the geometric mean of a set of positive data. |
| [GROWTH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/growth) | This function calculates predicted exponential growth. This function returns the y values for a series of new x values that are specified by using existing x and y values. |
| [HARMEAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/harmean) | This function returns the harmonic mean of a data set. |
| [HYPGEOM.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/hypgeomdist) | This function returns the hypergeometric distribution. |
| [INTERCEPT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/intercept) | This function returns the coordinates of a point at which a line intersects the y-axis, by using existing x values and y values. |
| [KURT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/normdist) | This function returns the kurtosis of a data set. |
| [LARGE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/large) | This function returns the nth largest value in a data set, where n is specified. |
| [LINEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/linest) | This function calculates the statistics for a line. |
| [LOGEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/logest) | This function calculates an exponential curve that fits the data and returns an array of values that describes the curve. |
| [LOGNORM.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/lognormdist) | This function returns the log-normal distribution of x. |
| [LOGNORM.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/lognorminv) | This function returns the inverse of the lognormal cumulative distribution function of x, where LN(x) is normally distributed with the specified mean and standard deviation. |
| [MAX](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/max) | This function returns the maximum value, the greatest value, of all the values in the arguments. |
| [MAXA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/maxa) | This function returns the largest value in a list of arguments, including text and logical values. |
| [MAXIFS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/maxifs) | This function returns the maximum value among cells specified by a given set of conditions or criteria. |
| [MEDIAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/median) | This function returns the median, the number in the middle of the provided set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less than the median. |
| [MIN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/min) | This function returns the minimum value, the least value, of all the values in the arguments. |
| [MINA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/mina) | This function returns the minimum value in a list of arguments, including text and logical values. |
| [MINIFS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/minifs) | This function returns the minimum value among cells specified by a given set of conditions or criteria. |
| [MODE.MULT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/modemult) | This function returns the most frequently occurring vertical array or the occurring value in a set of data. |
| [MODE.SNGL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/modesngl) | This function returns the most frequently occurring value in a set of data. |
| [NEGBINOM.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/negbinomdist) | This function returns the negative binomial distribution. |
| [NORM.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/negbinomdist) | This function returns the normal cumulative distribution for the specified mean and standard deviation. |
| [NORM.S.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/normsdist) | This function returns the standard normal distribution. |
| [NORM.S.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/normsinv) | This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. |
| [NORMINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/norminv) | This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation. |
| [PEARSON](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/pearson) | This function returns the Pearson product moment correlation coefficient, a dimensionless index between -1.0 to 1.0 inclusive indicative of the linear relationship between two data sets. |
| [PERCENTILE.EXC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/percentileexc) | This function returns the nth percentile of values in a range. |
| [PERCENTILE.INC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/percentileinc) | This function returns the nth percentile of values in a range. |
| [PERCENTRANK.EXC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/percentrankexc) | This function returns the percentage rank(0..1, exclusive) of a value in a data set. |
| [PERCENTRANK.INC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/percentrankinc) | This function returns the rank of a value in a data set as a percentage of the data set. |
| [PERMUT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/permut) | This function returns the number of possible permutations for a specified number of items. |
| [PERMUTATIONA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/permutationa) | This function returns the number of permutations for a given number of objects that can be selected from the total objects. |
| [PHI](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/phi) | This function returns the value of the density function for a standard normal distribution. |
| [POISSON.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/poissondist) | This function returns the Poisson distribution. |
| [PROB](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/prob) | This function returns the probability that values in a range are between two limits. |
| [QUARTILE.EXC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/quartileexc) | This function returns which quartile (which quarter or 25 percent) of a data set a value is. |
| [QUARTILE.INC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/quartileinc) | This function returns which quartile (which quarter or 25 percent) of a data set a value is. |
| [RANK.AVG](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/rankavg) | This function returns the rank of a number in a set of numbers. If some values have the same rank, it will return the average rank. |
| [RANK.EQ](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/rankeq) | This function returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list. |
| [RSQ](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/rsq) | This function returns the square of the Pearson product moment correlation coefficient (R-squared) through data points in known y's and known x's. |
| [SKEW](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/skew) | This function returns the skewness of a distribution. |
| [SKEW.P](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/skewp) | This function returns the skewness of a distribution base on a population: characterization of the degree of asymmetry of a distribution around its mean. |
| [SLOPE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/slope) | This function calculates the slope of linear regression. |
| [SMALL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/small) | This function returns the nth smallest value in a data set, where n is specified. |
| [STANDARDIZE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/standardize) | This function returns a normalized value from a distribution characterized by mean and standard deviation. |
| [STDEV.P](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/stdevp) | This function returns the standard deviation for an entire specified population (of numeric values). |
| [STDEV.S](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/stdevs) | This function returns a standard deviation estimated based on a sample. |
| [STDEVA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/stdeva) | This function returns the standard deviation for a set of numbers, text, or logical values. |
| [STDEVPA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/stdevpa) | This function returns the standard deviation for an entire specified population, including text or logical values as well as numeric values. |
| [STEYX](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/steyx) | This function returns the standard error of the predicted y value for each x. The standard error is a measure of the amount of error in the prediction of y for a value of x. |
| [T.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/tdist) | This function returns the t-distribution. |
| [T.DIST.2T](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/tdist2t) | This function returns the two-tailed t-distribution. |
| [T.DIST.RT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/tdistrt) | This function returns the right-tailed t-distribution. |
| [T.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/tinv) | This function returns the left-tailed inverse of the t-distribution. |
| [T.INV.2T](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/tinv2t) | This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom. |
| [T.TEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/ttest) | This function returns the probability associated with a t-test. |
| [TREND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/trend) | This function returns values along with a linear trend. This function fits a straight line to the arrays known as x and y values. Trend returns the y values along that line for the array of specified new x values. |
| [TRIMMEAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/trimmean) | This function returns the mean of a subset of data excluding the top and bottom data. |
| [VAR.P](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/varp) | This function returns variance based on the entire population, which uses only numeric values. |
| [VAR.S](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/vars) | This function returns the variance based on a sample of a population, which uses only numeric values. |
| [VARA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/vara) | This function returns the variance based on a sample of a population, which includes numeric, logical, or text values. |
| [VARPA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/varpa) | This function returns variance based on the entire population, which includes numeric, logical, or text values. |
| [WEIBULL.DIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/weibulldist) | This function returns the two-parameter Weibull distribution, often used in reliability analysis. |
| [Z.TEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/statistical-functions/ztest) | This function returns the significance value of a z-test. The z-test generates a standard score for x with respect to the set of data and returns the two-tailed probability for the normal distribution. |