# Question: The file P03 65 xlsx contains basketball data on all NBA teams

The file P03_65.xlsx contains basketball data on all NBA teams for five seasons. The SRS (simple rating system) variable is a measure of how good a team is in any given year.

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

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 ...The file P12_02.xlsx contains the weekly sales at a local bookstore for each of the past 25 weeks. Is this time series random? Perform a runs test and find a few autocorrelations to support your answer.The file P12_01.xlsx contains the monthly number of airline tickets sold by a travel agency.a. Does a linear trend appear to fit these data well? If so, estimate and interpret the linear trend model for this time series. ...The closing value of the AMEX Airline Index for each trading day during a one-year period is given in the file P12_17.xlsx.a. Use the random walk model to forecast the closing price of this stock on the next trading day.b. ...The Consumer Confidence Index (CCI) attempts to measure people’s feelings about general business conditions, employment opportunities, and their own income prospects. The file P02_20.xlsx contains the annual average values ...Post your question