Question

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)

886b95d238ff9451c58388ae8e1dddf0.txt

Answer 1

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

Answer 2

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

Explanation: