# Question: Do the previous problem but use the basketball data on

Do the previous problem, but use the basketball data on all NBA teams in the file P03_56.xlsx.

a. Rearrange the data so that there are six columns: Team, Year, Salary Last Year, Salary This Year, Wins Last Year, and Wins This Year. You don’t need rows for 2004 rows, because the data for 2003 isn’t available for Salary Last Year and Wins Last Year. Your ending data set should have 5*30 rows of data.

b. Run a multiple regression for Wins This Year versus the other variables (besides Team). Then run a forward stepwise regression with these same variables. Compare the two equations, and explain exactly what the coefficients of the equation from the forward method imply about wins.

c. The Year variable should be insignificant. Is it?

Why would it be contradictory for the “true” coefficient of Year to be anything other than zero?

d. Statistical inference from regression equations is all about inferring from the given data to a larger population. Does it make sense to talk about a larger population in this situation? If so, what is the larger population?

a. Rearrange the data so that there are six columns: Team, Year, Salary Last Year, Salary This Year, Wins Last Year, and Wins This Year. You don’t need rows for 2004 rows, because the data for 2003 isn’t available for Salary Last Year and Wins Last Year. Your ending data set should have 5*30 rows of data.

b. Run a multiple regression for Wins This Year versus the other variables (besides Team). Then run a forward stepwise regression with these same variables. Compare the two equations, and explain exactly what the coefficients of the equation from the forward method imply about wins.

c. The Year variable should be insignificant. Is it?

Why would it be contradictory for the “true” coefficient of Year to be anything other than zero?

d. Statistical inference from regression equations is all about inferring from the given data to a larger population. Does it make sense to talk about a larger population in this situation? If so, what is the larger population?

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

Do the previous problem, but use the football data on all NFL teams in the file P03_57.xlsx.a. Rearrange the data so that there are six columns: Team, Year, Salary Last Year, Salary This Year, Wins Last Year, and Wins This ...Wagner Printers performs all types of printing, including custom work, such as advertising displays, and standard work, such as business cards. Market prices exist for standard work, and Wagner Printers must match or better ...Determine whether the RAND() function in Excel actually generates a random stream of numbers. Generate at least 100 random numbers to test their randomness with a runs test and with autocorrelations. Summarize your findings.The unit sales of a new drug for the first 25 months after its introduction to the marketplace are recorded in the file P12_15.xlsx.a. Estimate a linear trend equation using the given data. How well does the linear trend fit ...The file P12_24.xlsx contains the daily closing prices of Procter & Gamble stock for a one-year period. Use only the 2003 data to estimate the trend component of the random walk model. Next, use the estimated random walk ...Post your question