Question 2 The table below are mock final grades of a student at Rutgers University - Newsrk in Fall 2019 / Spring 2020. Summary transcript for Fall 2019 / Spring 2020 Course 040 135 198:101 198:280 640:237 640:327 198 102 640:130 198:251 198 335 Grcle: 93 68 75 76 93 77 Credits 4 3 3 3 4 3 3 1. Recreate the transcript as a data Tame in R 2. Write a function that takes for input the data frame you just created and returns the GPA of the student for the year (the Grado Point avcrage for all courses listed) (a) The GPA is calculated by dividing the total amount of grade points earned by the total amount of credit hours attempted: GPA-credits. XGrade Points) credits (1) (b) You will need to so the Rutgers University grading scheme below to convert the percent rule is a grade point. Th.: Molgora Uvery - Nework Crocksacy Scheme Grade B- B C- D) F Grule Paint 3.5 3.0 2.3 2.0 1.0 0 Perinta 89.5-100 81.5-89.49 79.5-81.19 71.5-79.49 19.5-71.19 59.5-69.19 0-59. 19 -1.0 21219:220 - Fundamentals of Data Visualization in R: Assignment 1 Your function should follow this syntax outline: SpaCalculator grade K-grade Point waive # # $. Colculate the GPA with the gredePoint vector you have created 1 and the credits columns from the data frame. # 4. Return the GPA you have calculated return (GPA) } Question 2 The table below are mock final grades of a student at Rutgers University - Newsrk in Fall 2019 / Spring 2020. Summary transcript for Fall 2019 / Spring 2020 Course 040 135 198:101 198:280 640:237 640:327 198 102 640:130 198:251 198 335 Grcle: 93 68 75 76 93 77 Credits 4 3 3 3 4 3 3 1. Recreate the transcript as a data Tame in R 2. Write a function that takes for input the data frame you just created and returns the GPA of the student for the year (the Grado Point avcrage for all courses listed) (a) The GPA is calculated by dividing the total amount of grade points earned by the total amount of credit hours attempted: GPA-credits. XGrade Points) credits (1) (b) You will need to so the Rutgers University grading scheme below to convert the percent rule is a grade point. Th.: Molgora Uvery - Nework Crocksacy Scheme Grade B- B C- D) F Grule Paint 3.5 3.0 2.3 2.0 1.0 0 Perinta 89.5-100 81.5-89.49 79.5-81.19 71.5-79.49 19.5-71.19 59.5-69.19 0-59. 19 -1.0 21219:220 - Fundamentals of Data Visualization in R: Assignment 1 Your function should follow this syntax outline: SpaCalculator grade K-grade Point waive # # $. Colculate the GPA with the gredePoint vector you have created 1 and the credits columns from the data frame. # 4. Return the GPA you have calculated return (GPA) }