Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Average Formula – Table of Contents**

## What is the Average Formula?

The term “average” refers to the mathematical mean calculated for a set of observations. The formula for average is calculated by adding all the observations and then divide the result by the number of observations.

Mathematically, Average Formula is represented as,

**Average = (a**

_{1}+ a_{2}+ …. + a_{n}) / nwhere a_{i} = i^{th} observation

n = Number of observations

Further, the weighted average formula is calculated by initially multiplying each observation by its corresponding weighting, then adding up all the weighted observation and then divide the result by the sum of the weightings.

Mathematically, it is represented as,

**Weighted Average Formula = (w**

_{1}* a_{1}+ w_{2}* a_{2 }+ …… + w_{n}* a_{n}) / (w_{1}+ w_{2}+….. + w_{n})where w_{i} = weight of the i^{th} observation

a_{i} = i^{th} observation

It can be said that the simple average is a case where all weights of each observation are equal to one, i.e. w_{1} = w_{2} = …. = w_{n} = 1.

### Explanation of the Average and Weighted Average Formula

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

**Step 1:** Firstly, determine the observation and they are denoted by a_{1}, a_{2}, ….., a_{n} corresponding to 1^{st} observation, 2^{nd} observation,…., n^{th} observation.

**Step 2:** Next, determine the number of observations and it is denoted by n.

**Step 3:** Finally, the formula for average is calculated by adding all the observations and then divide the result by the number of observations as shown below.

**Average = (a _{1} + a_{2} + …. + a_{n}) / n**

The formula for weighted average formula can be calculated by using the following steps:

4.9 (927 ratings)

**Step 1:** Firstly, determine the observation and they are denoted by a_{1}, a_{2}, ….., a_{n} corresponding to 1^{st} observation, 2^{nd} observation,…., n^{th} observation.

**Step 2:** Next, determine the weightings corresponding to each observation and they are denoted by w_{1}, w_{2}, ….., w_{n}.

**Step 3:** Next, multiply each observation by its corresponding weighting and then add up all the weighted observations.

**Step 4:** Finally, the formula for weighted average is calculated by dividing the sum of all the weighted observations by the sum of all the weights as shown below.

**Weighted Average Formula = (w _{1} * a_{1} + w_{2} * a_{2 }+ …… + w_{n} * a_{n}) / (w_{1} + w_{2} +….. + w_{n})**

**Examples of Average Formula (with Excel Template)**

Let’s see some simple to advanced examples of Average formula to understand it better.

### Example #1

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

Below is given data for calculation of the average percentage.

**Given,**

a_{1} = 79%, a_{2} = 81%, a_{3} = 74%, a_{4} = 70%, a_{5} = 82%, a_{6} = 85%, n = 6

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

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

**Average will be –**

- Average =
**78.50%**

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

### Example #2

**Let us assume that the university changed its scoring policy recently wherein it has shifted from a simple average scoring to weighted average scoring. As per the new policy, 1 ^{st} and 2^{nd} semester will be weighed at 5% each, 3^{rd} and 4^{th} semester at 15% each, and 5^{th} and **6

^{th}semester at 30% each. Based on the new scoring system, calculate the final average for John during his graduate program.Below is given data for calculation of the weighted average in excel.

**Given, **

- w
_{1}= 5%, w_{2}= 5%, w_{3}= 15%, w_{4}= 15%, w_{5}= 30%, w_{6}= 30%, - a
_{1}= 79%, a_{2}= 81%, a_{3}= 74%, a_{4}= 70%, a_{5}= 82%, a_{6}= 85%, n = 6

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

- Weighted Average Formula = (5% * 79% + 5% * 81% + 15% * 74% + 15% * 70% + 30% * 82% + 30% * 85%) / (5% + 5% + 15% + 15% + 30% + 30%)

**Average will be –**

- Average =
**79.70%**

Therefore, John’s average graduation percentage comes to be 79.7% as per the new scoring policy.

### Relevance and Uses of Average Formula

As the name “average” suggests, it refers to the central point among a set of observations and when it is utilized in the field of mathematics it represents the number which is typically mean of a group of numbers. The term is used often to express a number which is the representation for a group of people or things. The formula for average 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 central tendency theory.

### Recommended Articles

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

- What is Central Tendency?
- Average vs Weighted Average – Compare and contrast
- Calculate Moving Average in Excel
- Calculate Mode in Excel
- AVERAGE Function in Excel

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced