Compute Weighted Grades in Excel 2016
Edited by Djinu, Alexander Avdeev, Eng
You're watching VisiHow. In this video, we'll show how to calculate weighted grade-point averages for a group of students.
- 7So, we add "$" in front of the letter and the number to make them "$C$1" and "$G$1" in this video. Whenever we fill down, the formula will always refer to the "Weight" row. In this video, "SUMPRODUCT" will basically multiply 75 by 0.1, 35 by 0.1, etc., and then add the product of those numbers. In this case, it will be 7.5+3.5+3.5+etc.For the weighted averages, we want to make sure that these are absolute references.
- 8We'll use "SUM", add a parenthesis, and select the top section, adding in the dollar sign in front of the letters and the numbers to make sure that these are absolute references. We close the formula and press "Enter". In this video, the final grade for Billy Bob will be 58.Once we get all of these numbers added up, we want to divide those by the total number of the weights.
- 9We do it by left-clicking at the bottom of the cell and simply dragging it down to get the final grades for both Suzy Q and Mike Holmes.We can fill the "Grade" column down.Advertisement
This has been a tutorial on how to calculate weighted averages using Microsoft Excel. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!
Video: Compute Weighted Grades in Excel 2016
Referencing this Article
If you need to reference this article in your work, you can copy-paste the following depending on your required format:
APA (American Psychological Association)
Compute Weighted Grades in Excel 2016. (2016). In VisiHow. Retrieved Mar 29, 2017, from http://visihow.com/Compute_Weighted_Grades_in_Excel_2016
MLA (Modern Language Association) "Compute Weighted Grades in Excel 2016." VisiHow, visihow.com/Compute_Weighted_Grades_in_Excel_2016 Accessed 29 Mar 2017.
Chicago / Turabian VisiHow.com. "Compute Weighted Grades in Excel 2016." Accessed Mar 29, 2017. http://visihow.com/Compute_Weighted_Grades_in_Excel_2016.
Categories : Microsoft Suites
Recent edits by: Alexander Avdeev, Djinu