Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less Show
This article describes the formula syntax and usage of the AVERAGE function in Microsoft Excel. DescriptionReturns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. SyntaxAVERAGE(number1, [number2], ...) The AVERAGE function syntax has the following arguments:
Remarks
Note: The AVERAGE function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. The three most common measures of central tendency are:
For a symmetrical 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. Tip: When you average cells, keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the Show a zero in cells that have a zero value check box in the Excel Options dialog box in the Excel desktop application. When this option is selected, empty cells are not counted, but zero values are. To locate the Show a zero in cells that have a zero value check box:
ExampleCopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Need more help?Which of the following functions adds all the values and divide the result by the number of values?SUM: This function adds all the values of the cells in the argument. AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
Which of the following functions would you use to determine the number of values in a specified range?Use the COUNT function in a formula to count the number of numeric values in a range. In the above example, A2, A3, and A6 are the only cells that contains numeric values in the range, hence the output is 3.
Which of the following functions gives the same result as totaling a range of values and dividing the result by the number of values in the range?Explanation: The =AVERAGE() function calculates the sum of the values involved and divides them with the count of the values.
What is the used of sum average max and min function?The Average function calculates the average, or arithmetic mean, of its arguments. The Max function finds the maximum value. The Min function finds the minimum value. The Sum function calculates the sum of its arguments.
|