63. Refer to the Baseball 2016 data, which reports information on the 2016 MajorLeague Baseball season. Let attendance be the dependent variable and total team salarybe the independent variable. Determine the regression equation and answer thefollowing questions.a. Draw a scatter diagram. From the diagram, does there seem to be a direct relationshipbetween the two variables?b. What is the expected attendance for a team with a salary of $100.0 million?c. If the owners pay an additional $30 million, how many more people could they expectto attend?d. At the .05 significance level, can we conclude that the slope of the regression line ispositive? Conduct the appropriate test of hypothesis.e. What percentage of the variation in attendance is accounted for by salary?f. Determine the correlation between attendance and team batting average and betweenattendance and team ERA. Which is stronger? Conduct an appropriate test ofhypothesis for each set of variables.

Please Explain step by step to use in excel

https://docs.google.com/spreadsheets/d/1vlSdQKbGxoMJaP5xszasb0W5hUcAbFvJuUkiySQSDjM/edit?usp=sharing