Can you please assist me on this problem. I'm having trouble breaking the problem down. The accompanying data are the number of wins and the earned run averages (mean number of earned runs allowed per nine innings pitched) for eight baseball pitchers in a recent season. Find the equation of the regression line.Then construct a scatter plot of the data and draw the regression line. Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. If the x-value is not meaningful to predict the value of y,explain why not.(a) x= 5 winsE Click the icon to view the table of numbers of wins and earned run average.(b) x= 10 wins(c) x= 19 wins(d) x = 15 winsWins and ERAThe equation of the regression line is y =x+(Round to two decimal places as needed.)Earned runWins, xaverage, y202.79183.28172.68163.78143.93124.43113.7295.05

Name: Can you please assist me on this problem. I'm having trouble breaking
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: Can you please assist me on this problem. I'm having trouble breaking the problem down. The accompanying data are the number of wins and the earned run averages (mean number of earned runs allowed per nine innings pitched) for eight baseball pitchers

It is given that the values of wins and corresponding earned run average.The regression equation is, . Calculate the regression equation using Excel is as follows: Procedure: Step 1: Go to Data > Data Analysis > Regression > ok. Step 2: In Input Y range, select the column of y (earned run average). Step 3: In Input X range, select the column of x (wins). Step 4: Click on OK. Output: Therefore, the regression equation is .(a) Predict the value of y when x = 5 is, The predicted average earned run when wins are 5 is 5.48. (b) Predict the value of y when x = 10 is, The predicted average earned run when wins are 10 is 4.58. (c) Predict the value of y when x = 19 is, The predicted average earned run when wins are 19 is 2.90. (d) Predict the value of y when x = 15 is, The predicted average earned run when wins are 15 is 3.64.