What is the Excel AVERAGE function?

What is the Excel AVERAGE function?

By /

The Excel AVERAGE function is a built-in mathematical formula that calculates the average (or arithmetic mean) of a given set of numbers in an Excel spreadsheet. It takes into account all the numbers in a specified range and divides them by the total number of values in that range to provide the average value. This function is commonly used for data analysis and is a quick and efficient way to determine the central tendency of a data set. It is a useful tool for businesses, academics, and individuals looking to analyze numerical data in an organized and accurate manner.

Excel AVERAGE Function

AVERAGE Function

The AVERAGE function is a premade function in Excel, which calculates the average (arithmetic mean).

It is typed =AVERAGE

It adds the range and divides it by the number of observations.

Example:

The average of (2, 3, 4) is 3.

3 observations (2, 3 and 4)

The sum of the observations (2 + 3 + 4 = 9)

(9 / 3 = 3)

The average is 3

Note: There are multiple types of mean values. The most common type of mean is the arithmetic mean. You can learn more about the arithmetic mean here: Statistics Mean Tutorial.

Note: The AVERAGE function ignores cells with text.

Let’s have a look at an example where we help the Pokemon trainers to calculate the average of Pokeballs per trainer.

How to use the =AVERAGE function, step by step:

  1. Select a cell (F2)
  2. Type =AVERAGE
  3. Double click the AVERAGE command
  4. Select a range (B2:E2)
  5. Hit enter
  6. Next, Fill F2:F7

Good job! You have successfully calculated the average using the AVERAGE function.

Another Example

Example using cells with text:

The function ignores cells with text and completes the calculation.

Cite this article

stats writer (2024). What is the Excel AVERAGE function?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/what-is-the-excel-average-function/

stats writer. "What is the Excel AVERAGE function?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/what-is-the-excel-average-function/.

stats writer. "What is the Excel AVERAGE function?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/what-is-the-excel-average-function/.

stats writer (2024) 'What is the Excel AVERAGE function?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/what-is-the-excel-average-function/.

[1] stats writer, "What is the Excel AVERAGE function?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. What is the Excel AVERAGE function?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How can I use the AVERAGE function in excel to calculate the average value of a range of cells?
  2. “How can I calculate the average of a set of values using the AVERAGE function in Excel?”
  3. How can I use the SUBTOTAL function to calculate the average of a range of cells in Excel?
  4. How can I use the AVEDEV function in Excel to calculate the average absolute deviation of a set of data?
  5. How can I calculate the average value of a range of cells in excel using the AVERAGEA function?
  6. How can I use the AVERAGEIF function in Excel to calculate the average of a range of cells based on specified criteria?
  7. How can I use the AVERAGEIFS function in Excel to calculate the average of a range of cells based on multiple criteria?
  8. How can I use the RANK.AVG function in Excel to calculate the average rank of a value within a given range of data?
  9. How can I use the AVERAGEIF function in Google Sheets to find the average value of a range of cells based on a certain criteria?
  10. How can I use the RANK.AVG function in Google Sheets to calculate the average rank of a set of values?
Slide Up
x
PDF
Scroll to Top