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'.
Please, see my example below: