Question

Which of the following is the correct formula to calculate the weighted average score
in cell C8 as shown below?
=SUMPRODUCT(C2:C5,B2:35)
=SUMPRODUCT(C2:C4,B2:34)
=AVERAGE(B2:34)
=AVERAGE(C2:C4)​

Answer 1

Answer:

Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?

Answer 2

=SUMPRODUCT(C2:C4,B2:B4)

The correct formula to calculate the weighted average score is =SUMPRODUCT(C2:C4,B2:B4)

• Weighted Average is a arithmetic calculation of average value in which one or more than one value of number is given a greater significance or weight.

Weighted average Score can be calculated by two methods:-

1. By using SUMPRODUCT function
2. By using SUM function

• The SUMPRODUCT function performs the calculation as:-
• Ex:- (20*1)+(40*2)+(90*3)

So, The Correct Answer is "=SUMPRODUCT(C2:C4,B2:B4)"