Descriptive Statistics GPA & Grades Finance & Investing 22 min read May 31, 2026
BY: Statistics Fundamentals Team
Reviewed By: Minsa A (Senior Statistics Editor)

Weighted Mean: Formula, Step-by-Step Examples & Interactive Calculator

Your final exam counts for 60% of your grade. Your homework is worth 30%. Participation is the remaining 10%. Adding those three scores and dividing by three gives you the wrong answer — because three inputs that carry different stakes cannot be treated as equals. The fix is a weighted mean: multiply each value by how much it matters, sum the results, and divide by the total weight. Everything on this page flows from that single idea.

This guide covers the formula in full, three worked examples (final course grade, GPA, stock cost basis), the most common calculation error to avoid, and an interactive calculator you can use right now.

What You'll Learn
  • ✓ The weighted mean formula x̄_w = Σ(w·x) / Σw — with every symbol defined
  • ✓ How a weighted mean differs from a regular arithmetic mean, side by side
  • ✓ Three full worked examples: course grade, semester GPA, and stock average cost
  • ✓ Why weights do not have to sum to 1 or 100% — the "100% myth" debunked
  • ✓ The single most common weighted mean error and how to spot it
  • ✓ An interactive weighted mean calculator with step-by-step output
  • ✓ The connection between the weighted mean and expected value in probability

What Is a Weighted Mean? (Definition)

Featured Snippet Definition — Weighted Mean
A weighted mean (or weighted average) is a type of average in which each value in a dataset is assigned an importance factor called a weight. The weighted mean is calculated by multiplying each value by its weight, summing those products, and dividing by the total sum of all weights. Values with larger weights pull the result closer to themselves; values with smaller weights have proportionally less influence.
x̄_w = Σ(w_i · x_i) / Σw_i

Here is the everyday intuition: think about a grocery cart with ten apples at $0.50 each and one steak at $12.00. The average price of an item in that cart is not $6.25 — the midpoint between $0.50 and $12.00. It is much closer to $0.50, because apples make up 91% of the items. The arithmetic mean ignores this volume difference. The weighted mean accounts for it by weighting each price by how many units you have at that price.

That same logic applies whenever some data points represent more volume, more importance, or more reliability than others. Grades weighted by syllabus percentages, stock prices weighted by share quantities, course grades weighted by credit hours — all are weighted means.

⚡ Weighted Mean — Key Facts at a Glance
  • Formula: x̄_w = Σ(w · x) / Σw — multiply each value by its weight, sum the products, divide by total weight
  • When all weights are equal: the weighted mean equals the ordinary arithmetic mean
  • Weights do not need to sum to 1 or 100%: the denominator normalizes any scale automatically
  • Most common error: dividing by the count of items (n) instead of the sum of weights (Σw)
  • Academic use: final course grades (syllabus percentages as weights), GPA (credit hours as weights)
  • Finance use: average purchase price of a stock (share quantities as weights), VWAP
  • Probability link: when weights are probabilities summing to 1, the weighted mean equals the expected value E(X)

The Weighted Mean Formula — Every Symbol Defined

The general formula for the weighted mean uses standard summation notation. Each data value x is paired with its corresponding weight w, and those pairs are processed together:

Weighted Mean Formula
x̄_w = Σ(w_i · x_i) / Σw_i
In plain terms: multiply each number by its corresponding weight, add all those results together, and then divide that grand total by the sum of all your weights.
x̄_w = weighted mean (the result)
x_i = each individual data value
w_i = weight assigned to x_i
Σ(w_i · x_i) = numerator: sum of all (weight × value) products
Σw_i = denominator: sum of all weights

The subscript i simply means "for each item." If your dataset has 3 items, i runs from 1 to 3, giving you three pairs: (w₁, x₁), (w₂, x₂), and (w₃, x₃). The formula multiplies each pair, adds the three products, and divides by w₁ + w₂ + w₃.

