Grade Breakdown Quizzes Homework Midterms Project Final Sum of Points Required Points for Desired Grade Points Possible Alan Bob Chris David Ethan Frank 100 85 89 90 100 94 83 100 95 90 90 94 95 99 200 170 167 171 177 190 187 200 175 182 179 160 185 190 200 800 525 528 530 531 564 559 Required: 1. In the analysis of Lab 9-8, Bob's needed performance on the final exam would be points. 192 161 156 195 Check my work 2. In the analysis of Lab 9-8, if Alan needed to get a "B" (or 80%), what value would the input into the "To value" field of the goal seek what-if analysis? 160 640 720 780 3. In the analysis of Lab 9-8, Ethan's needed performance on the final exam to get an "A" (or 90%) would be 161 189 195 156 .points. 4. If Frank wanted to get a "B" (or 80%) in the course, how many points would he need to get on the final exam? 161 201 640 81 5. If Chris wanted to get an "A" (or 90%) in the course, how many points would he need to get on the final exam? 192 189 190 195