Calculate the arithmetic mean of a given set of arguments Show
How to Calculate AVERAGE in Excel?The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel. This guide will show you, step-by-step, how to calculate the average in Excel. As a financial analyst, the function is useful in finding out the average (mean) of a series of numbers. For example, we can find out the average sales for the last 12 months for a business. Formula=AVERAGE(number1, [number2], …)The function uses the following arguments:
How to use AVERAGE Function in Excel?To understand the uses of the AVERAGE function, let us consider a few examples: Example 1 – Average in ExcelSuppose we are given the following data: We wish to find out the top 3 scores in the above data set. The formula to use will be: We get the result below: In the above formula, the LARGE function retrieved the top nth values from a set of values. So, we got the top 3 values as we used the array constant {1,2,3} into LARGE for the second argument. Later, the AVERAGE function returned the average of the values. As the function can automatically handle array results, we don’t need not use Ctrl+Shift+Enter to enter the formula. Example 2 – Average in ExcelSuppose we are given the data below: The formula to use is shown below: We get the following result: A few notes about the AVERAGE Function
Click here to download the sample Excel file Additional ResourcesThanks for reading CFI’s guide to the Excel AVERAGE function. By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Article Sources
Which value is calculated when the Formula average?Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
Which value is created when the Formula average G2?In the formula =AVERAGE(G2:G11) range of cells is given which means starting cell is G2 and the ending cell is G11 of that range. In Excel, columns are named as A, B, C, D, E, F, and so on. In Excel, rows are named as 1, 2, 3, 4, 5, 6, and so on. Cells in an Excel sheet are made with intersections of rows and columns.
How do you enter an average formula in Excel?Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.
Which ribbon commands achieve the same result in Excel?Hence LEN commands achieve the same result.
|