# The AVERAGEA function

#### Contents

The AVERAGEA function

Similar to AVERAGE function (discussed in our last Excel functions from A to Z blog), this function calculates the average (arithmetic average) of the values ​​in the argument list, In other words the key difference is that this works with the value of the argument instead of taking over that the argument is a number. Essentially, this means that the AVERAGE function is different from AVERAGE it works because it treats TRUE as a value of 1 and FALSE as a value of 0.

The AVERAGE The function measures what is known as “central tendency”, which is the location of the center of a group of numbers in a statistical distribution. There are three common measures of central tendency:

• Average: the arithmetic mean, calculated by adding a group of numbers and then dividing by the count of those numbers. As an example, the average of 2, 3, 3, 5, 7 Y 10 it is 30 divided by 6, What is it 5
• Median: the middle number of a group of numbers; In other words, half of the numbers have values ​​greater than the median and half of the numbers have values ​​less than the median. As an example, the median of 2, 3, 3, 5, 7 Y 10 it is 4. If the number of values ​​in the selection is an even number, the median is set as the midpoint between the two middle numbers.
• Way: the most frequently occurring number in a group of numbers. As an example, the fashion of 2, 3, 3, 5, 7 Y 10 it is 3.

For a symmetric distribution of a group of numbers, these three measures of central tendency are all the same. For a skewed distribution of a group of numbers, they can be different.

The AVERAGE The function uses the following syntax to operate:

AVERAGEEA (valor1, [value2], …)

The AVERAGE The function has the following arguments:

• valor1: This is required
• value 2,…: subsequent values ​​are optional. It can have between one and 255 cells, cell ranges.

You should pay attention that when you average cells, there is a difference between empty cells and those containing the value zero. If you have deactivated the check box 'Show a zero in cells that have a zero value’ in the Excel Options dialog box in Excel, you may not realize that zeros are included in the average calculation. To locate the check box 'Show a zero in cells that have a zero value', go to Archive -> Options -> Advanced and look under 'Display options for this worksheet'.