The Four-Step Calculation Process

Step 1

List Every Value–Weight Pair

x₁, w₁ | x₂, w₂ | ...

Write each data value next to its assigned weight. This pairing step prevents the most common entry errors before any arithmetic begins.

Step 2

Compute Each Product w · x

w₁·x₁, w₂·x₂, ...

Multiply each value by its weight individually. Keep these products in a column — they become the numerator once summed.

Step 3

Sum the Products (Numerator)

Σ(w_i · x_i)

Add every product from Step 2 together. This total is the numerator of the formula.

Step 4

Divide by Σw (Denominator)

÷ Σw_i

Divide the Step 3 sum by the total of all weights — NOT by the number of items. This single step is where most errors occur.

🚫
Critical Error to Avoid: Dividing by n Instead of Σw

The arithmetic mean divides by the number of data points (n). The weighted mean divides by the sum of the weights (Σw). These are the same number only when all weights are equal. In every other situation, dividing by n produces the wrong answer. Always divide by Σw.

Weighted Mean vs. Arithmetic Mean — Side-by-Side Matrix

The arithmetic mean is a special case of the weighted mean where every weight is identical. The table below uses the same three scores (72, 85, 94) to show how the two methods produce different results the moment weights are unequal.

Dimension Arithmetic Mean Weighted Mean
Core Assumption Every value contributes equally Values contribute in proportion to their assigned weight
Formula x̄ = Σx / n x̄_w = Σ(w·x) / Σw
Denominator Number of data points (n) Sum of all weights (Σw)
Best Used For Data where each observation is equally important or occurs once Data where items differ in importance, volume, or reliability
Example: Scores 72, 85, 94 with equal weights (72+85+94)/3 = 83.67 (1·72+1·85+1·94)/(1+1+1) = 83.67 ← identical
Example: Weights 10%, 30%, 60% Still 83.67 (ignores weights) (.10·72+.30·85+.60·94)/(1.0) = 7.2+25.5+56.4 = 89.1 ← different
Effect of Skewed Weights None — weights are invisible to the formula Higher-weighted values pull the result toward themselves
Sensitive to Outliers Yes, equally sensitive to all values Outliers matter only if they also carry large weights

The two methods diverge by 5.4 points in that example — a difference that can shift a B+ to an A− in a grading system. Understanding which denominator to use is the entire difference between the two formulas.

Three Worked Examples

Example 1: Final Course Grade (Academic)

A course syllabus specifies: exams are worth 60% of the final grade, homework is worth 30%, and participation is worth 10%. At the end of term, a student's component scores are: Exam = 78, Homework = 92, Participation = 85. Calculate the final course grade.

Academic Example — Final Grade

Course Grade Calculation (Exam 60%, Homework 30%, Participation 10%)

Component Score (x) Weight (w) w × x
Exam780.6046.80
Homework920.3027.60
Participation850.108.50
Totals (Σ)1.0082.90
1

List the pairs: (78, 0.60), (92, 0.30), (85, 0.10)

2

Multiply each value by its weight: 78 × 0.60 = 46.80 | 92 × 0.30 = 27.60 | 85 × 0.10 = 8.50

3

Sum the products (numerator): 46.80 + 27.60 + 8.50 = 82.90

4

Divide by Σw: 82.90 ÷ 1.00 = 82.90

✓ Final Grade = 82.90 — a solid B.

💡
Notice the contrast with the arithmetic mean

A plain average of the three scores gives (78 + 92 + 85) / 3 = 85.0 — over two points higher. The arithmetic mean pretends the 10%-weighted participation score matters as much as the 60%-weighted exam, which is not what the syllabus says.

Example 2: Average Stock Purchase Price (Finance)

An investor buys shares of the same stock in three separate transactions at different prices. To track total cost and tax basis, they need the weighted average purchase price — where the weight is the number of shares bought, not the number of transactions.

Finance Example — Dollar-Cost Averaging / Cost Basis

