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

**Formula for Population Variance (Table of Contents)**

## What is Population Variance Formula?

Population variance is a measure of the spread of population data. Hence, population variance can be defined as the average of the distances from each data point in a particular population to the mean, squared and it indicates how data points are spread out in the population. Population variance is an important measure of dispersion used in statistics. Statisticians calculate variance to determine how individual numbers in a data set relate to each other.

While calculating population variance, the dispersion is calculated with reference to the population mean. Hence, we have to find out the population mean in order to calculate population variance. One of the post popular notifications of the population variance is σ^{2}. This is pronounced as sigma squared.

Population variance can be calculated by using the following formula:

where

- σ
^{2 }is population variance, - x
_{1, }x_{2}, x_{3,}…..x_{n }are the observations - N is the number of observations,
- µ is the mean of the data set

### Explanation of the Population Variance Formula

The formula for population variance can be calculated by using the following five simple steps:

**Step 1: **Calculate the mean (µ) of the given data. In order to calculate the mean, add all the observations and then divide that by the number of observations (N).

**Step 2: **Make a table. Please note that constructing a table is not compulsory, but presenting it in a tabular format would make the calculations easier. In the first column, write each observation (x_{1, }x_{2}, x_{3,}…..x_{n}).

**Step 3:** In the second column, write the deviation of each observation from the mean (x_{i }– µ).

**Step 4: **In the third column, write the square of each observation from the mean (x_{i }– µ)^{2}. In other words, square each of the numbers obtained in column 2.

**Step 5:** Subsequently we need to add the numbers obtained in the third column. Find the sum of the squared deviations and divide the sum so obtained by the number of observations (N). This will help us to obtain which is the population variance.

### Examples of Population Variance Formula (with Excel Template)

Let’s see some simple to advanced examples of population variance equation to understand it better.

4.9 (927 ratings)

#### Example #1

__ __**Calculate the population variance from the following 5 observations: 50, 55, 45, 60, 40.**

**Solution:**

Use the following data for the calculation of population variance.

There are a total of 5 observations. Hence, N=5.

µ=(50+55+45+60+40)/5 =250/5 =50

So, the Calculation of population variance σ^{2 }can be done as follows-

σ^{2 }= 250/5

Population Variance σ^{2} will be-

**Population Variance (σ ^{2} ) = 50**

The population variance is 50.

#### Example #2

**XYZ Ltd. is a small firm and consists of only 6 employees. The CEO believes that there should not be high dispersion in the salaries of these employees. For this purpose, he wants you to calculate the variance of these salaries. The salaries of these employees are as under. Calculate the population variance of the salaries for the CEO.**

**Solution:**

Use the following data for the calculation of population variance.

There are a total of 6 observations. Hence, N=6.

=(30+27+20+40+32+31)/6 =180/6 =$ 30

So, the Calculation of population variance σ^{2 }can be done as follows-

σ^{2 }= 214/6

Population Variance σ^{2} will be-

**Population Variance (σ ^{2} ) = 35.67**

The population variance of the salaries is 35.67.

#### Example #3

**Sweet Juice Ltd manufactures different flavors of juice. The Management Department purchases 7 big containers for storing this juice in the factory. The Quality Control Department has decided that it will reject the containers if the variance of the containers is above 10. Given are the weights of 7 containers in kg: 105, 100, 102, 95, 100, 98 and 107. Please advise the Quality Control Department on whether it should reject the containers.**

**Solution:**

Use the following data for the calculation of population variance.

There are a total of 7 observations. Hence, N=7

=(105+100+102+95+100+98+107)/7 =707/7 =101

So, the Calculation of population variance σ^{2 }can be done as follows-

σ^{2 }= 100/7

Population Variance σ^{2} will be-

**Population Variance (σ ^{2} )= 14.29**

Since the variance (14.29) is more than the limit of 10 decided by the Quality Control Department, the containers should be rejected.

#### Example #4

**The management team of a hospital named Sagar Healthcare recorded that 8 babies had been born in the first week of March 2019. The doctor wanted to evaluate the health of the babies as well as the variance of the heights. The heights of these babies are as follows: 48 cm, 47 cm, 50 cm, 53 cm, 50 cm, 52 cm, 51 cm, 60 cm. Calculate the variance of the heights of these 8 babies.**

**Solution:**

Use the following data for the calculation of population variance.

So, the Calculation of population variance σ^{2 }can be done as follows-

In Excel, there is an inbuilt formula for population variance that can be used to calculate the population variance of a group of numbers. Select a blank cell and type this formula =VAR.P(B2:B9). Here, B2:B9 is the range of cells you want to calculate the population variance from.

Population Variance σ^{2} will be-

**Population Variance (σ ^{2} ) **=

**13.98**

### Relevance and Use

Population variance is used as a measure of dispersion. Let us consider two population sets with the same mean and number of observations. Data set 1 consists of 5 numbers – 55, 50, 45, 50 and 50. Data set 2 consists of 10, 50, 85, 90 and 15. Both the data sets have the same mean, which is 50. But, in data set 1, the values are close to each other while data set 2 has dispersed values. The variance gives a scientific measure of this closeness/dispersion. Data set 1 has a variance of only 10 while data set 2 has a huge variance of 1130. Thus, a large variance indicates that the numbers are far from the mean and from each other. A small variance indicates that the numbers are close to each other.

Variance is used in the field of portfolio management while carrying out asset allocation. Investors calculate the variance of asset returns to determine optimal portfolios by optimizing the two major parameters – return and volatility. Volatility measured by variance is a measure of the risk of a particular financial security.

### Recommended Articles

This has been a guide to Population Variance Formula. Here we discuss how to calculate population variance in excel with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –

- Adjusted R Squared | Interpretation
- Examples of Correlation Formula (with Excel Template)
- R Squared Formula in Excel
- Formula of Covariance
- Formula of Portfolio Variance
- Correlation vs Covariance – Compare
- Variance vs Standard Deviation – Compare

- 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

## Leave a Reply