# Excel Statistical Functions

Excel AVERAGE Function

The AVERAGE function can be used to find the average or arithmetic mean of a list of numbers. Other ways of finding an average value include the MEDIAN and MODE functions listed below.

Excel AVERAGEIF

The AVERAGEIF function is used to find the average of values in cells that meet certain criteria.

Excel AVERAGEIFS Function

The AVERAGE IFS function is used to find the average (arithmetic mean) of multiple ranges of cells that meet specific criteria.

Excel Auto AVERAGE

This article shows you how to use the AutoAverage feature, a shortcut to using Excel's AVERAGE function. Included is a step by step example of using the AutoAverage feature.

Excel AutoMAX

This tutorial shows you how to use the AutoMAX function, a shortcut to using Excel's MAX function to find the largest number in a list.

Excel MIN Function

The MIN function is used to find the smallest or minimum value in a given list of numbers.

Excel AutoMIN

This article shows you how to use the AutoMIN function, a shortcut to using Excel's MIN function to find the smallest number in a list. Included is a step by step example of using the AutoMIN function.

Excel MEDIAN Function

The MEDIAN function, one of Excel's statistical functions, gives you the middle value from a list of numbers.

Excel MAX Function

The Max function is used to find the largest or maximum value in a given list of numbers.

Excel MODE.SNGL Function

The MODE.SNGL function first available Excel 2010 shows you the most frequently occurring value in a list of numbers.

Excel MODE.MULT Tutorial

The MODE.MULT function can be used to find if there are multiple modes in a data sample - that is to say that more than one value occurs most frequently.

Excel 2007 MODE Function

The MODE function tells you the most frequently occurring value in a list of numbers.

Excel 2007 STD DEV Function

One of Excel's statistical functions is the STANDARD DEVIATION function. It can be used to quickly calculate the standard deviation of a list of numbers.

Excel RANK Function

The RANK function ranks the size of a number compared to other numbers in a list.

Excel SMALL Function

The SMALL function, one of Excel's statistical functions, can be used to find data based on relative size. This article includes an example to walk you through using Excel's SMALL function.

Excel LARGE Function

The LARGE function, one of Excel's statistical functions, can be used to find data based on relative size. This article includes an example to walk you through using Excel's LARGE function.