# Question: Do the preceding problem but now use the football data

Do the preceding problem, but now use the football data in the file P03_66.xlsx.

a. Given the explanation of SRS, it makes sense to use multiple regression, with PTS and O_PTS as the explanatory variables, to predict SRS. Do you get a good fit?

b. Suppose instead that the goal is to predict Wins. Try multiple regression, using the variables in columns G–AH or variables calculated from them. For example, instead of FG and FGA, you could try FG/FGA, the fraction of attempted field goals made. You will have to guard against exact multicollinearity.

For example, PTS can be calculated exactly from FG, 3P, and FT. This is a good time to use some form of stepwise regression. How well is your best equation able to predict Wins?

a. Given the explanation of SRS, it makes sense to use multiple regression, with PTS and O_PTS as the explanatory variables, to predict SRS. Do you get a good fit?

b. Suppose instead that the goal is to predict Wins. Try multiple regression, using the variables in columns G–AH or variables calculated from them. For example, instead of FG and FGA, you could try FG/FGA, the fraction of attempted field goals made. You will have to guard against exact multicollinearity.

For example, PTS can be calculated exactly from FG, 3P, and FT. This is a good time to use some form of stepwise regression. How well is your best equation able to predict Wins?

**View Solution:**## Answer to relevant Questions

The file P03_63.xlsx contains 2009 data on R&D expenses and many financial variables for 85 U.S. publicly traded companies in the computer and electronic product manufacturing industry. The question is whether R&D expenses ...The number of employees on the payroll at a food processing plant is recorded at the start of each month. These data are provided in the file P12_03.xlsx. Perform a runs test and find a few auto-correlations to determine ...The file P12_10.xlsx contains the daily closing prices of Walmart stock for a one-year period. Does a linear or exponential trend fit these data well? If so, estimate and interpret the best trend model for this time series. ...The file P12_18.xlsx contains the daily closing prices of Chevron stock for a one-year period.a. Use the random walk model to forecast the closing price of this stock on the next trading day.b. You can be about 99.7% certain ...Consider the proportion of Americans under the age of 18 living below the poverty level. The data are in the file P02_44.xlsx.a. Find the first six autocorrelations of this time series.b. Use the results of part a to specify ...Post your question