Data Background High achievement in school is regarded as a result of multiple combinations of several factors including household and individual demographics, social and school-related features. Internal and final assessments contribute to final results. 'MCD2080 T2 22 FAT I Ver A data.xIsx' contains two worksheets: "Variable definition" and "Student information". The "Student information" worksheet contains data for 395 individuals from a certain tertiary institution. Use the data to answer Questions 1 and Question 2. Question 1 [1 + 1 + 5 +5 = 12 marks] a) Among the factors influencing the students' final results is the hour of study students put in. Below is Exhibit 1, a pivot table of the grouped final score by the study time. Exhibit 1. Count of Finalscore |Studytime (hours) Finalscore 2 4 Grand Total - W 6-16 6 3 10 16-26 7 4 20 26-36 8 24 2 4 38 36-46 21 34 5 4 64 46-56 16 47 16 5 84 56-66 21 41 9 76 66-76 13 22 17 4 56 76-86 7 14 8 2 31 86-96 6 4 3 2 15 96-106 Grand Total 105 198 65 27 395 Using the pivot table in Exhibit 1, (i) Identify the final score group with the highest number of students. What proportion of students belong in this group? Show all workings to 4 decimal places. (ii) What percentage of students achieved a final score between 66-76 given they studied for 3 hours? Show all workings to 2 decimal places.b) Investigate whether the student's final score is independent of the study time by examining the groups of "final score of 76% - 86%" and "Study time = 4" In your explanation, write down the probability statements that would support the independence of the two variables. c) The chart below (Exhibit 2) gives the "Final score" by the "Gender: Exhibit 2 Student Final score by gender 25.0% 22.5% 20.0% 2 17.5% 15.0% 12.5% F 10.0% 7.5% IM 5.0% 2.5% 0.0% 6-16 16-26 26-36 36-46 46-56 56-66 66-76 76-86 86-96 96-106 Final score From the chart in Exhibit 2, discuss the distribution of final score by gender. Highlight the main features