Chapter 7. USING STATISTICAL FUNCTIONS AND TOOLS
Calculate an Average
An average is the sum of two or more values divided by the total number of values. You can use the AVERAGE function to calculate an average. The AVERAGE function takes one type of argument: Number1 through Number255. An array is a list of values enclosed in curly braces. For example {20, 25, 25, 30} is an array. In each Number argument, you can enter a number, a range that contains numbers, a range name, or an array. The AVERAGE function sums each value you enter and divides by the total number of values. If a cell contains a zero, Excel includes the value in the calculation. If a cell is blank, Excel does not include the cell in the calculation.
Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