Average Cost Per Share

Transaction Price per Share (x) Shares Bought (w) w × x (Total Spent)
January$42.0050$2,100.00
April$38.50100$3,850.00
September$45.0025$1,125.00
Totals (Σ)175 shares$7,075.00
1

Pair each price with the shares purchased at that price: ($42, 50), ($38.50, 100), ($45, 25)

2

Total cost per transaction: 50 × $42 = $2,100 | 100 × $38.50 = $3,850 | 25 × $45 = $1,125

3

Total spent: $2,100 + $3,850 + $1,125 = $7,075

4

Divide by total shares: $7,075 ÷ 175 = $40.43 per share

✓ Weighted Average Cost = $40.43 per share (rounded to the nearest cent).

⚠️
Why not use a plain average of the three prices?

The simple mean of $42, $38.50, and $45 is $41.83 — nearly $1.40 higher than the correct answer. That error compounds when calculating capital gains tax on hundreds or thousands of shares. The April purchase bought twice as many shares as January and four times as many as September, so that lower price should count more — and the weighted mean guarantees it does.

The volume-weighted average price (VWAP) is the professional equivalent of this calculation, used by institutional traders to benchmark execution quality. For a detailed treatment, see the SEC's Regulation NMS documentation.

Example 3: Semester GPA (Credit Hours as Weights)

At most universities in the United States, the GPA calculation is a weighted mean where credit hours serve as the weights. A 4-credit course has more influence on GPA than a 2-credit seminar — because you spent more instructional time, and presumably more effort, in the heavier course. This mirrors the standard GPA methodology used by registrar offices at institutions ranging from MIT to community colleges.

Academic Example — GPA Calculation

Semester GPA Calculation Using Credit Hours as Weights

Course Grade Grade Points (x) Credit Hours (w) w × x
Biology LabA4.0416.0
Calculus IIB+3.339.9
English CompositionA−3.7311.1
Intro SeminarB3.026.0
Totals (Σ)12 cr. hrs.43.0
1

Convert each letter grade to grade points using the standard 4.0 scale. Pair each grade-point value with the course's credit hours.

2

Multiply grade points × credit hours for each course: 4.0×4=16.0 | 3.3×3=9.9 | 3.7×3=11.1 | 3.0×2=6.0

3

Sum the products: 16.0 + 9.9 + 11.1 + 6.0 = 43.0 (quality points)

4

Divide by total credit hours: 43.0 ÷ 12 = 3.583, rounded to 3.58 GPA

✓ Semester GPA = 3.58 — between an A− and a B+ overall. The Biology Lab (4 credits, grade A) carries the most weight and pulls the average upward.

This calculation follows the standard GPA methodology documented by the College Board and used by university registrar offices. For institution-specific grade-point scales, always confirm with your registrar's guidelines.

Interactive Weighted Mean Calculator

Weighted Mean Calculator

Enter your values and weights below. Add as many rows as needed. Click Calculate to see the step-by-step result.

Value (x) Weight (w)

Enter each assignment/exam score and its syllabus weight (as a percentage, e.g. 60 for 60%).

Score (0–100) Weight (%)

Enter each course's grade points (A=4.0, A−=3.7, B+=3.3, B=3.0, B−=2.7, C=2.0) and credit hours.

Grade Points Credit Hours

Visual Intuition: The Weighted Seesaw

A physical seesaw is the clearest picture of what a weighted mean does. If you place identical objects at equal distances from the center, the balance point sits exactly in the middle — that is the arithmetic mean. Now swap one small weight for a much heavier one. The beam tips. The new balance point shifts toward the heavy side. That shifted balance point is the weighted mean.

The balance point of a weighted beam corresponds exactly to the weighted mean of the values placed on it. Values with larger weights (heavier objects) pull the balance point toward their position on the number line.

