How to use the average function in excel

July 26, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

The Excel Statistical functions section includes the AVERAGE Function. In Excel, it will return the mean value of the supplied set of numbers.

In Excel, the function is used to determine the arithmetic mean of a set of inputs. This tutorial will walk you through each step of computing the average in Excel.

The function is helpful to a financial analyst in determining the average (mean) of a set of statistics. For instance, we can discover the average revenue for a company over the previous 12 months.


=AVERAGE(number1, [number2], …)

The following arguments are used by the function:

The initial number of the cell reference or range for which the average is desired is Number1 (mandatory argument).Number2 (optional argument) - These are the extra figures, cell references, or a range that we wish to calculate the average for. There is a limit of 255 numbers.

How to use average function in excel online, 2016 and 2019:

Let's look at a few instances to better grasp the AVERAGE function's applications:

Example 1, Average in excel:

Let's say we have the following information:

The top 3 scores in the aforementioned data set are what we're looking for. The calculation to be used is:

The outcome is as follows:

The LARGE function in the formula above selected the top n values from a collection of values. As a result, when we entered the array constants 1, 2, 3 into LARGE for the second parameter, we obtained the top 3 values.The average of the numbers was afterwards returned by the AVERAGE function. Since the function can handle array results automatically, we may enter the formula without using Ctrl+Shift+Enter.How to use average function in excel using example 2:Assume we are given the information below:

The following is the appropriate formula:

The following outcome is obtained:

A few notes about the Average function in excel:Empty cells are disregarded by the AVERAGE function.Any text, logical values, or empty cells in a range or cell reference argument are ignored. Cells with a value of 0 are nevertheless included.The function makes mistakes when given arguments that are erroneous values or text that cannot be converted to numbers.Note: This above written article is an attempt to show you how to use average function in excel online, 2016 and 2019. This above stated method of how to use average in excel can be used in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go with your work. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.