Data Legend tn the Excel data le, the columns we will require are dened as: schoo|_skip.1.00 1 ID The student's survey ID number average _year1 The students' first year undergraduate average 1 The student's answer to the question \"During a typical month of school, how often do you skip class?" in their first year 1: Never, 2: Rarely. 3: Sometimes, 4: Often. 5: Almost Always l schoo|_skip.4.00 The student's answer to the question "During a typical month of school, how often do you skip class?" in their fourth year 1: Never, 2: Rarely. 3: Sometimes, 4: Often. 5: Almost Always hassle_time.1.00 The student's answer to the question "Does not having enough time bother you?" in their first year 1: Almost never bothers me, 2: Sometimes bothers me, 3: Often bothers me 1 hassle_time.7.00 The student's answer to the question \"Does not having enough time bother you?\" in their seventh year 1: Almost never bothers me, 2: Sometimes bothers me, 3: Often bothers me Note: This survey continued after students had graduated so this can be considered their 7th annual survey Question 1. The Stressed@Brock data set tracked a large sample of students throughout their undergraduate careers. so it may be useful in answering the following questions. (a) Calculate the means and standard deviations needed to test the claim that there is a difference in academic performance between year 1 and year 2. (b) Based on the statistical data, can we infer at the 5% significance level that grades of individual students in second year are better than in first year? (c) Construct the 95% confidence interval for the difference between grades in second year and first year. Can we compare this result to the result we obtained in the hypothesis test in (b)? If so, what do you observe? If not, explain why not