How to calculate average function

AVERAGE function is a function that calculates the arithmetic average.

1. The AVERAGE function is classified as a statistical function among other functions in the EXCEL2007 version and is used to return the arithmetic mean of a set of data.

#2. The AVERAGE function can set up to 255 parameters, and the parameters can be numbers, names, arrays, or references.

#3. Let’s take a set of examples to see how to use the AVERAGE function. As shown in the figure below, we need to calculate the average income of the 8 people in the table. The income of each person is a numerical value. We directly enter the formula: "=AVERAGE(C2:C9)" to calculate the per capita income.

4. As shown in the figure below, it is necessary to calculate the average sales of 8 people. The sales volume and sales unit price of each person are different. The sales of each person is equal to the sales The volume is multiplied by the sales unit price. The sales here is the result calculated by a formula. We enter the formula: "=AVERAGE(E2:E9)" to calculate the per capita sales.

5. Let’s look at another situation. The sales unit price is fixed and each person’s sales volume is different. The sales volume of each person is equal to the fixed sales unit price times the sales. Volume, sales per person is also a formula. To calculate per capita sales, you need to enter the formula: "=AVERAGE(D4:D11)" to calculate per capita sales.

6. Let’s take a look at the situation where the parameters are names. We first set the two names of “fixed data 1 and fixed data 2”. “Fixed data 1” is equal to 250, "fixed data 2" is equal to "fixed data 1*3".

7. We need to calculate the arithmetic average of 6 changing data and 2 names. We can enter the formula: "=AVERAGE(fixed data 1, fixed data 2, A2:F2)" can calculate the arithmetic mean of these 8 values.

For more Excel-related technical articles, please visit the Excel Basic Tutorial Column to learn!

The above is the detailed content of How to calculate average function. For more information, please follow other related articles on the PHP Chinese website!