98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Weighted Average formula for Statistics
Weighted Average formula for Statistics
Resolved · High Priority · Version 2010
Laura has attended:
Excel Intermediate course
Weighted Average formula for Statistics
How can I plot a weighted average for percentages against number of people who did the survey.
RE: Weighted Average formula for Statistics
Hello Laura,
Thank you for your question. To calculate weighted average, Excel uses a combination of SUMPRODUCT and SUM. The structure of the formula is as follows:
=SUMPRODUCT(Range_1, Range_2)/SUM(Range_1)
This formula assumes that Range_1 is the column which contains the numbers of people and Range_2 is the column which contains the percentages (scores).
The formula multiplies the number of people with the score for each row in the range and then totals all these results. Then it divides this result by the total number of people, to give the weighted average.
Rows with more people will carry more weight.
I hope this helps.
Kind regards
Marius Barnard
Excel Trainer
Wed 13 Jun 2018: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert Text to Columns in Excel 2010If you have a cell in your Excel spreadsheet that contains a lot of text and you want to divide it into separate columns, this can only be done if there is a logical character which separates the text, for example, a comma. |