o) Ety) ly) 0.2 0.3 0.4 o.1 Weighted Squared Dif Weighted Sqpf 0.432 3.24 Mean:
ID: 3047024 • Letter: O
Question
o) Ety) ly) 0.2 0.3 0.4 o.1 Weighted Squared Dif Weighted Sqpf 0.432 3.24 Mean: 5.2 Var: 456 Stand Dev: 2.13541565 1.31.44 o o. Mean: S2 Var: 456 1.3 32.34 8 |7.BYl 0.1 o Vary)- 4.56 Problem6 have set up the problem in excel as above. Chapter 10 i's wour friend here What isthe formula use in D47 D4:1 What is the formula that l use in ES? 5 5 FS0 F6j used the the "sumO" function to calculate the mean and variance. Write out the complete formula I use in using excel notation (i.e.cell addresses, etc.). Chapter 10 is your friend in use the excel formula Sumproductl to calculate the mean and variance. Write out the full formula in this box. (Chapter 10 is you friend) F9 huse the excel formula "Sumproduct) to calculate the mean and variance. Write out the fullExplanation / Answer
Answers:
Formula in D4 : =A4*B4
Formula in E5 : =(A2-5.2)^2
Formula in F5 : =E5*B5
Formula in D6: =SUM(D2:D5)
Formula in F6: =SUM(F2:F5)
Formula in D9 : =SUMPRODUCT(A2:A5,B2:B5)
Formula in F9: =SUMPRODUCT(B2:B5,E2:E5)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.