• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Financial Modeling

          • What is Financial Modeling
          • Financial Modeling Excel
          • Financial Model Types
        • Excel Modeling

          • Financial Functions Excel
          • Sensitivity Analysis in Excel
          • Time Value of Money
        • Excel-Modeling
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment-Banking-Guides
        • Excel

          • Excel Functions
          • Excel Charts
          • Excel Tips
        • Excel
        • Others

          • Resources (A to Z)
          • Accounting
          • Financial Statement Analysis
          • Equity Research
          • Private Equity
          • Corporate Finance
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Financial Modeling Course

          Financial-Modeling-Course
        • Investment Banking Course

          Investment-Banking-Training
        • Others

          • M&A Modeling Course
          • LBO Modeling Course
          • Valuation Modeling Course


          • PE Modeling Course
          • VC Modeling Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Arithmetic Mean Formula

Home » Financial Modeling » Excel Modeling » Arithmetic Mean Formula

By Pooja Borkar Leave a Comment

Arithmetic Mean Formula

Formula of Arithmetic Mean (Table of Contents)

  • Formula
  • Examples

What is the Arithmetic Mean Formula?

The arithmetic mean is a measure of central tendency which is calculated by dividing the sum of the observations divided by the number of observations. The arithmetic mean is also known as mean or average. The Arithmetic Mean formula is represented as below :

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

Where,

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

Alternatively, the Arithmetic Mean Formula can be symbolically written as shown below-

Arithmetic Mean Formula 2

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

Explanation of Arithmetic Mean Formula

In order to calculate the arithmetic mean, use the following steps:

Step 1: Calculate the sum of all the observations. This is calculated by the formula:

x1 + x2 + x3 +…….+ xn

Step 2: Determine the number of observations. The number of observations is denoted by n.

Popular Course in this category
Financial Modeling Course (with 15+ Projects) 16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (927 ratings)
Course Price

View Course

Related Courses
M&A Modeling CourseLBO Modeling CourseValuation Modeling Course

Step 3: Calculate the arithmetic mean using the formula:

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

Alternatively, Arithmetic Mean Formula in symbolic terms is represented as below,

Arithmetic Mean Formula 2

Examples of Arithmetic Mean Formula

Let’s understand some simple to advanced examples of the Arithmetic Mean Equation in a better manner.

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

Arithmetic Mean  – Example #1

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

Solution

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

Arithmetic Mean Formula 1

Therefore,  calculation of arithmetic mean is as follows,

Arithmetic Mean Formula 1.1

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

Arithmetic Mean will be – 

Arithmetic Mean Formula Example 1.2

  • =50
  • The arithmetic mean is 50.

Arithmetic Mean – Example #2

Franklin Inc. is a manufacturing concern with 10 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 do the calculation of the arithmetic mean of wages of workers in the company. The following table gives the wages along with the names of the workers.

Arithmetic Mean Formula Example 2

Calculate the arithmetic mean of wages for the CEO.

Solution

Therefore, the calculation of arithmetic mean is as follows,

calculation of arithmetic mean 2.1

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

Arithmetic Mean will be – 

calculation of arithmetic mean 2.2

  • =108

The arithmetic mean of wages is $108.

Arithmetic Mean – 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 be considered to have had a better teacher. These are the marks of 7 students each studying in the two Divisions.

Arithmetic Mean Formula Example 3

Find out which Division has higher arithmetic mean.

Solution

Division A

Therefore, the calculation of arithmetic mean is as follows,

calculation of arithmetic mean 3.1

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

Arithmetic Mean will be – 

calculation 3.2

  • =58.71 marks

Division B

Therefore, the calculation of arithmetic mean is as follows,

calculation 3.3

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

Arithmetic Mean will be – 

3.4

  • = 65 marks

The arithmetic mean of Division A is 58.71 marks, while the arithmetic mean of Division B is 65 marks. The arithmetic mean of Division B is higher.

Arithmetic Mean Formula 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.

Example 4

Solution

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

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

 4.1

Step #2 – Press Enter to Get the Answer

Example 4.2

Relevance and Uses

The arithmetic mean is one of the most important measures in statistics. The arithmetic mean is the most commonly used as the most popular measure of central tendency. Arithmetic Mean Formula is very simple to calculate. It does not require knowledge of high-end statistics. It is much easier to calculate as compared to say geometric mean or harmonic mean. In the majority of the cases, it does not require the use of a computer as it is easy to calculate. Arithmetic Mean Formula takes all the observations into consideration which implies that no observation is left out. This is where arithmetic means scores over median and mode. The results obtained from large groupings of numbers are also reliable when we use the arithmetic mean. Mean can be subject to further algebraic treatment.

When different samples are taken from the same population, arithmetic mean is known to have less fluctuation. The arithmetic mean is used when all observations in the data set are equally important. If some observations 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 along with practical examples and 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 >>

Filed Under: Excel Modeling, Financial Modeling

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. 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

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

Download Colgate's Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

WallStreetMojo

Download Arithmetic Mean Formula Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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