using Excel Run a regression analysis on the following data set, where y is the final grade in a math class and I is theaverage number of hours the student spent working on math each week.hours/weekGrade5956.462.458.21276.81378.21482.61797.81789.81890.2State the regression equation y = m - I + 6, with constants accurate to two decimal places.PreviewWhat is the predicted value for the final grade when a student spends an average of 7 hours each weekon math?Grade =Round to 1 decimal place.

Name: using Excel Run a regression analysis on the following data set, where
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: using Excel Run a regression analysis on the following data set, where y is the final grade in a math class and I is theaverage number of hours the student spent working on math each week.hours/weekGrade5956.462.458.21276.81378.21482.61797.81789.8189

Regression: The regression analysis is conducted here by using EXCEL. The software procedure is given below: Enter the data. Select Data > Data Analysis >Regression> OK. Enter Input Y Range as y Enter Input X Range as x Click OK. The output using EXCEL is as follows:The regression equation is y =2.94x + 41.09 The predicted value of y using unrounded regression equation is as follows: y =2.9353x + 41.0901 =2.9353×7+ 41.0901 = 61.6372 ≈ 61.6 Grade = 61.6