1. Computing

Excel Statistical Functions

Excel's Statistical Functions can be used to analysis the data in a spreadsheet. For example, they can be used to tell you the number of data entries you have or the average value of your data.

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.

©2014 About.com. All rights reserved.