Mean Formula

Mean Formula (Table of Contents)

• Mean Formula
• Examples of Mean Formula (With Excel Template)
• Mean Formula Calculator

Mean Formula

Mean is a point in a data set which is the average of all the data point we have in a set. It is basically arithmetic average of the data set and can be calculated by taking a sum of all the data points and then dividing it by the number of data points we have in data set. In statistics, mean is the most common method to measure the center of a data set. It’s a very basic yet important part of the statistical analysis of data. If we calculate the average value of the population set, then it is called the population mean. But sometimes what happens is that population data is very huge and we cannot perform analysis on that data set. So in that case, we take a sample out of it and take an average. That sample basically represents the population set and mean is called a sample mean. Mean value is the average value which will fall between the maximum and minimum value in data set but it will not be the number in the data set.

A formula for Mean is given by:

There is another way of calculating mean which is not very commonly used. It is called Assumed mean method. In that method, a random value is selected from the data set and assumed to be mean. Then the deviation of the data points from this value is calculated. So mean is given by:

Examples of Mean Formula (With Excel Template)

Let’s take an example to understand the calculation of Mean formula in a better manner.

Mean Formula – Example #1

Let say you have a data set with 10 data points and we want to calculate mean for that. 

Data set : {4,6,8,9,22,83,98,45,87,10}

Solution:

Mean is calculated using the formula given below

Mean = Sum of All Data Points / Number of Data Points

• Mean = (4+6+8+9+22+83+98+45+87+10) / 10
• Mean = 372 / 10
• Mean = 37.2

Let’s use Assumed Mean method to find mean in the same example.

Let’s assume that the mean for the given data set is 40. So Deviations will be calculated as:

For 1st data point, 4 – 40 = -36

The result will be as given below.

Similarly, We have to calculate deviation for all the data points.

Mean is calculated using the formula given below

Mean = Assumed Mean + (Sum of All Deviations / Number of Data Points)

• Mean = 40 + (-36 -34-32-31-18+43+58+5+47-30) / 10
• Mean = 40 + (-28) / 10
• Mean = 40 + (-2.8)
• Mean = 37.2

Mean Formula – Example #2

Let us take IBM stock and we will take its historical prices from the last 10 months and will calculate the annual return for 10 months.

Source Link: https://in.finance.yahoo.com/quote/IBM/history period1=1521008937&period2=1552544937&interval=1mo&filter=history&frequency=1mo

Solution:

Mean is calculated using the formula given below

Mean = Sum of All Data Points / Number of Data Points

• Mean = (3.74% + 1.07% +4.34% + (-23.66)% + 7.66% + (-7.36)% + 18.25% + 2.76% + 1.48% + 0.00%) / 10
• Mean = 8.28% / 10
• Mean = 0.83%

So if you see here, in the last 10 months, IBM return has fluctuated very much.

Overall, in the last 10 months, the average return is only 0.83%

You can download this Mean Template here – Mean Formula Excel Template

Explanation

Mean is basically a simple average of the data points we have in a data set and it helps us to understand the average point of the data set. But there are certain limitations of using mean. Mean value is easily distorted by extreme values/outliers. These extreme values can be a very small or very large value which can distort the mean. For example: Let say we have returns of stock for the last 5 years given by 5%, 2%, 1%, 5%, -30%. Mean for these values is -3.4% ((5+2+1+5-30)/5). So although the stock has provided a positive return for the first 4 years, on an average we have a negative mean of 3.4%. Similarly, if we have a project for which we are analyzing the cash flow for the next 5 years. Let say the cash flows are: -100, -100, -100, -100, +1000.

Mean is 600 / 5 = 120. Although we have a positive mean, we are only getting money in last year of the project and it can happen that if we incorporate time value of money, this project will not look as lucrative as it is now.

Relevance and Uses of Mean Formula

Mean is very simple yet one of the crucial elements of statistics. It is the basic foundation of statistical analysis of data. It is very easy to calculate and easy to understand also. If we have data set with data points which are scattered all over the place, mean helps us to see what is the average of that data point. For example : If a stock X has returns from last 5 years as 20%, -10%, 3%, -7%, 30%. If you see all the years have different returns. Mean for this is 7.2% ((20-10+3-7+30)/5). So we can now simply say that on an average, the stock has given us the yearly return of 7.2%.

But if we see mean in a silo, it has relatively less significance because of the flaws discussed above and it is more of a theoretical number. So we should use mean value very carefully and should not analyze the data only based on the mean.

Mean Formula Calculator

You can use the following Mean Calculator

Recommended Articles

This has been a guide to Mean Formula. Here we discuss how to calculate Mean along with practical examples. We also provide Mean calculator with downloadable excel template. You may also look at the following articles to learn more –

1. Calculation of Price Elasticity
2. Guide to Solvency Ratio Formula
3. Examples of Portfolio Variance Formula
4. DPMO Formula