Lets see how to calculate a weighted average in excel. And in the end you will get the weighted average by dividing values from both of the function. 93-100 A 90-92 A-87-89 B 83-86 B 80-82 B-77-79 C 70-76 C 67-69 C-64-66 D 62-63 D.
SUMPRODUCTC3C11D3D11SUMD3D11 Press Enter after typing the formula to view the weighted average.
A higher weight will cause the assignment or test to have a greater effect on the final grade. For the weighted average heres the complete manual equation. And in the end you will get the weighted average by dividing values from both of the function. A higher weight will cause the assignment or test to have a greater effect on the final grade.