How to Calculate Weighted Average

Using a calculator
••• utah778/iStock/GettyImages

You are perhaps familiar with the concept of an average, and recognize that the purpose of this statistic is to convey a sense of "normal" or "expected."

If you know, for example, that the average height of a newly discovered creature from a distant planet is 100 cm (about 3 feet, 4 inches), you would probably not be surprised to see any individual figures in the range of 80 to 120 cm. But you might be suspicious of numbers like 20 cm or 500 cm despite knowing nothing else about this creature.

When calculating a mathematical average, every data point is usually considered to have equal weight. That is, even data points that clearly represent rare findings and are thus statistical outliers for some reason (such as a person who can run a mile in under four minutes or can speak 20 languages fluently).

In some situations, however, it is desirable to treat certain kinds of data as being more or less important in order to generate an accurate picture of what is happening; this is where the weighted average comes in.

What Is an Average?

A basic average, or mean, is just the sum of all the observations in a sample divided by the number of observations in the sample. If someone has five children, and their weights are 20, 35, 80, 100 and 145 pounds, their average weight is (20 +35 + 80 +100 + 145)/5 = 280/5 = 56 pounds.

Notice that in this simple calculation, all of the data points are treated as having the same importance in the calculation of average. This is evident from the fact that none of the points is manipulated in any way (e.g., multiplied or divided by another number) before the division step occurs. If this sounds weird, keep reading.

Why Use Averages?

Averages, usually simple averages with no weighting, paint a statistical picture of what people have good reason to expect. If you take a quiz and are told that the average score among the 25 students in the class is 40 percent, and your score is 45, you know that in spite of getting fewer than half of the questions right, you did a little better than a "typical" student.

Averages offer solid information for planning and other civic purposes. If the average level of air pollution in a given city is higher than the national average, then the leaders of that city should perhaps consider environmental measures a top priority.

Weighted Average Formula

There is no fixed formula to determine a weighted average because the weights assigned to each variable can change from situation to situation. In general, the equation would be of the form:

(Ax1 + Bx2 + Cx3... + Zxn)/n

Where the capital letters are coefficients corresponding to the weighing factors and n is the total number of data points in the set.

Example: A quiz includes 10 questions: five about science and five about history. The science questions are given twice the "weight" of the history questions.

If students get an average of four science and three history questions correct, what is the simple class average?

  • The answer in this case is just (4 + 3)/10 = 7/10 = 7.

What is the weighted class average?

  • The answer this time is [(2)(4) + (1)(3)/10] = (8 + 1)/10 = 11.

What would the weighted average be if the average scores on each part of the test were reversed, with the average science score being 3 and the average history score being 4?

  • This would change the above equation to [(2)(3) + (1)(4)/10] = (8 + 1)/10 = 10.

You can see from this example that the teacher intends to reward science knowledge more that history knowledge with this quiz.

Weighted Average Calculator

See the Resources for an example of a site that allows you to input any number of weighting coefficients and data points to find weighted averages.

Related Articles

How to Average Two Percentages
How to Calculate Variance
How to Calculate Conditional Probabilities
Definition of Mean, Median & Mode
How to Calculate Running Average
How to Calculate a Grade Point Average for 5.0
How to Compute a Population Mean
How Do People Use Mode, Mean & Average Everyday?
How to Calculate Mean Deviation
How to Find a Z Score
How to Calculate a Cumulative Numerical Average
What Is the Difference Between Nominal & Ordinal Data?
The Disadvantages of Linear Regression
How Do I Calculate the 85th Percentile Speed?
How to Find an Average
How to Calculate the Expected Mean in Statistics
How to Calculate an Average MPH
How to Calculate Significant Figures
Weighted Averages in Survey Analysis
How to Calculate Your YTD GPA