Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

# Statistical functions (reference)

In Excel 2010, several statistical functions have been implemented with new algorithms for improved accuracy.Read a blog post or try Office 2010! |

Click one of the links in the following list to see detailed help about the function.

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 | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |

BETADIST | Returns the beta cumulative distribution function |

BETAINV | Returns the inverse of the cumulative distribution function for a specified beta distribution |

BINOMDIST | Returns the individual term binomial distribution probability |

CHIDIST | Returns the one-tailed probability of the chi-squared distribution |

CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution |

CHITEST | Returns the test for independence |

CONFIDENCE | Returns the confidence interval for a population mean |

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 | Counts the number of cells within a range that meet multiple criteria |

COVAR | Returns covariance, the average of the products of paired deviations |

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

DEVSQ | Returns the sum of squares of deviations |

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 |

FISHERINV | Returns the inverse of the Fisher transformation |

FORECAST | Returns a value along a linear trend |

FREQUENCY | Returns a frequency distribution as a vertical array |

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, Γ(x) |

GEOMEAN | Returns the geometric mean |

GROWTH | Returns values along an exponential trend |

HARMEAN | Returns the harmonic mean |

HYPGEOMDIST | 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 |

LOGINV | Returns the inverse of the lognormal distribution |

LOGNORMDIST | Returns the cumulative lognormal 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 |

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 |

MODE | Returns the most common value in a data set |

NEGBINOMDIST | Returns the negative binomial distribution |

NORMDIST | Returns the normal cumulative distribution |

NORMINV | Returns the inverse of the normal cumulative distribution |

NORMSDIST | Returns the standard normal cumulative distribution |

NORMSINV | Returns the inverse of the standard normal cumulative distribution |

PEARSON | Returns the Pearson product moment correlation coefficient |

PERCENTILE | Returns the k-th percentile of values in a range |

PERCENTRANK | Returns the percentage rank of a value in a data set |

PERMUT | Returns the number of permutations for a given number of objects |

POISSON | Returns the Poisson distribution |

PROB | Returns the probability that values in a range are between two limits |

QUARTILE | Returns the quartile of a data set |

RANK | 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 |

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 | Estimates standard deviation based on a sample |

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

STDEVP | Calculates standard deviation based on the entire population |

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 |

TDIST | Returns the Student's t-distribution |

TINV | Returns the inverse of the Student's t-distribution |

TREND | Returns values along a linear trend |

TRIMMEAN | Returns the mean of the interior of a data set |

TTEST | Returns the probability associated with a Student's t-test |

VAR | Estimates variance based on a sample |

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

VARP | Calculates variance based on the entire population |

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

WEIBULL | Returns the Weibull distribution |

ZTEST | Returns the one-tailed probability-value of a z-test |

Applies to:

Excel 2007