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. Returns the inverse of the Fisher transformation Returns the inverse of the F probability distribution Returns the sample covariance, the average of the products deviations for each data point pair in two data sets Returns covariance, the average of the products of paired deviations Returns the correlation coefficient between two data setsĬounts how many numbers are in the list of argumentsĬounts how many values are in the list of argumentsĬounts the number of blank cells within a rangeĬounts the number of cells within a range that meet the given criteriaĬounts the number of cells within a range that meet multiple criteria Returns the confidence interval for a population mean, using a Student's t distribution Returns the confidence interval for a population mean Returns the inverse of the one-tailed probability of the chi-squared distribution Returns the one-tailed probability of the chi-squared distribution Returns the cumulative beta probability density function Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value Returns the probability of a trial result using a binomial distribution Returns the individual term binomial distribution probability Returns the inverse of the cumulative distribution function for a specified beta distribution Returns the beta cumulative distribution function Returns the average (arithmetic mean) of all cells that meet multiple criteria Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria Returns the average of its arguments, including numbers, text, and logical values Returns the average of the absolute deviations of data points from their mean For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions. These functions aren't available in earlier versions. Note: Version markers indicate the version of Excel a function was introduced.

Statistics cheat sheet