Please show this in Excel form, thank you!! The Wall street journal conducted a
ID: 3434549 • Letter: P
Question
Please show this in Excel form, thank you!!
The Wall street journal conducted a study of basketball spending at top colleges. A portion of the data showing the revenues ($millions), percentage of wins, and the coach's salary ($million) for the 39 of the country's top basketball programs follows (The Wall Street Journal, March 11-12, 2006).
1.00
A.) Develope the estimated regression equation that can be used to predict the coaches salary given the revenue generated by the program and the percentage of wins.
B.) Use the F Test to determine the overall significance of the relationship. What is your conclusion at the .05 level of significance?
C.) Use the t-test to determine the significance of each independent variable. What is your conclusion at teh .05 level of significance?
This is supposed to be shown in Excel form, and I have no clue how to do that. Thank you for all your help!!
School Revenue % Wins Salary Alabama 6.5 611.00
Arizona 16.6 63 .70 Arkansas 11.1 72 .80 Boston College 3.4 80 .53 Washington 5.0 83 .89 West Virginia 4.9 67 .70 Wichita State 3.1 75 .41 Wisconsin 12.0 66 .70Explanation / Answer
A)
B) The regression is significant at 5% los because the significance is 0.7614.
C) All the t significance values are greater than 0.05. Hence all the variables are significant.
SUMMARY OUTPUT Regression Statistics Multiple R 0.321355 R Square 0.103269 Adjusted R Square -0.25542 Standard Error 0.210467 Observations 8 ANOVA df SS MS F Significance F Regression 2 0.025506 0.012753 0.287904 0.761475 Residual 5 0.221481 0.044296 Total 7 0.246988 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 1.130679 0.961019 1.176541 0.292336 -1.3397 3.601057 -1.3397 3.601057 revenue 0.003324 0.019953 0.166575 0.874231 -0.04797 0.054615 -0.04797 0.054615 %wins -0.00621 0.012137 -0.51199 0.630459 -0.03741 0.024986 -0.03741 0.024986