This seesaw model has a precise mathematical name: the weighted mean is the center of mass of a system where data points are physical positions and weights are masses. This connection between statistics and classical mechanics is why the weighted mean is sometimes called the "center of gravity" of a dataset in physics-based applications.

The 100% Myth: Weights Do Not Have to Sum to 1 or 100%

⚡ Common Misconception — Debunked

"Your weights must add up to 100% (or 1.0) for the formula to work."

This is false. The weighted mean formula divides by whatever the weights sum to. That division step normalizes any scale automatically. You can use percentages, decimals, credit hours, share quantities, star ratings, or any non-negative numbers as weights — the formula handles them all correctly.

Proof with arbitrary weights: Use values x = {80, 90} with weights w = {3, 7} (sum = 10, not 1).

x̄_w = (3×80 + 7×90) / (3+7) = (240 + 630) / 10 = 870/10 = 87.0

Now use normalized weights w = {0.3, 0.7} (sum = 1):

x̄_w = (0.3×80 + 0.7×90) / (0.3+0.7) = (24 + 63) / 1.0 = 87.0

The result is identical. The denominator (3+7 = 10 or 0.3+0.7 = 1) normalizes whichever scale you chose. GPA uses credit hours (typically 1–5, sum varies by semester). Dollar-cost averaging uses share quantities (arbitrary integers). Both are valid weighted means.

The only rule is that weights must be non-negative, and at least one weight must be greater than zero (otherwise the denominator is zero, which is undefined). Negative weights are not used in the standard weighted mean, though they appear in more advanced constructions such as statistical contrast matrices.

Frequently Asked Questions

What is the difference between a weighted mean and a weighted median?
The weighted mean uses multiplication and division across all values. The weighted median finds the central value such that the cumulative weight on each side equals 0.5 — it is found by ordering data and accumulating weights, not by arithmetic. The weighted median is more resistant to outliers than the weighted mean, just as the ordinary median is more resistant than the ordinary arithmetic mean.
Can I calculate the weighted mean in Microsoft Excel?
Yes. Use the SUMPRODUCT function combined with SUM: =SUMPRODUCT(values_range, weights_range) / SUM(weights_range). For example, if scores are in B2:B5 and weights are in C2:C5, enter =SUMPRODUCT(B2:B5,C2:C5)/SUM(C2:C5). SUMPRODUCT calculates Σ(w·x) and SUM(weights_range) gives Σw. There is no built-in WEIGHTEDAVERAGE function in Excel — this SUMPRODUCT formula is the standard approach.
What happens if one weight is much larger than the others?
The weighted mean shifts strongly toward the value with the large weight. For example, if one item has a weight of 90 and two others have weights of 5 each, the item with weight 90 controls roughly 90% of the result. This is by design — the weighted mean is supposed to reflect differential importance. If you find this result uncomfortable, check whether the large weight is actually justified by the real-world importance of that item.
Is the weighted mean always between the minimum and maximum values?
Yes, as long as all weights are non-negative and at least one is positive. The weighted mean is a convex combination of the data values, which means it always falls within the range [min(x), max(x)]. It cannot be lower than the smallest value or higher than the largest value in the dataset. This is a useful sanity check: if your calculated weighted mean falls outside the data range, there is an arithmetic error.
What is VWAP and how does it use the weighted mean?
VWAP stands for Volume-Weighted Average Price. It is the weighted mean of all transaction prices during a trading day, where each price is weighted by the volume (number of shares) traded at that price. VWAP = Σ(Price × Volume) / Σ(Volume). Professional traders use it as a benchmark: buying below VWAP suggests a favorable execution price relative to the day's trading activity. It is calculated using the same four-step process as any weighted mean.
How does the weighted mean relate to expected value in probability?
The expected value E(X) of a discrete random variable is defined as E(X) = Σ(x_i · p_i), where p_i is the probability of each outcome. When the weights in a weighted mean are probabilities that sum to 1, the formulas are identical: E(X) = x̄_w. The weighted mean is therefore the more general concept; the expected value is a special case where the weights are normalized probabilities. This connection is explored in depth on our Expected Value page.
My syllabus weights add up to 105% because of extra credit. How do I calculate my grade?
Use the weighted mean formula exactly as written: divide by Σw, whatever that total happens to be. If your weights sum to 1.05, divide by 1.05. The result is automatically normalized. In practice, however, extra credit is often added differently — as raw bonus points added after the weighted mean is computed — so check your syllabus. If the weights themselves sum to 105%, the formula handles it correctly.
What is a weighted mean in survey research?
Survey researchers assign weights to respondents to correct for sampling imbalances. For example, if the sample over-represents one demographic group, respondents from underrepresented groups receive larger weights so the aggregate results reflect the actual population proportions. The weighted mean of their responses then gives a more accurate population estimate than a simple average of all responses. This technique is standard in political polling, public health surveys, and academic research.

