Please show this in Excel form thank you The Wall street jou

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!!

Solution

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.