Question

Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7,751 as in cell D10?

Answer 1

Hey please give us the screenshot.

So we can help you.

Answer 2

Answer:

=SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)

Explanation:

Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7,751 as in cell D10?

MULTIPLE CHOICES

A)=D8/C8

B)=SUMPRODUCT(C3:C7,D3:D7)/C8

C)=(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8

D)=SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)