Add a row for each value and its weight to get the weighted average instantly — the mean that lets some values count more than others. Built-in modes for class grades, GPA, and any values-and-weights problem, with every step shown.
Any numbers. Weights can be counts, percentages, dollars — they need not add to 100.
Σ(value × weight) ÷ Σweight = 830 ÷ 10
The plain mean (80) ignores weights; the weighted average leans toward the heaviest-weighted items.
A weighted average is a mean where each value carries a weight reflecting how much it matters. You multiply every value by its weight, add up the products, then divide by the total of the weights. The heavier a value's weight, the more it pulls the answer toward itself.
Four steps, whatever the values represent.
Pair every value x with its weight w and multiply. These products are the weighted contributions.
Sum those weighted contributions to get the numerator of the formula.
Sum the weights to get the denominator. This is what normalizes the result.
Divide the sum of products by the sum of weights. The result is the weighted average.
The same procedure handles a report-card grade, a semester GPA, and an investment portfolio — only the meaning of the weights changes.
Three categories that weight to 100%.
Whenever the things you are averaging are not equally important, you weight them.
The plain arithmetic mean is just a weighted average where every weight is equal. Seeing them side by side shows exactly what the weights are doing.
For a GPA, convert each letter grade to its point value, then take the weighted average using credit hours as the weights. This is the standard US scale.
A handful of facts that keep a weighted average honest — and the slips that trip people up.
Enter your current grade and how much the final exam is worth, then read off the final grade for each possible exam score — a weighted average of your existing grade and the final.

The mean is the average of a set of numbers: add them all up and divide by how many there are. This guide shows the formula, a worked example, and how the mean differs from the median and mode.

Use STDEV.S or STDEV.P in Excel, choose the right one for your data, and check the result against a worked example.

A friendly, beginner-focused guide to understanding and calculating range in statistics. Learn what range means, how to compute it, real-life applications, and common mistakes to avoid.