1. Home
  2. Computing & Technology
  3. Spreadsheets

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 2007 AVERAGEIF
The AVERAGEIF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria.
Excel 2007 MAX Function
The MAX function, one of Excel's statistical functions, is used to find the largest or maximum value in a given list of numbers. This article includes an example to walk you through using Excel's MAX function.
Excel 2007 AutoMAX
This article shows you how to use the AutoMAX function, a shortcut to using Excel's MAX function to find the largest number in a list. Included is a step by step example of using the AutoMAX function.
Excel 2007 MIN Function
The MIN function, one of Excel's statistical functions, is used to find the smallest or minimum value in a given list of numbers. This article includes an example to walk you through using Excel's MIN function.
Excel 2007 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 2007 AVERAGE Function
The AVERAGE function, one of Excel's statistical functions, is used to find the average value in a given list of arguments. This article includes an example to walk you through using Excel's AVERAGE function.
Excel 2007 AutoAVERAGE
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 2007 MEDIAN Function
The MEDIAN function, one of Excel's statistical functions, gives you the middle value from a list of numbers. This article includes an example to walk you through using Excel's MEDIAN function.
Excel 2007 MODE Function
The MODE function, one of Excel's statistical functions, tells you the most frequently occurring value in a list of numbers. This article includes an example to walk you through using Excel's MODE function.
Excel 2007 RANK Function
The RANK function, one of Excel's statistical functions, ranks the size of a number compared to other numbers in a list. This article includes an example to walk you through using Excel's RANK function.
Excel 2007 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 2007 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.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Statistical Functions

©2009 About.com, a part of The New York Times Company.

All rights reserved.