Appendix I: Excel Spreadsheets Statistical Functions List (80)
This web page is an appendix. For more see Excel Statistical formulas in lesson 3-15
| Functions | What it Does | |
| Interesting | AVERAGE | Returns the average of its arguments |
| Interesting | AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values |
| Interesting | COUNT | Counts how many numbers are in the list of arguments |
| Interesting | COUNTA | Counts how many values are in the list of arguments) |
| Interesting | RANK | Returns the rank of a number in a list of numbers |
| Interesting | LARGE | Returns the k-th largest value in a data set |
| Interesting | SMALL | Returns the k-th smallest value in a data set |
| Rarely Used | COUNTBLANK | Counts the number of blank cells within a range |
| Obsolete | COUNTIF | Counts the number of nonblank cells within a range that meet the given criteria |
| Specialized | AVEDEV | Returns the average of the absolute deviations of data points from their mean |
| Specialized | BETADIST | Returns the cumulative beta probability density function |
| Specialized | BETAINV | Returns the inverse of the cumulative beta probability density function |
| Specialized | BINOMDIST | Returns the individual term binomial distribution probability |
| Specialized | CHIDIST | Returns the one-tailed probability of the chi-squared distribution |
| Specialized | CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution |
| Specialized | CHITEST | Returns the test for independence |
| Specialized | CONFIDENCE | Returns the confidence interval for a population mean |
| Specialized | CORREL | Returns the correlation coefficient between two data sets |
| Specialized | COVAR | Returns covariance, the average of the products of paired deviations |
| Specialized | CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
| Specialized | DEVSQ | Returns the sum of squares of deviations |
| Specialized | EXPONDIST | Returns the exponential distribution |
| Specialized | FDIST | Returns the F probability distribution |
| Specialized | FINV | Returns the inverse of the F probability distribution |
| Specialized | FISHER | Returns the Fisher transformation |
| Specialized | FISHERINV | Returns the inverse of the Fisher transformation |
| Specialized | FORECAST | Returns a value along a linear trend |
| Specialized | FREQUENCY | Returns a frequency distribution as a vertical array |
| Specialized | FTEST | Returns the result of an F-test |
| Specialized | GAMMADIST | Returns the gamma distribution |
| Specialized | GAMMAINV | Returns the inverse of the gamma cumulative distribution |
| Specialized | GAMMALN | Returns the natural logarithm of the gamma function, Γ (x) |
| Specialized | GEOMEAN | Returns the geometric mean |
| Specialized | GROWTH | Returns values along an exponential trend |
| Specialized | HARMEAN | Returns the harmonic mean |
| Specialized | HYPGEOMDIST | Returns the hypergeometric distribution |
| Specialized | INTERCEPT | Returns the intercept of the linear regression line |
| Specialized | KURT | Returns the kurtosis of a data set |
| Specialized | LINEST | Returns the parameters of a linear trend |
| Specialized | LOGEST | Returns the parameters of an exponential trend |
| Specialized | LOGINV | Returns the inverse of the lognormal distribution |
| Specialized | LOGNORMDIST | Returns the cumulative lognormal distribution |
| Specialized | MEDIAN | Returns the median of the given numbers |
| Specialized | MODE | Returns the most common value in a data set |
| Specialized | NEGBINOMDIST | Returns the negative binomial distribution |
| Specialized | NORMDIST | Returns the normal cumulative distribution |
| Specialized | NORMINV | Returns the inverse of the normal cumulative distribution |
| Specialized | NORMSDIST | Returns the standard normal cumulative distribution |
| Specialized | NORMSINV | Returns the inverse of the standard normal cumulative distribution |
| Specialized | PEARSON | Returns the Pearson product moment correlation coefficient |
| Specialized | PERCENTILE | Returns the k-th percentile of values in a range |
| Specialized | PERCENTRANK | Returns the percentage rank of a value in a data set |
| Specialized | PERMUT | Returns the number of permutations for a given number of objects |
| Specialized | POISSON | Returns the Poisson distribution |
| Specialized | PROB | Returns the probability that values in a range are between two limits |
| Specialized | QUARTILE | Returns the quartile of a data set |
| Specialized | RSQ | Returns the square of the Pearson product moment correlation coefficient |
| Specialized | SKEW | Returns the skewness of a distribution |
| Specialized | SLOPE | Returns the slope of the linear regression line |
| Specialized | SMALL | Returns the k-th smallest value in a data set |
| Specialized | STANDARDIZE | Returns a normalized value |
| Specialized | STDEV | Estimates standard deviation based on a sample |
| Specialized | STDEVA | Estimates standard deviation based on a sample, including numbers, text, and logical values |
| Specialized | STDEVP | Calculates standard deviation based on the entire population |
| Specialized | STDEVPA | Calculates standard deviation based on the entire population, including numbers, text, and logical values |
| Specialized | STEYX | Returns the standard error of the predicted y-value for each x in the regression |
| Specialized | TDIST | Returns the Student's t-distribution |
| Specialized | TINV | Returns the inverse of the Student's t-distribution |
| Specialized | TREND | Returns values along a linear trend |
| Specialized | TRIMMEAN | Returns the mean of the interior of a data set |
| Specialized | TTEST | Returns the probability associated with a Student's t-test |
| Specialized | VAR | Estimates variance based on a sample |
| Specialized | VARA | Estimates variance based on a sample, including numbers, text, and logical values |
| Specialized | VARP | Calculates variance based on the entire population |
| Specialized | VARPA | Calculates variance based on the entire population, including numbers, text, and logical values |
| Specialized | WEIBULL | Returns the Weibull distribution |
| Specialized | ZTEST | Returns the two-tailed P-value of a z-test |