Using the AVERAGE Function


The AVERAGE function calculates the mean average of a group of numbers. To use the AVERAGE function, follow these steps:

1.

Select the cell where you want the average to appear.

2.

Click the Average link; this inserts =Average( into the selected cell.

3.

Use your keyboard or mouse to select the range of cells you want averaged.

4.

Use your keyboard to enter the ) character to close the function argument.

5.

Press the Enter key.

Google Spreadsheets now calculates the mean for the selected cells and inserts that average into the current cell.

Note

The AVERAGE function in Google Spreadsheets calculates the arithmetic mean. You calculate the mean by totaling a range of cells, then dividing the total by the number of cells in the range. For example, if you had three cells with the values 1, 2, and 3, the total would be 6, the number of cells (the COUNT) would be 3, and the mean (AVERAGE) would be 6/3, or 2.





Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net