Excel Statistical Functions

The AVERAGEIF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria.

The AVERAGE IFS function is used to find the average (arithmetic mean) of multiple ranges of cells that meet specific criteria. This tutorial on Excel's AVERAGE IFS function includes a step by step example.

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. This tutorial includes a step by step example of using Excel's STANDARD DEVIATION 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.