104. Finding averages with the AVERAGE function

Finding Averages with the AVERAGE Function

The **AVERAGE** function in Excel calculates the mean of a set of numbers. It is a quick way to determine the central value of your data.

Syntax of the AVERAGE Function

=AVERAGE(number1, [number2], ...)
    
  • number1: The first number, cell reference, or range.
  • [number2]: (Optional) Additional numbers, cell references, or ranges.

Steps to Use the AVERAGE Function

  1. Select the cell where you want the result to appear.
  2. Type =AVERAGE( followed by the range or numbers to average.
  3. Close the parentheses ) and press Enter to see the result.

Interactive Example: AVERAGE Function

Item Value
Test 1 80
Test 2 90
Test 3 85
Average Click Calculate

Edit the values in the table above and click "Calculate Average" to see the AVERAGE function in action.

This example demonstrates how the AVERAGE function calculates the mean of a range of numbers in Excel.

Comments