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

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

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 ...The file S12_01.xlsx contains the monthly number of airline tickets sold by a travel agency. Is this time series random? Perform a runs test and find a few autocorrelations to support your answer. Use a runs test and calculate auto relations to decide whether the random series explained in each part of this problem (a–c) are random. For each part, generate at least 100 random numbers in the series. a. A series of ...The file P12_16.xlsx contains the daily closing prices of American Express 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 95% ...Consider the Consumer Price Index (CPI), which provides the annual percentage change in consumer prices. The data are in the file P02_19.xlsx. a. Find the first six autocorrelations of this time series.b. Use the results of ...Post your question