Developing a multiple regression model

Reference no: EM13983094

The athletic director of State University is interested in developing a multiple regression model that might be used to explain the variation in attendance at football games at his school. A sample of 16 games was selected from home games played during the past 10 seasons.

Data for the following factors were determined:

y = Game attendance

x1 = Team win/loss percentage to date

x2 = Opponent win/loss percentage to date

x3 = Games played this season

x4 = Temperature at game time

The data collected are in the file called Football.

a. Produce scatter plots for each independent variable versus the dependent variable. Based on the scatter plots, produce a model that you believe represents the relationship between the dependent variable and the group of predictor variables represented in the scatter plots.

b. Based on the correlation matrix developed from these data, comment on whether you think a multiple regression model will be effectively developed from these data.

c. Use the sample data to estimate the multiple regression model that contains all four independent variables.

d. What percentage of the total variation in the dependent variable is explained by the four independent variables in the model?

e. Test to determine whether the overall model is statistically significant. Use a = 0.05.

f. Which, if any, of the independent variables is statistically significant? Use a significance level of a = 0.08 and the p-value approach to conduct these tests.

g. Estimate the standard deviation of the model error and discuss whether this regression model is acceptable as a means of predicting the football attendance at State University at any given game.

h. Define the term multicollinearity and indicate the potential problems that multicollinearity can cause for this model. Indicate what, if any, evidence there is of multicollinearity problems with this regression model. Use the variance inflation factor to assist you in this analysis.

i. Develop a 95% confidence interval estimate for each of the regression coefficients and interpret each estimate. Comment on whether the interpre- tation of the intercept is relevant in this situation.

Reference no: EM13983094

Questions Cloud

Will electromagnetic wave be more successful : In which situation shown in Figure will the electromagnetic wave be more successful in inducing a current in the loop? Explain.

Dispersion of the sampling errors : Repeat the calculations in part b for samples of size 5 and 2. What effect does a change in the sample size appear to have on the dispersion of the sampling errors?

Does the organization have any social media presence : Using what you've learned about graphic and document design, analyze the organization's website, in terms of its effectiveness in helping to engage participants, volunteers, or donors. Can anyone visiting the site easily understand the organizatio..

Explain how health care laws are created. : Completethe Health Care Laws Matrix - Explain how health care laws are created. Evaluate the impact of local, state, and federal laws on the health care industry

Developing a multiple regression model : The athletic director of State University is interested in developing a multiple regression model that might be used to explain the variation in attendance at football games at his school. A sample of 16 games was selected from home games played d..

Determine the average monthly increase : a. Determine the mean and median for the PHSI between January 2004 and August 2005. Specify the shape of the PHSI's distribution. b. The PHSI was at 111.0 in January 2004 and it was at 129.5 in August of 2005. Determine the average monthly increa..

Find the deceleration caused by kinetic friction : A skater with an initial speed of 8.40 m/s stops propelling himself and begins to coast across the ice, eventually coming to rest. Air resistance is negligible. The coefficient of kinetic friction between the ice and the skate blades is 0.100. Fin..

What is the speed od the skier on the top of the next hill : A skier slides down a hill starting with zero speed at a height of 43 m above the bottom of the hill. What is the speed od the skier on the top of the next hill at a height of 37m. Show work.

Write the euler equation for optimal savings : Write the Euler equation or first-order condition for optimal savings S1. Explain the intuition behind this equation in words,

User Account

All Pages