The AVERAGEIF function

The AVERAGEIF function

Returns the average (arithmetic average) of all cells in a range that meet a certain criteria. Is the like “average” of SUMIF.

The AVERAGE YES 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
• MedianThe median is a statistical measure that represents the central value of a set of ordered data. To calculate it, the data is organized from lowest to highest and the number in the middle is identified. If there are an even number of observations, the two core values are averaged. This indicator is especially useful in asymmetric distributions, since it is not affected by extreme values....: 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 YES The function uses the following syntax to operate:

The AVERAGE YES The function has the following arguments:

• encompass: This is required. One or more cells to use for the criteria, including numbers, Names, arrays or references containing numbers.
• criterion: this is also necessary. The criterion in the form of a number, expression, cell or text reference that sets which cells are averaged. As an example, the criteria can be expressed as 32, “32”, “> 32”, “apples”, B4 O “> =” &B4.
• average range: Optional. The actual set of cells to average. If omitted, range is used. Despite this, be careful: and a average range it is specified that it does not have the same dimensions as encompass, the average range will be modified using the upper left cell specified in the range, but then use the dimensions that correspond in size and shape to encompass, p.ej