Excel Statistical Functions

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

FunctionPurposeParam,Optional
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 ...