2) Cells C15 throught H15 contains the weights assigned to each assignment, quiz

Question

2) Cells C15 throught H15 contains the weights assigned to each assignment, quiz, or exam. In cell J22 calculate the weighted average of the first students scores by entering a formula that multiples each score by its corresponding weight and adds the resulting products.(please show formula)

3) Edit the formula in cell J22 changing the references to the weights in cell C15 through H15 from relative references to absoulte references.

4)Use auto fill to cop the formula from cell J22 into the rants J23:J57

5) In cell K22 use the RANK function to calucate how the first studnet compares to the other studnets in the class. USe the weighted average from cell J22 for the number argument and the range of weighted averages in the cell rant $J$22:$J$57 for the ref argument. You do not need to specify a value for the order argument.

10% 10% Class Summary Class Average Low Score High Score Final Weighted Exam Average Student ID Last Name First Name Homework Quiz1 Quiz2 Quiz3 Quiz 4 100 14463 Anderson 10280 Batson 13645 Burress 13118 Colbert 19262 Connell 14124 Dixon 14422 Dunforg 17659 English 17217 Farrel 14426 Fowler 15060 Garcia 11486 Gonzalez 11676 Harpe 14244 Harris 15780 Herron 19655 Hodge 18878 Johnsorn 14108 Kelly 12888 Kimble 14013 Long 17788 Marion 18778 McGhee 12545 McKillip 11025 Medina 15908 Nelson 12576 Payne 15474 Ranson 12266 Reardon 15360 Robbs 14490 Romero 18947 Rubinstein 14344 Slavin 15140 Thompson 17951 Willoughb 14858 Wilson 12720 Worth Frank 5 2 Amie Luann Juan Vernon Brenda 100 2 100 Robert Geraldine Harold Deana Carrie Linda Richard Manuel Tammy Ramon Gwen Christopher Courtne Doroth Joseph Teresa Theodore William 100 8 100 100 Victor Karen Isaac Jonathan Albertine Christopher 8 100

Explanation / Answer

Weighted average in J22 is 87.95 and it is calcuated by the formula

=D22*C15+E22*D15+F22*E15+G22*F15+H22*G15+I22*H15

If we change to absolute references, the formula becomes

=D22*0.2+E22*0.1+F22*0.1+G22*0.15+H22*0.15+I22*0.3

We used auto fill to get the weighted average of all students and the values are :

76.8

We use the RANK() function in K22 and found the rank to be 12. The forumla used is :

=RANK(J22,J22:J57)

The excel output is as follows :

87.95 87.1 61.2 91.55 85.05 59.55 60.35 88.05 94.05 69.9 93.5 74.75 87 93.5 87.5 88.55 84.6 83.65 94.95 78.2 79.4 81.65 80.1 97.55 86.9 60.55 71.35 75.05 71.1 87.65 82.45 94.7 81.3 88.2 94.4

76.8

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.