WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Average Formula

Average Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate Average

Average is the value that is used to represent the set of values of data as is the average calculated from whole data and this formula is calculated by adding all the values of the set given, denoted by summation of X and dividing it by the number of values given in set denoted by N.

Average = (a1 + a2 + …. + an) / n

AVERAGE-FORMULA

  • where ai = ith observation
  • n = Number of observations

Explanation

The calculation of average can be calculated by using the following steps:

  • Step 1: Firstly, determine the observation, and they are denoted by a1, a2, ….., an corresponding to 1st observation, 2nd observation,…., nth observation.
  • Step 2: Next, determine the number of observations, and it is denoted by n.
  • Step 3: Finally, the average is calculated by adding all the observations and then divide the result by the number of observations, as shown below.

Average = (a1 + a2 + …. + an) / n

Examples

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

Example #1

Let us take an example of John, who enrolled in the graduation program for environmental science. The three-year degree course is divided into six semesters, and the final average percentage is calculated based on the percentages scored in all the semesters. Calculate John’s final percentage based on his following score:

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Below is given data for calculation of the average percentage.

Average Formula Example 1

Given,

a1 = 79%, a2 = 81%, a3 = 74%, a4 = 70%, a5 = 82%, a6 = 85%, n = 6

Using the above information, the calculation of average will be as follows,

Average Formula Example 1.1

  •   Average = (79% + 81% + 74% + 70% +82% + 85%) / 6

Average will be –

Average Formula Example 1.2

  • Average = 78.50%

Therefore, David scored a final percentage of 78.5% in the graduation program.

Uses

As the name “average” suggests, it refers to the central point among a set of observations. When it is utilized in mathematics, it represents the number which is typically mean of a group of numbers. The term is often used to express a number, which represents a group of people or things. It is very important because it helps in summarising a large number of data into a single value, and it also indicates that there is some inconsistency around the single value within the original data, which forms a very crucial part of the central tendency theory.

Recommended Articles

This has been a guide to Average Formula. Here we discuss how to calculate the average using its formula and examples and a downloadable excel template. You can learn more about financing from the following articles –

  • Moving Average Formula
  • Measures of Central Tendency
  • Average vs Weighted Average
  • AVERAGE Function in Excel
  • Effect Size
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ 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 Average Formula Excel Template

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