Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7,751 as in cell D10?
=(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8
=SUMPRODUCT(C3:C7,D3:D7)/C8
=D8/C8
=SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)
Attachments:
Answers
Answered by
4
D8/C8 will not produce the correct weighted average
Step-by-step explanation:
D8/C8 will not produce the correct weighted average
C8 = SUM(C3:C7)
(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7) = SUMPRODUCT(C3:C7,D3:D7)
Hence
(C3*D3+C4*D4+C5*D5+C6*D6+C7*D7)/C8 = SUMPRODUCT(C3:C7,D3:D7)/C8 = SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)
C8 = SUM(D3:D7)
hence D8 ≠ SUMPRODUCT(C3:C7,D3:D7)
Hence D8/C8 will not produce the correct weighted average
D8/C8 = 33572 ≠ 7751
Learn more:
Excel would evaluate the formula, = 20*10/5*8 and return this ...
https://brainly.in/question/14112243
a) (1)Give answer using Excel formula/function on the following ...
https://brainly.in/question/13949918
Answered by
0
Answer: SUMPRODUCT(C3:C7,D3:D7)/SUM(C3:C7)
Explanation:
Similar questions