Use this list as a reference for each statistical function.

- AVERAGE function

AVERAGE returns the average of the arguments. - AVERAGEA function

AVERAGEA returns the average of the arguments. The value of a text is 0. - COUNT function

COUNT counts how many numbers are in the list of arguments. Text entries are ignored. - COUNTA function

COUNTA counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored. - LARGE function

LARGE returns the nth largest value from a set of values. - MAX function

MAX returns the maximum value in a list of arguments. - MEDIAN function

MEDIAN returns the median (middle) value in the list. - MIN function

MIN returns the minimum value in a list of arguments. - MODE function

MODE returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value does not appear twice. - RANK function

RANK returns the rank of a number in a sample. - SMALL function

SMALL returns the nth smallest value from a set of values. - STDEV function

STDEV estimates the standard deviation based on a sample. - STDEVP function

STDEVP calculates the standard deviation based on the entire population.