Formula & Concept Glossary

The following table defines every symbol and concept used in weighted mean calculations. Bookmark this as your reference sheet.

Term / Symbol Notation Definition Example
Weighted Mean x̄_w The result of the weighted mean formula. A single number summarizing a dataset where values carry different importance factors. Final course grade of 82.9 computed from exam, homework, and participation scores
Data Value x_i Each individual observation or score in the dataset. The subscript i identifies which specific item it is. An exam score of 78, a homework score of 92
Weight / Importance Factor w_i A non-negative number expressing the relative importance, frequency, or volume of the corresponding data value x_i. Larger weight = more influence on the result. Exam weight of 0.60 (60%), credit hours = 4
Summation Operator Σ The Greek letter sigma meaning "add up all instances of what follows." Σ(w_i · x_i) means: compute w·x for each pair, then add all results together. Σ(w·x) = 46.8 + 27.6 + 8.5 = 82.9
Numerator Σ(w_i · x_i) The sum of all weight-times-value products. Also called "quality points" in GPA calculations and "total expenditure" in finance applications. Quality points: 4×4.0 + 3×3.3 + 3×3.7 + 2×3.0 = 43.0
Denominator Σw_i The sum of all weights. This is what you divide by — NOT the number of items (n). The denominator normalizes the result to the correct scale. Total credit hours: 4+3+3+2 = 12
Credit Hours In GPA calculations, the number of academic credits assigned to each course. They serve as the weights in the weighted mean GPA formula. A 4-credit science lab, a 2-credit seminar
Normalized Weights w_i / Σw Weights that have been divided by their sum so they total exactly 1.0. Using normalized weights is optional — the formula produces the same result either way. Weights (50, 100, 25) normalize to (0.286, 0.571, 0.143)
Arithmetic Mean x̄ = Σx / n The ordinary average, where every value is treated with equal weight. Equivalent to the weighted mean when all weights are equal. (72+85+94)/3 = 83.67
Expected Value E(X) = Σ(p_i · x_i) The weighted mean when weights are probabilities that sum to 1. The long-run average outcome of a random variable over many repetitions. E(die roll) = (1+2+3+4+5+6)/6 = 3.5

Downloadable Resources

The reference materials below are designed for use at the end of a semester or grading period. Each can be completed without statistical software.

Weighted Average Calculator Worksheet (PDF)

A one-page printable worksheet with blank value/weight tables, the formula, and worked example space. Designed for final exam week when you need to check your grade quickly by hand.

📥 Printable — No software required

Grade & GPA Tracker — Excel Template

A pre-built spreadsheet using SUMPRODUCT/SUM formulas. Enter your scores and syllabus weights; the template calculates your running weighted average automatically. Includes a separate GPA sheet for full-semester tracking.

📥 Excel — Works with Google Sheets

One-Page Formula Reference Card

A condensed card with the formula, the four steps, the Excel function, common weight examples (percentages, credit hours, shares), and the critical error to avoid — sized to fit a standard index card or phone wallpaper.

