3 Now we can calculate the weighted average by dividing the SSUMPRODUCT with the SUM of the weightage assigned. Each exam has a weight of 20 so all three exams have a total weight of 60 hence you multiply by 60. Weighted averages are essential in statistical analysis finance and classrooms to name a few.
3 Now we can calculate the weighted average by dividing the SSUMPRODUCT with the SUM of the weightage assigned.
Weighted averages are essential in statistical analysis finance and classrooms to name a few. Take the raw points you scored in Exam 1 Exam 2 Exam 3 Pre assessment extra credit quiz scores extra credit bonus questions X 60 90 Please note the following. The following formula is used to calculate the weighted average date costing method. It is also applicable to short-term samples such as a 15-minute TWA.