Skip to content

Statistical Functions

AVEDEV Retuns the average of the absolute deviations of data points from their mean.
AVERAGE Returns the average of its arguments.
AVERAGEA Returns the average of the values in its list of arguments including text and logical values.Returns the average of the values in its list of arguments including text and logical values.
BETADIST Returns the cumulative beta probability density function.
BETAINV Returns the inverse of the cumulative beta probability density function.
BINOMDIST Returns the individual term binomial distribution probability.
CHIDIST Returns the one-tailed probability of the chi-squared (X^2) distribution; the area in the right tail under the chi-squared distribution curve.
CHIINV Returns the inverse of the one-tailed probability of the chi-squared (X^2) distribution.
CHITEST Returns the test for independence of the characteristics in a table.
CONFIDENCE Returns the confidence interval for a population mean.
CORREL Returns the correlation coefficient between two data sets.
COUNT Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments.
COUNTA Counts the number of cells that are not empty.
COUNTBLANK Counts the empty cells in a specified range.
COUNTIF Counts the number of cells in a range that meet a given criteria.
COVAR Returns the covariance, the average of products of deviations, for each data point pair.
CRITBINOM Returns the minimum number yields a binomial distribution less than or equal to the specified criteria
DEVSQ Returns the sum of the squares of deviations of a data set from their sample mean.
EXPONDIST Returns the exponential distribution.
FDIST Returns the F probability distribution.
FINV Returns the inverse of the F probability distribution.
FISHER Returns the Fisher transformation at x.
FISHERINV Returns the inverse of the Fisher transformation at y.
FORECAST Calculates or predicts a future value by using existing values.
FREQUENCY Calculates how often values occur within a range of values and then returns a vertical array of numbers.
FTEST Returns the result of an F-test.
GAMMADIST Returns the gamma distribution.
GAMMAINV Returns the inverse of the gamma cumulative distribution.
GAMMALN Returns the natural logarithm of the gamma function.
GEOMEAN Returns the geometric mean of an array or range of positive data.
GROWTH Calculates predicted exponential growth by using existing data.
HARMEAN Returns the harmonic mean of a data set.
HYPGEOMDIST Returns the hypergeometric distribution.
INTERCEPT Calculates the point at which a line will intersect the y-axis by using existing x and y values.
KURT Returns the Kurtosis of a data set.
LARGE Returns the k-th largest value in a data set.
LINEST Calculates a straight line that best fits your data using the least squares method.
LOGEST Calculates an exponential curve that fits your data and returns an array of values that describes the curve.
LOGINV Returns the inverse of the lognormal cumulative distribution function of x, where in x is normally distributed with parameters mean and standard deviation.
LOGNORMDIST Returns the cumulative lognormal distribution of x, where in x is normally distributed with parameters mean and standard deviation.
MAX Returns the largest value in a set of values.
MAXA Returns the largest value in a set of values including text and logical values.
MEDIAN Returns the median of the given numbers.
MIN Returns the smallest value in a set of values.
MINA Returns the smallest value in a set of values including text and logical values.
MODE Returns the most frequently occuring, or repetitive, number in an array or range of data.
NEGBINOMDIST Returns the negative binomial distribution.
NORMDIST Returns the normal cumulative distribution for the specified mean and standard deviation.
NORMINV Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMSDIST Returns the standard normal cumulative distribution function.
NORMSINV Returns the inverse of the standard normal cumulative distribution function.
PEARSON Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
PERCENTILE Returns the k-th percentile of values in a range.
PERCENTRANK Returns the rank of a value in a data set set as a percentage of the data set.
PERMUT Returns the number of permutations for a given number of objects that can be selected from a range of numbers.
POISSON Returns the Poisson distribution.
PROB Returns the probability that values in a range are between two specified limits.
QUARTILE Returns the quartile of a data set.
RANK Returns the rank of a number in a list of numbers.
RSQ Returns the r^2 value of a linear regression line.
SKEW Returns the skew of a distribution.
SLOPE Returns the slope of a regression line through data points in KNOWN*Y’S and KNOWN_X’S.
SMALL Returns the k-th smallest value in a data set.
STANDARDIZE Returns a normalized value from a distribution characterized by MEAN and STANDARD* DEV.
STDEV Estimates standard deviation based on a sample.
STDEVA Estimates standard deviation based on a sample. Includes text and logical values.
STDEVP Estimates standard deviation based on a sample assuming that the arguments represent the total population.
STDEVPA Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values.
STEYX Returns the standard error of the predicted y value for each x in the regression.
TDIST Returns the percentage points (probability) for the student t-distribution, where a numeric value x is a calculated value of t for which the percentage points are to be computed.
TINV Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom.
TREND Returns the y-values along a linear trendline that best fits the values in a data set.
TRIMMEAN Returns the mean of the interior of a data set.
TTEST The probability associated with t-test.
VAR Returns an estimate for the variance of a population based on a sample data set.
VARA Returns an estimate for the variance of a population based on a sample data set and may include text or logical values.
VARP Calculates variance based on the entire population.
VARPA Calculates variance based on the entire population and may include text or logical values.
WEIBULL Returns the Weibull distribution.
ZTEST Returns the two-tailed P-value of a z-test.