Have to do this question and then also use excel to check to make sure it is right. So have to do it manual way first and then do it with excel. I already have a, b, and c done. I need help with D, E, and F please... A professor is interested in determining the impact of hours worked per day by students(variable X) on final quiz scores (Y). A random sample of ten students is taken with thefollowing results on X and Y:XY108.9.6.76.3104578.34a. Determine the simple regression equation (by hand) that best fits this data.cb. Calculate and interpret the R-Square and the adjusted R-Square for this model.Usng a 0.05 level of significance, test to see if this is a good or bad model using thecorrelation test.d. Using a 0.05 level of significance, test to see if this is a good or bad model using thet-test on slope!e. Using a 0.05 level of significance, test to see if this is a good or bad model using theF-test on slopef. Looking over your full results, what can you conclude about the relationship betweenhours worked per day (X) and final quiz scores (Y)?4. Use Excel to check your answers for question 3. Make sure to turn in your Excel spreadsheet and identify output that relates to the results above

Name: Have to do this question and then also use excel to check to make sure
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Have to do this question and then also use excel to check to make sure it is right. So have to do it manual way first and then do it with excel. I already have a, b, and c done. I need help with D, E, and F please... A professor is interested in de