What-If Analysis:
| Students ID | Test1 | Test2 | Test3 | Final Exam | Semester Average |
| 1 | 89 | 55 | 82 | 99 | |
| 2 | 78 | 85 | 90 | 0 | |
| 3 | 53 | 66 | 89 | 0 |
Grading Policy: every test score has an equal weight to the semester average.
1. Calculate the average score for each student.
2. If there is a typo for #1 student who supposes to have 85 for Test 2,
correct it and fine the new average.
(What happen if you change data?)
3. Student #2 has an excuse for the final exam. He will take the
make-up test.
Can he get an "A"?
How about a "B"? What score should he get in
order for him to get a "B" grade?
4. What is the highest grade the student #3 can get if he make-up his final exam?
Click Data / What-If Analysis / Goal Seek