Please I need help with this question

3. You are curious to understand if there is a relationship between the average grade (in %) that students received in Assignment 1, 2, and 3 of ECOR 2050 (assignments that covered midterm material) and their grade (in %) in the Midterm of the course. You want to do this investigation to see if you can predict a student's midterm grade based on their average grade in the first three assignments. You are limited to collect 10 sets of data (midterm vs average assignments). For that, you can check this google sheet (https://docs.google.com/spreadsheets/d/11HrLexfWXiEj7fAPn- v47m9fxxXF49RXR6zqXUmTyHg/edit?usp=sharing) to find grades of assignment 1, 2, and 3, and midterm for 10 students. You should be careful that your data set is not biased (30 marks) a) Collect the information and record them in the table below (please use a typed tableumbers as we need to copy paste your numbers into Excel for checking your solution and marking. Or, you can submit your data in a separate Excel sheet.). Comment on how you collected your data and mention how you ensured that your data set is random and unbiased Student 4 5 7 8 9 10 Grade (%) Average of Assignment 1, 2, and 3 Midterm b) What assumptions are important for conducting a simple linear regression analysis? Explain how you would investigate those assumptions are valid for this data set. c) Using your collected data, conduct a simple linear regression experiment and find the regression line. d) Estimate the coefficient of determination of the regression. You must interpret your finding and explain what it indicates. e) Conduct an ANOVA diagnostics for the regression and explain what it indicates. Does it approve the finding of part c? f) If a student received an average of 75% in their first three assignments, what is your prediction of their midterm grade, with 95% confidence