Answered step by step
Verified Expert Solution
Question
1 Approved Answer
rmula to calculate th C A 6 1 Subject 2 Math 3 English 4 French Weight Score 0.3 85 0.4 76 0.3 81 5 Total
rmula to calculate th C A 6 1 Subject 2 Math 3 English 4 French Weight Score 0.3 85 0.4 76 0.3 81 5 Total 6 7 Average 8 Weighted Average SUMPRODUCT(C2:C5,B2:B5) 1 242 80.67 80.20 SUMPRODUCT(C2:C4,B2:B4) AVERAGE(B2:B4) AVERAGE(C2:C4) rmula to calculate th C A 6 1 Subject 2 Math 3 English 4 French Weight Score 0.3 85 0.4 76 0.3 81 5 Total 6 7 Average 8 Weighted Average SUMPRODUCT(C2:C5,B2:B5) 1 242 80.67 80.20 SUMPRODUCT(C2:C4,B2:B4) AVERAGE(B2:B4) AVERAGE(C2:C4) rmula to calculate th C A 6 1 Subject 2 Math 3 English 4 French Weight Score 0.3 85 0.4 76 0.3 81 5 Total 6 7 Average 8 Weighted Average SUMPRODUCT(C2:C5,B2:B5) 1 242 80.67 80.20 SUMPRODUCT(C2:C4,B2:B4) AVERAGE(B2:B4) AVERAGE(C2:C4)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started