Suppose that the class grade for a six-week period is based on three tests (T1, T2, T3), each of which counts for 15%, four quizzes (Q1, Q2, Q3, Q4), each of which counts for 10%. and a homework note book (HW), which counts for 15%. The grades are recorded in a spreadsheet similar to the one below.
| A | B | C | D | E | F | G | H | I | J | |
| 1 | Name | T1 | T2 | T3 | Q1 | Q2 | Q3 | Q4 | HW | AVG |
| 2 | Jatin | 87 | 92 | 80 | 76 | 79 | 87 | 74 | 90 | |
| 3 | Amit | 91 | 85 | 77 | 78 | 88 | 96 | 90 | 92 | |
| 4 | Anil | 65 | 72 | 70 | 80 | 81 | 74 | 77 | 80 | |
| 5 | Anita | 96 | 88 | 91 | 76 | 91 | 100 | 74 | 98 |
Which of the following formulae would NOT be a correct calculation of the six-week weighted average for Jatin?
1
= B2 * 0.15 + C2 * 0.15 + D2 * 0.15 + E2 * 0.1 + F2 * 0.1 + G2 * 0.1 + H2 * 0.1 + I2 * 0.15
2
=(B2 + C2 + D2 + I2)*0.15 + (E2 + F2 + G2 + H2)*0.1
3
=(B2 * 0.15 + C2 * 0.15 + D2 * 0.15 + I2 * 0.15) + (E2 + F2 + G2 + H2)/10
4
=(B2 + C2 + D2 + I2)/15 + (E2 + F2 + G2 + H2)/10