PLEASE ANSWER USING EXCEL. THANK YOU!

1 What if analysis practice B In the middle of the semester, Robert wants to know his options to achieve his target final grade for class: Run a what-if analysis (goal seek, data table, and optimization) with the following information for Robert: a. There are 3 exams (scale: 100 points each), and Exam 1 & 2 were 80 and 90 points. b. There are 3 quizzes (scale: 50 points each), and points for quizzes 1 and 2 were 50 and 40. c. There are 5 assignments (scale: 30 points each), and points for the first two assignments were 30 and 30. d. Assume Robert will get 100% on the participation score (scale: 50 points). e. Total scale based on the information above is 650 points. Those who reach 90%, 80%, 70%, and 60% of the total 650 points will get the final letter grade of A, B, C, and D respectively. 10 11 12 13 14 15 16 Robert wants to know 1. How much does he have to score on Exam3 to achieve a final 'A' grade if he assumes 100% credit on the remaining quiz and 90% credit on the remaining assignments ?=> Goal Seek 2. Using sensitivity analysis (data table), show 3 possible score combinations of the remaining exam and quiz for the final 'A' grade. - Assume the sum of the remaining three assignment scores is 50 points out of the possible 90 points. - The remaining quiz score varies by 5 between 15 and 50 points, while the final exam score varies by 5 between 65 and 100. 3. If Robert thinks he can achieve up to 90% score on the remaining exam, and at least 50% score on the remaining quiz and assignments. what is the maximum and minimum grade you can expect? => use optimization. 19 20 Where to begin? 21 1. Create a formula table, and designate variable & constant. Run Goal seek! 22 2. Create a data table with variables, and connect this table with the formula table. Then, run the Data table! 29 3. Create cells for constraints. Run Solver for optimization! 17 18 1 What if analysis practice B In the middle of the semester, Robert wants to know his options to achieve his target final grade for class: Run a what-if analysis (goal seek, data table, and optimization) with the following information for Robert: a. There are 3 exams (scale: 100 points each), and Exam 1 & 2 were 80 and 90 points. b. There are 3 quizzes (scale: 50 points each), and points for quizzes 1 and 2 were 50 and 40. c. There are 5 assignments (scale: 30 points each), and points for the first two assignments were 30 and 30. d. Assume Robert will get 100% on the participation score (scale: 50 points). e. Total scale based on the information above is 650 points. Those who reach 90%, 80%, 70%, and 60% of the total 650 points will get the final letter grade of A, B, C, and D respectively. 10 11 12 13 14 15 16 Robert wants to know 1. How much does he have to score on Exam3 to achieve a final 'A' grade if he assumes 100% credit on the remaining quiz and 90% credit on the remaining assignments ?=> Goal Seek 2. Using sensitivity analysis (data table), show 3 possible score combinations of the remaining exam and quiz for the final 'A' grade. - Assume the sum of the remaining three assignment scores is 50 points out of the possible 90 points. - The remaining quiz score varies by 5 between 15 and 50 points, while the final exam score varies by 5 between 65 and 100. 3. If Robert thinks he can achieve up to 90% score on the remaining exam, and at least 50% score on the remaining quiz and assignments. what is the maximum and minimum grade you can expect? => use optimization. 19 20 Where to begin? 21 1. Create a formula table, and designate variable & constant. Run Goal seek! 22 2. Create a data table with variables, and connect this table with the formula table. Then, run the Data table! 29 3. Create cells for constraints. Run Solver for optimization! 17 18