What is the weighted average?, math homework help

User Generated




Suppose you have a class where you have four quizzes each worth 15% of the grade and two exams each worth 20%. If you make 77% on two quizzes, 100% on one, and 86% on the fourth along with 98% on one exam and 66% on the other. What is the weighted average?

Please see the attachment for additional insight into what I am looking for in this DQ. Remember that the work needs to be completed in Excel along with the proper Excel formulas.

NOTE: The weighted average must use the 15% and the 20% and is NOT an average of the quizzes and exams.

Unformatted Attachment Preview

Quizzes Exams Weighted Avg Quiz 1 Quiz 2 Quiz 3 Quiz 4 Exam 1 Exam 2 Average 0.65 0.68 0.89 0.58 0.7 0.89 0.78 0.835 0.754 NOTE Each quiz is worth 15 % and each exam is worth 20%. I used different values and you need to use formulas in the cells.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, find attached your answer. There are two files, one in Word and the other in Excel. The E...

Awesome! Perfect study aid.


Related Tags