• Skip to secondary menu
  • Skip to main content
  • Skip to primary sidebar
  • My Store
  • Glossary
  • Home
  • About Me
  • Contact Me

Statistics By Jim

Making statistics intuitive

  • Graphs
  • Basics
  • Hypothesis Testing
  • Regression
  • ANOVA
  • Probability
  • Time Series
  • Fun

Weighted Average: Formula & Calculation Examples

By Jim Frost Leave a Comment

What is a Weighted Average?

A weighted average is a type of mean that gives differing importance to the values in a dataset. In contrast, the regular average, or arithmetic mean, gives equal weight to all observations. The weighted average is also known as the weighted mean, and I’ll use those terms interchangeably.

Photo of weights represent a weighted average.Use a weighted mean when you must consider the relative significance of values in a dataset. In other words, you’re placing different weights on the values in the calculations.

For example, use a weighted average in the following situations:

  • A professor weights projects, exams, and quizzes to reflect varying difficulty.
  • An investor weights the share price by the number of stocks they purchase to reflect the changing prices.

In these examples, a weighted average gives differing importance to each value according to relevant criteria.

In this post, learn how to calculate a weighted average and go through two worked examples.

Weighted Average Formula

Calculating the mean is a simple process of summing all your values and dividing them by the number of values. That process gives each value an equal weight.

Now let’s see how that procedure contrasts with the weighted average calculation.

The weighted average formula is the following:

Weighted average formula.

Where:

  • w = the weight for each data point.
  • x = the value of each data point.

Calculating the weighted average involves multiplying each data point by its weight and summing those products. Then sum the weights for all data points. Finally, divide the weight*value products by the sum of the weights. Voila, you’ve calculated the weighted mean!

Two broad calculation cases exist when using the weighted average formula:

  • The weights sum to 1.
  • They don’t sum to 1.

Notice how you divide the products by the sum of the weights in the denominator. Consequently, when the weights sum to one, the weighted average simply equals the sum of the products in the numerator. However, you’ll need to perform the division when the denominator does not equal one.

Let’s use the weighted mean formula to work through two examples.

Example Weighted Average Calculations

We’ll start with an example where the weights sum to one. This situation frequently occurs when someone intentionally builds the weighted average into a process. For example, a teacher might devise a grading system using weights and, for simplicity, has the weights sum to one.

The teacher has given weights ranging from 0.05 for quizzes to 0.4 for the group project. Because the teacher devised the weights to equal one, it’s easy to understand the importance of each observation. For instance, the group project accounts for 40% of the grade!

Let’s calculate the weighted mean for one student’s grade! In the column headers, I use notation that matches the weighted average formula above.

Example calculations for a weighted average.

The student did well on the quizzes and exams but not so well on the group project. The resulting weighted average is 79.70.

The regular mean is 84.5, but the considerable importance of the group project brought their weighted average grade down to 79.7. Ouch!

Example Weighted Mean Calculations

Next, let’s work through an example where the weights don’t sum to one.

An investor is building up a particular stock in his portfolio. He purchases the same stock at different prices over time. He can calculate the weighted mean for the average share price. In this example, the prices are the values, and the numbers of stocks are the weights.

Example calculations for a weighted mean.

Here, the weights sum to 125. Consequently, we need to divide the sum of the products (2,985) by 125. The weighted average price per stock is $23.88.

Share this:

  • Tweet

Related

Filed Under: Basics

Reader Interactions

Comments and Questions Cancel reply

Primary Sidebar

Meet Jim

I’ll help you intuitively understand statistics by focusing on concepts and using plain English so you can concentrate on understanding your results.

Read More...

Buy My Introduction to Statistics Book!

Cover of my Introduction to Statistics: An Intuitive Guide ebook.

Buy My Hypothesis Testing Book!

Cover image of my Hypothesis Testing: An Intuitive Guide ebook.

Buy My Regression Book!

Cover for my ebook, Regression Analysis: An Intuitive Guide for Using and Interpreting Linear Models.

Subscribe by Email

Enter your email address to receive notifications of new posts by email.

    I won't send you spam. Unsubscribe at any time.

    Follow Me

    • FacebookFacebook
    • RSS FeedRSS Feed
    • TwitterTwitter

    Top Posts

    • How to Interpret P-values and Coefficients in Regression Analysis
    • How To Interpret R-squared in Regression Analysis
    • Mean, Median, and Mode: Measures of Central Tendency
    • Multicollinearity in Regression Analysis: Problems, Detection, and Solutions
    • How to Interpret the F-test of Overall Significance in Regression Analysis
    • Choosing the Correct Type of Regression Analysis
    • How to Find the P value: Process and Calculations
    • Interpreting Correlation Coefficients
    • How to do t-Tests in Excel
    • Z-table

    Recent Posts

    • Fishers Exact Test: Using & Interpreting
    • Percent Change: Formula and Calculation Steps
    • X and Y Axis in Graphs
    • Simpsons Paradox Explained
    • Covariates: Definition & Uses
    • Weighted Average: Formula & Calculation Examples

    Recent Comments

    • Dave on Control Variables: Definition, Uses & Examples
    • Jim Frost on How High Does R-squared Need to Be?
    • Mark Solomons on How High Does R-squared Need to Be?
    • John Grenci on Normal Distribution in Statistics
    • Jim Frost on Normal Distribution in Statistics

    Copyright © 2023 · Jim Frost · Privacy Policy