Be tor test the SignIcance Of Pz 24. The Wall Street Journal conducted a study of basketball spending at top colleges. A por- tion of the data showing the revenue ($ millions). percentage of wins, and the coach's salary ($ millions) for 39 of the country's top basketball programs follows (The Wall Street Journal, March 11-12, 2006). School Revenue To Wins Salary Alabama 6.5 61 1.00 Arizona 16.6 63 170 Arkansas 11:1 72 180 Boston College 3.4 80 .53 Washington 5.0 83 .89 West Virginia 49 67 .70 Wichita State 3.1 75 .41 Wisconsin 12.0 66 .70 a. Develop the estimated regression equation that can be used to predict the coach's 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 f test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance? 25. The Conde Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships Conde Nast Traveler w bsite, March 1. 2012). own below are the scores each ship received based upon the results from Conde Nast Traveler's annual Readers' Choice Survey allent or very good Economics 326 Assignment #4 Please use statistical software (Excel, for example) to estimate sample multiple regression line. For all problems, please write down the estimated sample regression lines in the standard format, and explain the meaning of coefficient of determination or R Square, as well as the meaning of each and all estimated coefficients (including the intercept) in the context of each problem and in plain English. Set #1 Page 705, problems 24 and 25 Set #2 Page 715, problems 35, 36, and 37 Set #3 Page 842, problems 30, 31