Business Report Case Analysis, statistics homework help

/in /by

Business Report Case Analysis, statistics homework help

I have the answer for this case but I need it to be business report

I need to make 6 different reports for this case for me and 5 of my friends.

It have to be totally different we are in the same class with the same teacher

I attached the data set and I attached the answers you can use

I need a business report not just answer the questions:

The business report has:

1- Introduction / summary

2- Result / finding/ analysis

3- Conclusion

2. Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season. Let the number of games won be the dependent variable and the following variables be independent variables: team batting average, number of stolen bases, number of errors committed, team ERA, number of home runs, and whether the team plays in the American or the National League.

a. Use a statistical software package to determine the multiple regression equation. Discuss each of the variables. For example, are you surprised that the regression coefficient for ERA is negative? Is the number of wins affected by whether the team plays in the National or the American League?

b. Find the coefficient of determination for this set of independent variables.

c. Develop a correlation matrix. Which independent variables have strong or weak correlations with the dependent variable? Do you see any problems with multicollinearity?

d. Conduct a global test on the set of independent variables. Interpret.

e. Conduct a test of hypothesis on each of the independent variables. Would you consider deleting any of the variables? If so, which ones?

f. Rerun the analysis until only significant regression coefficients remain in the analysis. Identify these variables.

g. Develop a histogram or a stem-and-leaf display of the residuals from the final regression equation developed in part (f). Is it reasonable to conclude that the normality assumption has been met?

h. Plot the residuals against the fitted values from the final regression equation developed in part (f). Plot the residuals on the vertical axis and the fitted values on the horizontal axis.