Please use/show excel formulas

You are hired by a major baseball team to predict the number of runs a player will score in a season. With this information, you can help the team to give better contracts and retainers for the players on the team and on the market. The data for their last season is presented in the Table below. Using Excel's Analysis ToolPak Add-in, estimate the following regression model and place your results in cell I12: Runs=1+2batting+3Doubles+4Triples+5Homeruns+6Strikeout+i START YOUR REGRESSON ANALYSIS HERE (LITERALLY RIGHT HERE IN CELL I12) Using the coefficient estimates from the previous regression model, manually calculate the predicted runs and prediction error for each observation. Then create a scatter plot of the Actual runs (Y-axis) against the Predicted runs (X-axis). Place Chart Here! You are hired by a major baseball team to predict the number of runs a player will score in a season. With this information, you can help the team to give better contracts and retainers for the players on the team and on the market. The data for their last season is presented in the Table below. Using Excel's Analysis ToolPak Add-in, estimate the following regression model and place your results in cell I12: Runs=1+2batting+3Doubles+4Triples+5Homeruns+6Strikeout+i START YOUR REGRESSON ANALYSIS HERE (LITERALLY RIGHT HERE IN CELL I12) Using the coefficient estimates from the previous regression model, manually calculate the predicted runs and prediction error for each observation. Then create a scatter plot of the Actual runs (Y-axis) against the Predicted runs (X-axis). Place Chart Here