Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs onthe final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sampleincludes the number of times a student is absent and their grades on the final exam. The data can be found inthe Excel file Assignment10.xlsx. Do not use any software that I did not assign.TimesLate/Final ExamAbsentGrade984.0092.501252.00587.001175.002445.0039.001046.001963.00265.00298.001724.50858.002069.505549.002368.5070.00475.50285.0097.00297.00293.5093.50278.00286.00288.00Question 1: Which or the two variables (times absent or grades on the final exam) is the independentvariable and which is the dependent variable?Question 2: Using Microsoft Excel: (Excel file Assignment10.xlsx) SHOW YOUR WORKа.Count the number of XY variables.b. Calculate the mean and sample standard deviation of both the independent and dependent variables.Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means.d. Calculate the coefficient of determination, r², using Excel's RSQ function. Explain what it means.с.

1. Since you have asked multiple questions , we will solve the first question for you . If you…

Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs on the final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sample includes the number of times a student is absent and their grades on the final exam. The data can be found in the Excel file Assignment10.xlsx. Do not use any software that I did not assign. Times Late/ Absent Final Exam Grade 9 84.00 92.50 12 52.00 87.00 11 75.00 24 45.00 7 39.00 10 46.00 19 63.00 2 65.00 98.00 17 24.50 8 58.00 20 69.50 55 49.00 23 68.50 6. 70.00 4 75.50 2 85.00 97.00 97.00 2 93.50 93.50 78.00 2 86.00 88.00 Question 1: Which or the two variables (times absent or grades on the final exam) is the independent variable and which is the dependent variable? Question 2: Using Microsoft Excel: (Excel file Assignment10.xlsx) SHOW YOUR WORK а. Count the number of XY variables. b. Calculate the mean and sample standard deviation of both the independent and dependent variables. Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means. d. Calculate the coefficient of determination, r², using Excel's RSQ function. Explain what it means. с.