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

A. =SUMPRODUCT(C2:C5,B2:B5)
B. =SUMPRODUCT(C2:C4,B2:B4)
C. =AVERAGE(B2:34)
D. =AVERAGE(C2:C4)​

The Correct Option is B.  =SUMPRODUCT(C2:C4,B2:B4)

 Explanation: 

This question is asking which formula, among a list of options, correctly calculates the weighted average score in cell C8.

The weighted average is different from the simple average because of the weight or importance of each score. To find the weighted average in Excel, multiply each score by its weight, add these results, and divide by the sum of the weights.

In general, the formula is structured like this:

=SUMPRODUCT(scores, weights)/SUM(weights)

Here's what each part means:

SUMPRODUCT (scores, weights): Multiply each point by its corresponding weight and add the results.

Total (weight): Fold all weights.

The weighted average guarantees that a larger estimated value (high scale) has a major impact on average. In this context, the correct formula would calculate the weighted average score for the range of cells and place the result in C8. The user should choose the formula from the provided options that best represents how this calculation should be done.

Read More - What values would be returned based on the formula in cell a49?