For a few of the distributions, the CDF function also has an option to provide the probability density function (PDF). For each, the name of cumulative distribution functions (CDF) is given, and where available the name of the inverse function is also provided.

The following table provides a list of the distributions supported by Excel.

Basic statistical functionsįigure 1 – Basic Excel statistics functionsĬlick below for more information about each of these functions:ĪVERAGE, MEDIAN, MODE, GEOMEAN, HARMEAN, AVEDEV, DEVSQ, STDEV, STDEVP, VAR, VARP, KURT, SKEW, LARGE, MAX, MIN, PERCENTRANK, PERCENTILE, QUARTILE, RANK, SMALL, AVERAGEIF, AVERAGEIFS, COUNT, STANDARDIZE, TRIMMEAN Correlation and covariance functionsįigure 2 – Excel correlation and covariance functionsĬORREL, COVAR, PEARSON, RSQ, FISHER, FISHERINV Regression functionįORECAST, INTERCEPT, SLOPE, TREND, LINEST, STEYX, GROWTH, LOGEST Other statistical functionsįigure 4 – Other Excel statistical functionsĬONFIDENCE, FREQUENCY, PROB Statistical distribution functions Since these have been covered in the rest of the website, we won’t go into any detail here. Excel provides a variety of statistical functions, which we list below.

New functions in excel 2016