Although Excel doesn't have a weighted average function, it does have a function that does most of the work for you: SUMPRODUCT. Even if you've never used SUMPRODUCT before, you'll be able to use it like a pro by the end of this article. The method we're using works with all versions of Excel, and it also works with other spreadsheet applications like Google Sheets.
1 Crore+ students have signed up on EduRev. Have you? Download the App |
That's it! When you press Enter on your keyboard, Excel will calculate the weighted average. In our example, the final grade is 83.6.
Download the notes
Use SUMPRODUCT to Calculate Weighted Averages
|
Download as PDF |
The second part of the formula is actually really useful because it allows the formula to automatically correct its calculations. Remember that the weights don't need to add up to 100%? This is because this part of the formula takes care of that for us. For example, if we increase one or more of the weights, the second part of the formula simply divides by a higher number, bringing it back down to the correct answer. We could even make the weights much smaller, giving them values like 0.5, 2.5, 3.0, and 4.5, and the formula would still work perfectly.
94 videos|62 docs|15 tests
|
|
Explore Courses for Class 6 exam
|