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