Download Excel Statistical Functions Cheat Sheet and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity! Statistical Functions 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. 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 DEVSQ Returns the sum of squares of deviations FISHER Returns the Fisher transformation FISHERINV Returns the inverse of the Fisher transformation FREQUENCY Returns a frequency distribution as a vertical array 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 HYPGEOM.DIST 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 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 PEARSON Returns the Pearson product moment correlation coefficient PERMUT Returns the number of permutations for a given number of objects
