Guides

## Other Statistical Functions

Excel > Excel 2003 Foundation > Formulas

# Statistical Functions

There are a number of statistical functions in Excel which can be used to analyse the data in your spreadsheet. These include, but are not limited to Count, Average, Min and Max.

## Count

Returns the number of values from a list.

The syntax for the Count function is:

=COUNT(value1, [value2], ...)

## Average

Returns the average or arithmetic mean of a list of values.

The syntax for the Average function is:

=AVERAGE(number1, [number2], ...)

## Min

Returns the smallest number from a list of values.

The syntax for the Min function is:

=MIN(number1, [number2], ...)

## Max

Returns the largest number from a list of values.

The syntax for the Max function is:

=MAX(number1, [number2], ...)

## Entering a statistical function

1. Select the cell where you wish the result to be displayed.
2. Click the drop list arrow next to the AutoSum button on the toolbar.
3. The function will appear and Excel will select a range it thinks you wish to calculate. If this is incorrect select the range you wish to use.
4. The example below uses the average function.

5. Press Enter. The result appears in the cell and the function can be seen in the formula bar.

These statistical functions follow the same syntax as the Sum function. It is possible to select more than one range of values to calculate. To do so, separate each cell range with a comma.