A Tutorial on the Open Office Calc AVERAGE Function

Find Average Values with Open Office Calc AVERAGE Function

Ted French

Mathematically, there are a number of ways of measuring central tendency or, as it is more commonly called, the average for a set of values. These methods include the arithmetic mean, the median, and the mode. The most commonly calculated measure of central tendency is the arithmetic mean - or simple average. To make it easier to the arithmetic mean Open Office Calc has a built-in function, called, not surprisingly, the AVERAGE function. 

of 02

How the Average is Calculated

The average is calculated by adding a group of numbers together and then dividing by the count of those numbers.

As shown in the example in the image above, the average for the values: 11, 12, 13, 14, 15, and 16 when divided by 6, which is 13.5 as shown in cell C7.

Instead of finding this average manually, however, this cell contains the AVERAGE function:


which not only finds the arithmetic mean for the current range of values but will also give you an updated answer should the data in this group of cells change.

of 02

The AVERAGE Function's Syntax

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments

The syntax for the AVERAGE function is:

=AVERAGE ( number 1; number 2; ...number30 )

Up to 30 numbers can be averaged by the function.

The AVERAGE Function's Arguments

number 1 (required) - the data to be averaged by the function

number 2; ... number30 (optional) - additional data that can be added to the average calculations.

The arguments can contain:

Example: Find the Average Value of a Column of Numbers

  1. Enter the following data into cells C1 to C6: 11, 12, 13, 14, 15, 16;
  2. Click on cell C7 - the location where the results will be displayed;
  3. Click on the Function Wizard icon - as shown in the image above - to open the Function Wizard dialog box;
  4. Select Statistical from the Category list;
  5. Select Average from the Function list;
  6. Click Next;
  7. Highlight cells C1 to C6 in the spreadsheet to enter this range into the dialog box in the number 1 argument line;
  8. Click OK to complete the function and close the dialog box;
  9. The number "13.5 " should appear in the cell C7, this is the average for the numbers entered in cells C1 to C6.
  10. When you click on cell C7 the complete function =AVERAGE ( C1:C6 ) appears in the input line above the worksheet

If the data you want to average is spread out in individual cells in the worksheet rather than in a single column or row, enter each individual cell reference into the dialog box on a separate argument line - such as number 1, number 2, number 3.