AVERAGE

Hi Friends,

Till now I had discussed about the Logical, Textual & Mathematical and more functions in Microsoft Excel. But as you aware that data analysis is practically based upon statistical calculations (factual data to predict or monitor the future behavioral pattern of an organization), may it be a very common or complex calculations.

Therefore, friends, in my next few articles, I will discuss about few Statistical functions available in Excel which are commonly used in daily data analysis.

Later, I will discuss about more complex statistical functions. Let’s start from the very basic statistical concepts.

Mean, Median, Mode, Variance, Standard Deviation etc., are the common statistical methods which we normally use in Data Analysis.

Today we will discuss about the AVERAGE function which is also known as arithmetic mean. AVERAGE of few number is sum of the numbers divided by the count of the numbers. I hope we all know this basic methodology to calculate AVERAGE.

Now let see how we can derive AVERAGE of few numbers in Excel, using Excel’s built in function.

The function name is very easy to remember and very easy and simple to implement.

Syntax

The syntax for the AVERAGE function in Microsoft Excel is

=AVERAGE( number1, [number2], ... [number_n] )

Parameters or Arguments

number1, number2, ... number_n

Numeric values which can be numbers, named ranges, arrays, or references to numbers. 

I will discuss about this function (AVERAGE) and other functions (Mathematical) to show you how to use ARRAY in these functions in upcoming articles.

Returns

The AVERAGE function returns a numeric value.

Example :

How to use AVERAGE function in Excel

In the above image you can notice that I entered the formula as =AVERAGE(D3:D6).  I did by typing =AVERAGE ( and then I selected the cell range for which I need to get the average i.e., D3 to D6.

Alternatively you can type =AVERAGE( and the press the Control button of your computer and click on the cells you need to get the average as shown in the below image.

How to use AVERAGE function in Excel

Hope this article is enough for you to understand the AVERAGE function. If any question arises, feel free to comment in the comment box below.

Thanks for reading…