📥 PDF — Print or save to phone
📋
Image Placement Note

The resource download buttons and file links can be added above once the files are uploaded to your server. Replace the resource cards with actual <a href="..."> download links pointing to your /downloads/ directory.

The Three Most Common Weighted Mean Errors

Error #1 — Most Common

Dividing by n Instead of Σw

x̄ = Σ(w·x) / n ← WRONG

Dividing by the count of items (n=3) instead of the sum of weights (Σw=1.0) gives a completely different number. This error is hardwired from practicing arithmetic means. Pause before every division: am I dividing by the number of rows, or by the total weight?

Error #2

Using the Wrong Weight Scale

e.g. entering "60" not "0.60"

Mixing percentage format (60) with decimal format (0.30) within the same calculation. All weights must be on the same scale. If percentages sum to 100, divide by 100 in the denominator. Or convert everything to decimals first (60% → 0.60).

Error #3

Mis-Pairing Values and Weights

x₁ paired with w₂ ← WRONG

Assigning the exam weight to the homework score, or the credit hours of one course to the grade of another. Always check that every value-weight pair corresponds to the same single item before multiplying. A simple two-column table prevents this error entirely.

The weighted mean sits inside the broader family of measures of central tendency. Understanding it opens a direct path to several neighboring concepts:

Internal Resource

Arithmetic Mean →

The starting point: add all values, divide by n. The weighted mean generalizes this formula by replacing equal weights with custom importance factors.

Internal Resource

Median →

The middle value of an ordered dataset. Unlike the weighted mean, the median is not distorted by extreme values. Compare both when your data contains outliers.

Internal Resource

Expected Value →

The probability-weighted mean. When your weights are probabilities that sum to 1, the weighted mean formula gives you E(X) exactly. This is the foundation of decision theory and risk analysis.

Internal Resource

Standard Deviation →

Measures how spread out values are around the mean. The weighted analog is the weighted standard deviation, used when observations carry different frequencies or reliabilities.

External Authority

Laerd Statistics: Measures of Central Tendency →

An accessible, peer-reviewed treatment of mean, median, and mode with notes on when to use each. A widely-cited reference for undergraduates and instructors.

External Authority — .edu

MIT OpenCourseWare: Statistics for Applications →

MIT's freely available lecture notes and problem sets covering weighted sums, expected value, and estimation — the graduate-level context in which the weighted mean appears as a foundational tool.

External Authority

Khan Academy: Calculating Averages →

Video walkthroughs of arithmetic and weighted averages with interactive practice problems. Recommended for visual learners who want additional drills on the calculation steps.

🎓
Academic Citation Note

The weighted mean is formally defined as a special case of the inner product of two vectors in Euclidean space. For a rigorous treatment, see Hogg, McKean & Craig, Introduction to Mathematical Statistics, 8th ed. (Pearson, 2019), §1.6, or the treatment of sufficient statistics in Casella & Berger, Statistical Inference, 2nd ed. (Cengage, 2002), §1.3.

Summary: The Weighted Mean in One Paragraph

AI Overview / Summary Paragraph
A weighted mean is an average that assigns a different level of importance — called a weight — to each value in a dataset. The formula is x̄_w = Σ(w_i · x_i) / Σw_i: multiply each value by its weight, sum those products, and divide by the sum of the weights. Because the denominator equals the total of all weights rather than the count of items, the weighted mean automatically adjusts for situations where some data points represent more volume, more time, or more importance than others. Common uses include calculating a final course grade from syllabus-weighted components, computing a semester GPA using credit hours as weights, and finding an investor's average purchase price for a stock held across multiple transactions at different prices. The most frequent calculation error is dividing by the number of items (n) instead of the sum of the weights (Σw). When all weights are equal, the weighted mean equals the ordinary arithmetic mean. When weights are probabilities that sum to 1, the weighted mean is identical to the expected value E(X) in probability theory.