AVERAGE

The AVERAGE function is used to calculate the average of a set of values in Excel. This function is commonly utilized in data analysis and reporting to determine the central tendency of a dataset.

Syntax

=AVERAGE(number1, number2, ...)

number1 number2 ... The numerical values for which you want to calculate the average.

About AVERAGE

When tasked with evaluating the central value in a pool of numerical data, the AVERAGE function in Excel emerges as a dependable ally. This function seamlessly collates the input values and delivers their arithmetic mean, offering valuable insights into the overall trend or midpoint of the dataset. It serves as an invaluable tool for conducting statistical analysis, aiding in decision-making processes across diverse domains ranging from finance to academia. By leveraging AVERAGE, you can efficiently compute the mean of a collection of values, shedding light on the typical magnitude or level prevalent within the dataset. Whether navigating large-scale datasets or conducting regular assessments, AVERAGE stands as a foundational pillar supporting numerical analyses in Excel.

Examples

Suppose you have a list of values representing monthly sales figures for a year: $1500, $2000, $1800, $2500, $1900, and $2200. The AVERAGE formula would be: =AVERAGE(1500, 2000, 1800, 2500, 1900, 2200). This will return the average monthly sales figure for the year.

Suppose you have a range of cells containing test scores in your worksheet: B2:B10. The AVERAGE formula would be: =AVERAGE(B2:B10). This will return the average test score of the students within the specified range of cells.

Questions

How does the AVERAGE function handle non-numeric values or empty cells?

The AVERAGE function omits non-numeric values and empty cells when computing the average. It only considers the numerical values provided as arguments or within the specified range.

Can the AVERAGE function handle a large set of values?

Yes, the AVERAGE function can handle a large set of values provided as arguments, or within a range of cells. It efficiently processes the input values to deliver the arithmetic mean.

Is the AVERAGE function suitable for determining the median of a dataset?

No, the AVERAGE function calculates the arithmetic mean of the input values and is not designed to determine the median. To calculate the median, you would use the MEDIAN function in Excel.

Related functions

MEDIAN
MAX
MIN
SUM
STDEV
VAR