Excel Statistical Functions

This chapter gives an overview of some very useful statistical functions in Excel.

FunctionPurposeParam,Optional
AVERAGE Get the average of a group of numbers number1number2 ...
AVERAGEA Get the average of a group of numbers and text value1value2 ...
AVERAGEIF Get the average of numbers that meet criteria range criteriaaverage_range
COUNT Count numbers value1value2 ...
COUNTA Count the number of non-blank cells value1value2 ...
COUNTBLANK excel-countblank-function range
COUNTIF Count cells that match criteria range criteria
COUNTIFS Count cells that match multiple criteria range1 criteria1range2 criteria2 ...
FREQUENCY Get the frequency of values in a data set data_array bins_array
LARGE Get the nth largest value array n
MEDIAN Get the median of a group of numbers number1numer2 ...
MIN Get the smallest value. array
MODE Get the mode of a group of numbers number1number2 ...
RANK Rank a number against a range of numbers number arrayorder
SMALL Get the nth smallest value array n
STDEV Get the standard deviation in a sample number1number2 ...
STDEV.P Get standard deviation of population number1number2 ...
STDEV.S Get the standard deviation in a sample number1number2 ...
STDEVP Get standard deviation of population number1number2 ...