Could someone help me with the following questions on excel.Thank you A professor wants to conduct a study in a statistics class to measure the effect of solving problems at home on the performance on thefinal exam. She collected data at random for 20 students from a class on the number of hours spent in a week doing problem sets athome (X) and their score on the final exam (Y), as shown in the following table. Answer questions (a) through (d) based on this data.X = # of hrs/week24 10 20 6 5 21 23 18 19 12 16 6 19 5 22 12 20 15 18 10= score on the final 100 72 90 63 59 90 98 89 86 73 85 66 86 64 96 73 94 85 85 70Ya. The regression slope isand the vertical intercept isb. The predicted final score of a student who studies for 12 hours every week isc. The coefficients of determination isand coefficient of non-determination isd. Perform an F-test for the significance of the regression at 0.05 level of significance. Answer if you found the model to be"significant" or "not significant" based on this test.

Name: Could someone help me with the following questions on excel.Thank you
Uploaded: 2024-03-20T06:38:44.000Z
Channel: Bartleby
Description: Could someone help me with the following questions on excel.Thank you A professor wants to conduct a study in a statistics class to measure the effect of solving problems at home on the performance on thefinal exam. She collected data at random for 2