Statistical Functions

Status

Not started

Status	Function	FunctionLink	Narration	Formular
Not started	Returns the average of the absolute deviations of data points from their mean	AVEDEV
Not started	Returns the average of its arguments	AVERAGE
Not started	Returns the average of its arguments, including numbers, text, and logical values	AVERAGEA
Not started	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria	AVERAGEIF
Not started	Returns the average (arithmetic mean) of all cells that meet multiple criteria	AVERAGEIFS (2019)
Not started	Returns the beta cumulative distribution function	BETA.DIST (2010)
Not started	Returns the inverse of the cumulative distribution function for a specified beta distribution	BETA.INV (2010)
Not started	Returns the individual term binomial distribution probability	BINOM.DIST (2010)
Not started	Returns the probability of a trial result using a binomial distribution	BINOM.DIST.RANGE (2013)
Not started	Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value	BINOM.INV (2010)
Not started	Returns the cumulative beta probability density function	CHISQ.DIST (2010)
Not started	Returns the one-tailed probability of the chi-squared distribution	CHISQ.DIST.RT (2010)
Not started	Returns the cumulative beta probability density function	CHISQ.INV (2010)
Not started	Returns the inverse of the one-tailed probability of the chi-squared distribution	CHISQ.INV.RT (2010)
Not started	Returns the test for independence	CHISQ.TEST (2010)
Not started	Returns the confidence interval for a population mean	CONFIDENCE.NORM (2010)
Not started	Returns the confidence interval for a population mean, using a Student's t distribution	CONFIDENCE.T (2010)
Not started	Returns the correlation coefficient between two data sets	CORREL
Not started	Counts how many numbers are in the list of arguments	COUNT
Not started	Counts how many values are in the list of arguments	COUNTA
Not started	Counts the number of blank cells within a range	COUNTBLANK
Not started	Counts the number of cells within a range that meet the given criteria	COUNTIF
Not started	Counts the number of cells within a range that meet multiple criteria	COUNTIFS (2019)
Not started	Returns covariance, the average of the products of paired deviations	COVARIANCE.P (2010)
Not started	Returns the sample covariance, the average of the products deviations for each data point pair in two data sets	COVARIANCE.S (2010)
Not started	Returns the sum of squares of deviations	DEVSQ
Not started	Returns the exponential distribution	EXPON.DIST (2010)
Not started	Returns the F probability distribution	F.DIST (2010)
Not started	Returns the F probability distribution	F.DIST.RT (2010)
Not started	Returns the inverse of the F probability distribution	F.INV (2010)
Not started	Returns the inverse of the F probability distribution	F.INV.RT (2010)
Not started	Returns the result of an F-test	F.TEST (2010)
Not started	Returns the Fisher transformation	FISHER
Not started	Returns the inverse of the Fisher transformation	FISHERINV
Not started	Returns a value along a linear trend Note: In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions.	FORECAST
Not started	Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm	FORECAST.ETS (2016)
Not started	Returns a confidence interval for the forecast value at the specified target date	FORECAST.ETS.CONFINT (2016)
Not started	Returns the length of the repetitive pattern Excel detects for the specified time series	FORECAST.ETS.SEASONALITY (2016)
Not started	Returns a statistical value as a result of time series forecasting	FORECAST.ETS.STAT (2016)
Not started	Returns a future value based on existing values	FORECAST.LINEAR (2016)
Not started	Returns a frequency distribution as a vertical array	FREQUENCY
Not started	Returns the Gamma function value	GAMMA (2013)
Not started	Returns the gamma distribution	GAMMA.DIST (2010)
Not started	Returns the inverse of the gamma cumulative distribution	GAMMA.INV (2010)
Not started	Returns the natural logarithm of the gamma function, Γ(x)	GAMMALN
Not started	Returns the natural logarithm of the gamma function, Γ(x)	GAMMALN.PRECISE (2010)
Not started	Returns 0.5 less than the standard normal cumulative distribution	GAUSS (2013)
Not started	Returns the geometric mean	GEOMEAN
Not started	Returns values along an exponential trend	GROWTH
Not started	Returns the harmonic mean	HARMEAN
Not started	Returns the hypergeometric distribution	HYPGEOM.DIST
Not started	Returns the intercept of the linear regression line	INTERCEPT
Not started	Returns the kurtosis of a data set	KURT
Not started	LARGE	LARGE	Returns the k-th largest value in a data set	`LARGE(array, k)`
Not started	Returns the parameters of a linear trend	LINEST
Not started	Returns the parameters of an exponential trend	LOGEST
Not started	Returns the cumulative lognormal distribution	LOGNORM.DIST (2010)
Not started	Returns the inverse of the lognormal cumulative distribution	LOGNORM.INV (2010)
Not started	Returns the maximum value in a list of arguments	MAX
Not started	Returns the maximum value in a list of arguments, including numbers, text, and logical values	MAXA
Not started	Returns the maximum value among cells specified by a given set of conditions or criteria	MAXIFS (2019)
Not started	Returns the median of the given numbers	MEDIAN
Not started	Returns the minimum value in a list of arguments	MIN
Not started	Returns the smallest value in a list of arguments, including numbers, text, and logical values	MINA
Not started	Returns the minimum value among cells specified by a given set of conditions or criteria.	MINIFS (2019)
Not started	Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data	MODE.MULT (2010)
Not started	Returns the most common value in a data set	MODE.SNGL (2010)
Not started	Returns the negative binomial distribution	NEGBINOM.DIST (2010)
Not started	Returns the normal cumulative distribution	NORM.DIST (2010)
Not started	Returns the inverse of the normal cumulative distribution	NORM.INV (2010)
Not started	Returns the standard normal cumulative distribution	NORM.S.DIST (2010)
Not started	Returns the inverse of the standard normal cumulative distribution	NORM.S.INV (2010)
Not started	Returns the Pearson product moment correlation coefficient	PEARSON
Not started	Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive	PERCENTILE.EXC (2010)
Not started	Returns the k-th percentile of values in a range	PERCENTILE.INC (2010)
Not started	Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set	PERCENTRANK.EXC (2010)
Not started	Returns the percentage rank of a value in a data set	PERCENTRANK.INC (2010)
Not started	Returns the number of permutations for a given number of objects	PERMUT
Not started	Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects	PERMUTATIONA (2013)
Not started	Returns the value of the density function for a standard normal distribution	PHI (2013)
Not started	Returns the Poisson distribution	POISSON.DIST (2010)
Not started	Returns the probability that values in a range are between two limits	PROB
Not started	Returns the quartile of the data set, based on percentile values from 0..1, exclusive	QUARTILE.EXC (2010)
Not started	Returns the quartile of a data set	QUARTILE.INC (2010)
Not started	Returns the rank of a number in a list of numbers	RANK.AVG (2010)
Not started	Returns the rank of a number in a list of numbers	RANK.EQ (2010)
Not started	Returns the square of the Pearson product moment correlation coefficient	RSQ
Not started	Returns the skewness of a distribution	SKEW
Not started	Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean	SKEW.P (2013)
Not started	Returns the slope of the linear regression line	SLOPE
Not started	Returns the k-th smallest value in a data set	SMALL
Not started	Returns a normalized value	STANDARDIZE
Not started	Calculates standard deviation based on the entire population	STDEV.P (2010)
Not started	Estimates standard deviation based on a sample	STDEV.S (2010)
Not started	Estimates standard deviation based on a sample, including numbers, text, and logical values	STDEVA
Not started	Calculates standard deviation based on the entire population, including numbers, text, and logical values	STDEVPA
Not started	Returns the standard error of the predicted y-value for each x in the regression	STEYX
Not started	Returns the Percentage Points (probability) for the Student t-distribution	T.DIST (2010)
Not started	Returns the Percentage Points (probability) for the Student t-distribution	T.DIST.2T (2010)
Not started	Returns the Student's t-distribution	T.DIST.RT (2010)