WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Arithmetic Mean

Arithmetic Mean

What is Arithmetic Mean?

Arithmetic Mean, commonly used term in statistics, is the average of the numerical values set and is calculated by firstly calculating the sum of number in the set and then dividing resultant by count of those numbers.

Arithmetic Mean Formula

The formula is represented as below :

Arithmetic Mean = x1 + x2 + x3 +……+ xn / n

Arithmetic Mean Formula

Where,

  • x1, x2, x3, xn are the observations
  • n is the number of observations

Alternatively, it can be symbolically written as shown below-

Arithmetic Mean Formula 2

In the above Equation, the symbol  ∑ is known as sigma. It implies the summation of the values.

Steps to Calculate Arithmetic Mean

  • Step 1: Calculate the sum of all the observations.
    • x1 + x2 + x3 +…….+ xn
  • Step 2: Determine the number of observations. The number of observations is denoted by n.
  • Step 3: Calculate the arithmetic mean using:
    • Arithmetic Mean = x1+x2+x3+…………….+xn/n
    • Alternatively, Arithmetic Mean Formula in symbolic terms is represented as below,

Arithmetic Mean Formula 2

Examples

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

Example #1

There are five observations. These are 56, 44, 20, 50, 80. Find their arithmetic mean.

Solution

  • Here, the observations are 56, 44, 20, 50, 80.
  • n = 5

Therefore, the calculation is as follows,

Arithmetic Mean example 1.1

  • =56+44+20+50+80/5

Arithmetic Mean Example 1.2

Example #2

Franklin Inc. is a manufacturing concern with ten workers. There are negotiations between the management of Franklin Inc. and its trade union regarding wages. For this purpose, the CEO of Franklin Inc. wants to calculate the arithmetic mean of salary of workers in the company. The following table gives the wages along with the names of the workers.

Name of the Worker Wages ($)
Jeffery Gates 100
George Clinton 120
Thomas Smith 250
Kamala Sanders 90
Steve Roosevelt 110
Martha Smith 40
Clara Truman 50
Nicholas Obama 150
Michael Carlin 70
Arnold Smith 100
Number of Observations (n) 10

Calculate the arithmetic mean of wages for the CEO.

Solution

Therefore, the calculation is as follows,

Example 2.1

  • =(100+120+250+90+110+40+50+150+70+100+10)/10

Example 2.2

Example #3

The Principal of a school calls two teachers to his office – one teaches Division A, and the other teaches Division B. Both of them claim that their teaching methods are superior. The Principal decides that the Division, which has a higher arithmetic mean of marks, will have had a better teacher. These are the marks of 7 students each studying in the two Divisions.

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course
Sr. No Division A Division B
Student 1 56 70
Student 2 60 65
Student 3 56 60
Student 4 64 65
Student 5 70 75
Student 6 55 55
Student 7 50 65

Find out which Division has higher arithmetic mean.

Solution

Division A

Therefore, the calculation is as follows,

Example 3.1

  • =(56+60+56+64+70+55+50)/7

Example 3.2

  • =58.71 marks

Division B

Therefore, the calculation is as follows,

Example 3.3

  • =(70+65+60+65+75+55+65)/7

Example 3.4

  • = 65 marks

The arithmetic mean of Division A is 58.71 marks, and for Division B is 65 marks (higher)

Arithmetic Mean in Excel

There is company Grandsoft Inc. which is listed on the stock exchanges. Different analysts have given their target price of the stock. Calculate the arithmetic mean of the stock prices.

Analyst  Target Price
A 1000
B 1200
C 900
D 900
E 1500
F 750
G 750

Solution

In Excel, there is an in-built formula to calculate the mean.

Step #1 – Select a blank cell and type =AVERAGE(B2: B8)

Arithmetic = average formula

Step #2 – Press Enter to Get the Answer

Arithmetic Example 4.2

Relevance and Uses

The arithmetic mean is one of the most important statistics and is most commonly used as the most popular measure of central tendency. It is straightforward to calculate and does not require knowledge of high-end statistics. It is used when all observations in the data set are equally important. If some statements are more important than others, then a weighted mean is used.

Recommended Articles

This has been a guide to Arithmetic Mean Formula. Here we discuss the calculation of arithmetic mean using its formula along with practical examples and a downloadable excel template. You can learn more about excel modeling from the following articles –

  • Exponents in Excel
  • Formula of Compounding
  • Formula of Moving Average
  • Weighted Average Excel
0 Shares
Share
Tweet
Share
Financial Modeling Course (with 15+ Projects)
  • 16 Courses
  • 15+ Projects
  • 90+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Arithmetic Mean Formula Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More