Formula to Calculate Population Variance

Population variance is a measure of the spread of population data. Hence, population variance is the average of the distances from each data point in a particular population to the mean squared. It indicates how data points spread out in the population. Population variance is an important measure of dispersion used in statisticsIn StatisticsStatistics is the science behind identifying, collecting, organizing and summarizing, analyzing, interpreting, and finally, presenting such data, either qualitative or quantitative, which helps make better and effective decisions with relevance.read more. Statisticians calculate variance to determine how individual numbers in a data set relate to each other.

While calculating population variance, one may calculate the dispersion concerning the population means. Hence, we must find out the population meanFind Out The Population MeanThe population mean is the mean or average of all values in the given population and is calculated by the sum of all values in population denoted by the summation of X divided by the number of values in population which is denoted by N.read more to calculate population variance. One of the most popular notifications of the population variance is σ2. It is pronounced as sigma squared.

One can calculate population variance by using the following formula:

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Population Variance Formula (wallstreetmojo.com)

where

  • σ2 is population variance,x1, x2, x3,…..xn are the observationsN is the number of observations,µ is the mean of the data set

Step by Step Calculation of Population Variance

Examples

Example #1

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

  • Step 1: Calculate the mean (µ) of the given data. To calculate the mean, add add all the observations and then divide that by the number of observations (N). Make a table. Please note that constructing a table is not compulsory, but presenting it in a tabular format would make the calculations easier. For example, in the first column, write each observation (x1, x2, x3,…..xn). In the second column, write the deviation of each observation from the mean (xi – µ). In the third column, write the square of each observation from the mean (xi – µ)2. In other words, square each of the numbers obtained in column 2. Subsequently, we need to add the numbers obtained in the third column. Finally, find the sum of the squared deviations and divide the sum obtained by the number of observations (N). It will help us to obtain  which is the population variance.

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 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.

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

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

σ2 = 214/6

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. The weights of 7 containers are: 105, 100, 102, 95, 100, 98, and 107. Please advise the Quality Control Department on whether it should reject the containers.

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

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

σ2 = 100/7

Population Variance (σ2 )= 14.29

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

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, and 60 cm. Calculate the variance of the heights of these 8 babies.

In Excel, there is an inbuilt formula for population variance that one can use 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 ) = 13.98

Relevance and Use

One may use the population variance 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 each other. A small variance indicates that the numbers are close to each other.

Variance is used in portfolio management while carrying out asset allocationAsset AllocationAsset Allocation is the process of investing your money in various asset classes such as debt, equity, mutual funds, and real estate, depending on your return expectations and risk tolerance. This makes it easier to achieve your long-term financial goals.read more. Investors calculate the variance of asset returns to determine optimal portfoliosOptimal PortfoliosPortfolio optimization refers to the strategic process of making improvements or positive changes to the investor’s portfolio containing various assets. The Sharpe ratio helps to analyze the returns from an optimal portfolio.read more by optimizing the two major parameters – return and volatility. Volatility, measured by variance, measures a particular financial security risk.

This article has been a guide to Population Variance Formula. Here, we discuss calculating population variance using its formula, practical examples, and a downloadable Excel template. You can learn more about Excel modeling from the following articles: –

  • Formula of CovarianceFormula Of CovarianceCovariance is a statistical measure used to find the relationship between two assets and is calculated as the standard deviation of the return of the two assets multiplied by its correlation. If it gives a positive number then the assets are said to have positive covariance i.e. when the returns of one asset goes up, the return of second assets also goes up and vice versa for negative covariance.read moreFormula of Portfolio VarianceFormula Of Portfolio VariancePortfolio variance is a statistical value of modern investment theory that measures the dispersion of average returns of a portfolio from its mean. In short, it determines the total risk of the portfolio. Portfolio variance = w12 * ơ12+w22 * ơ22+2 * ρ1,2 * w1 * w2 * ơ1 * ơ2read moreCorrelation vs CovarianceCorrelation Vs CovarianceCovariance and Correlation are two terms which are exactly opposite to each other; both are used for statistics and regression analysis. Covariance reflects how two variables vary from each other, whereas correlation depicts the relationship between two variables.read moreVariance vs Standard DeviationVariance Vs Standard DeviationVariance is a numeric value that defines every observation’s variability from the arithmetic mean, while Standard Deviation is a measure to determine how spread out the observations are from the arithmetic mean. read more