Documentation

Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.

Excel Function: AVEDEV(value1[,value2[, ...]])

Returns the average (arithmetic mean) of the arguments

Excel Function: AVERAGE(value1[,value2[, ...]])

Returns the average of its arguments, including numbers, text, and logical values

Excel Function: AVERAGEA(value1[,value2[, ...]])

Returns the average value from a range of cells that contain numbers within the list of arguments

Excel Function: AVERAGEIF(value1[,value2[, ...]],condition)

Returns the beta distribution.

Returns the inverse of the Beta distribution.

Returns the individual term binomial distribution probability. Use BINOMDIST in problems with a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability of success is constant throughout the experiment. For example, BINOMDIST can calculate the probability that two of the next three babies born are male.

Returns the one-tailed probability of the chi-squared distribution.

Returns the one-tailed probability of the chi-squared distribution.

Returns the confidence interval for a population mean

Returns covariance, the average of the products of deviations for each data point pair.

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNT(value1[,value2[, ...]])

Counts the number of cells that are not empty within the list of arguments

Excel Function: COUNTA(value1[,value2[, ...]])

Counts the number of empty cells within the list of arguments

Excel Function: COUNTBLANK(value1[,value2[, ...]])

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNTIF(range,condition)

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Returns covariance, the average of the products of deviations for each data point pair.

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value

See https://support.microsoft.com/en-us/help/828117/ for details of the algorithm used

Returns the sum of squares of deviations of data points from their sample mean.

Excel Function: DEVSQ(value1[,value2[, ...]])

Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.

Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school, and determine if the variability in the females is different from that found in the males.

Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.

Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value.

Returns the gamma distribution.

Returns the gamma function value.

The result, or a string containing an error

Returns the inverse of the Gamma distribution.

Returns the natural logarithm of the gamma function.

Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.

The result, or a string containing an error

Returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.

Excel Function: GEOMEAN(value1[,value2[, ...]])

Returns values along a predicted exponential Trend

Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.

Excel Function: HARMEAN(value1[,value2[, ...]])

Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size.

Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.

Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.

Returns the nth largest value in a data set. You can use this function to select a value based on its relative standing.

Excel Function: LARGE(value1[,value2[, ...]],entry)

The result, or a string containing an error

Calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.

The result, or a string containing an error

Calculates an exponential curve that best fits the X and Y data series, and then returns an array that describes the line.

The result, or a string containing an error

Returns the inverse of the normal cumulative distribution

The result, or a string containing an error

Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.

The result, or a string containing an error

Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.

The result, or a string containing an error

MAX returns the value of the element of the values passed that has the highest value, with negative numbers considered smaller than positive numbers.

Excel Function: max(value1[,value2[, ...]])

Returns the greatest value in a list of arguments, including numbers, text, and logical values

Excel Function: maxA(value1[,value2[, ...]])

Counts the maximum value within a range of cells that contain numbers within the list of arguments

Excel Function: MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Returns the median of the given numbers. The median is the number in the middle of a set of numbers.

Excel Function: MEDIAN(value1[,value2[, ...]])

The result, or a string containing an error

MIN returns the value of the element of the values passed that has the smallest value, with negative numbers considered smaller than positive numbers.

Excel Function: MIN(value1[,value2[, ...]])

Returns the smallest value in a list of arguments, including numbers, text, and logical values

Excel Function: MINA(value1[,value2[, ...]])

Returns the minimum value within a range of cells that contain numbers within the list of arguments

Excel Function: MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Returns the most frequently occurring, or repetitive, value in an array or range of data

Excel Function: MODE(value1[,value2[, ...]])

The result, or a string containing an error

Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.

The result, or a string containing an error

Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.

The result, or a string containing an error

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

The result, or a string containing an error

Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.

The result, or a string containing an error

Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.

The result, or a string containing an error

Returns the inverse of the standard normal cumulative distribution

The result, or a string containing an error

Returns the nth percentile of values in a range..

Excel Function: PERCENTILE(value1[,value2[, ...]],entry)

The result, or a string containing an error

Returns the rank of a value in a data set as a percentage of the data set. Note that the returned rank is simply rounded to the appropriate significant digits, rather than floored (as MS Excel), so value 3 for a value set of 1, 2, 3, 4 will return 0.667 rather than 0.666

(string if result is an error)

Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. Use this function for lottery-style probability calculations.

Number of permutations, or a string containing an error

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.

The result, or a string containing an error

Returns the quartile of a data set.

Excel Function: QUARTILE(value1[,value2[, ...]],entry)

The result, or a string containing an error

Returns the rank of a number in a list of numbers.

The result, or a string containing an error

Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.

The result, or a string containing an error

Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

The result, or a string containing an error

Returns the slope of the linear regression line through data points in known_y's and known_x's.

The result, or a string containing an error

Returns the nth smallest value in a data set. You can use this function to select a value based on its relative standing.

Excel Function: SMALL(value1[,value2[, ...]],entry)

The result, or a string containing an error

Returns a normalized value from a distribution characterized by mean and standard_dev.

Standardized value, or a string containing an error

Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Excel Function: STDEV(value1[,value2[, ...]])

The result, or a string containing an error

Estimates standard deviation based on a sample, including numbers, text, and logical values

Excel Function: STDEVA(value1[,value2[, ...]])

Calculates standard deviation based on the entire population

Excel Function: STDEVP(value1[,value2[, ...]])

Calculates standard deviation based on the entire population, including numbers, text, and logical values

Excel Function: STDEVPA(value1[,value2[, ...]])

Returns the probability of Student's T distribution.

The result, or a string containing an error

Returns the one-tailed probability of the Student-T distribution.

The result, or a string containing an error

Returns values along a linear Trend

Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set.

Excel Function: TRIMEAN(value1[,value2[, ...]], $discard)

Estimates variance based on a sample, including numbers, text, and logical values

Excel Function: VARA(value1[,value2[, ...]])

(string if result is an error)

Estimates variance based on a sample.

Excel Function: VAR(value1[,value2[, ...]])

(string if result is an error)

Calculates variance based on the entire population

Excel Function: VARP(value1[,value2[, ...]])

(string if result is an error)

Calculates variance based on the entire population, including numbers, text, and logical values

Excel Function: VARPA(value1[,value2[, ...]])

(string if result is an error)

Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.

(string if result is an error)

Returns the one-tailed P-value of a z-test.

For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.

(string if result is an error)