Can anyone explain how I would use Regression in the AnalysisToolPak?

The questions are:

A. Using Excel's Analysis ToolPak Add-in, estimate the following regression model:
B. Using the coefficient estimates, manually calculate the predicted price and prediction error for each observation.
C. Create a scatter plot of the Actual runs (Y-axis) against the Predicted runs (X-axis) in Part B. Using the information for Runs Scored, Batting Average, Doubles, Triples, Home Runs, and Strike Outs A step-by-step answer would be appreciated

20 Points You are hired by a major baseball team to predict the number of runs a player will score in a season.With this infermation, you can help the team to give better coatracts and retainers for the players on the team and oa the market. The data for their lastseason is presented in the Table below A Uaing Eseel's Analysis ToolPak Add-in, estimate the fellowing regression model: B. Using the coefficient estimates, ma nually calculate the predicted price and prediction error for each observation. C Create a seatter plot of the Actual runs (Y-axis) agaiast the Predicted runs (C-axis) in Part B START YOLR REGRESSON ANALYSS TERE Actual Predicted Runs Run Runs Place Scatter plot here! Home rns Strike outs RunsError 32 49 0297 0291 12 20 0342 20 38 23 13 0.302