Question

In: Statistics and Probability

A university would like to develop a regression model to predict the point differential for games...

A university would like to develop a regression model to predict the point differential for games played by its men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win for the university's team and a negative differential is a loss. For a random sample of games, the point differential (y) was calculated, along with the number of assists (x1), rebounds (x2), turnovers (x3) and personal fouls (x4).Complete parts a through f below.

Game   Point_Differential   Assists   Rebounds   Turnovers   Personal_Fouls
1   16   14   38   12   10
2   45   22   46   11   11
3   11   19   45   11   7
4   19   9   34   17   17
5   16   17   36   13   20
6   14   20   36   18   12
7   11   15   26   10   10
8   5   13   28   12   18
9   -3   6   33   12   23
10   -5   14   30   12   15
11   -10   4   22   8   21
12   23   16   39   8   22
13   6   12   38   13   17
14   19   14   39   13   26
15   -10   12   24   9   19
16   38   19   44   10   19
17   2   13   31   7   17
18   8   10   34   21   33
19   10   10   34   20   20
20   -13   11   26   17   38
21   -9   9   26   9   30
22   -2   16   32   15   24

a) Construct a regression model using all four independent

variables.

y= _ + (_)x1 + (_)x2 + (_)x3 + (_)x4

b) Test the significance of each independent variable using a=.05

Identify the general form of the null and alternative hypotheses, where βj is the population regression coefficient for the jth independent variable.

H0: Bj =

H1:Bj=

c) Interpret the p-value for the coefficient of each independent variable. Find the p-value for the coefficient of each independent variable.

d) Construct a 95​% confidence interval for the regression coefficients for the Personal Fouls independent variable and interpret the meaning. A 95% confidence interval for the coefficient of the Personal Fouls independent variable is ___ to ___ The Data

Solutions

Expert Solution

(a) Multiple Regression

The proposed multiple linear regression model :

Where Y: the point differential, X1 : no. of assists; X2 : number of rebounds; X3 : number of turnovers; X4 : number of personal fouls; and : the residual term. Therefore, here the response variable is the risk of having a stroke while the other three variables described above are the predictor variables. Also, = intercept term and = slope.

Assuming, that the sample was randomly drawn, the random variables used in the equation are independent of each other, and the residuals follow an i.i.d. N(0,1). Following the ordinary least square (OLS) method, the estimates are determined as below:

where the slope and intercepts are found through the OLS method based on the sample of x1,x2, x3 and x4.

The regression equation is determined to be as follows:

point differential = -46.9 + 0.56*number of assists + 1.53*number of rebounds - 0.06*number of turnovers - 0.15*number of personal fouls

(b) Test of Significance

Consider the general hypothesis test for the coefficients of each independent variable in the equation as

(c) Interpretation of the p-values

For number of assists the p-value of the respective test is 0.38 > 0.05

For number of rebounds the p-value of the respective test is 0.0013 < 0.05

For number of turnovers the p-value of the respective test is 0.91 > 0.05

For number of personal fouls the p-value of the respective test is 0.65 > 0.05

Therefore, only in one case the null hypothesis can be rejected at 5% significance level.

In other words, the tests of significance show that only number of rebounds is statistically significant to predict point-differential.

(d) 95% Confidence Interval

The 95% confidence interval for number of fouls is given as (-0.803,0.5107) and this shows that the predictor, number of fouls, is not statistically significant to predict the point differential.


Related Solutions

Suppose an athletic director would like to develop a regression model to predict the point differential...
Suppose an athletic director would like to develop a regression model to predict the point differential for games played by the college's men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of home and away games, the point differential was calculated, along with the number of assists, rebounds, and turnovers. The data are given...
A business statistics professor at a college would like to develop a regression model to predict...
A business statistics professor at a college would like to develop a regression model to predict the final exam scores for students based on their current GPAs, the number of hours they studied for the exam, the number of times they were absent during the semester, and their genders. Use the accompanying data to complete parts a through c below. Score   GPA   Hours   Absences   Gender 68   2.55   3.00   0   0 69   2.22   4.00   3   0 70   2.60   2.50   1   0...
Suppose a bank would like to develop a regression model to predict a? person's credit score...
Suppose a bank would like to develop a regression model to predict a? person's credit score based on his or her? age, weekly?income, highest education level? (high school, bachelor? degree, graduate? degree), and whether or not he or she owns or rents his or her primary residence. The accompanying table provides these data for a random sample of customers. Complete parts a through d below Credit_Score   Income_($)      Age      Education        Residence 592                              1,383   55        Bachelor         Own 702                              1,707   65       ...
RPI would like to develop a multiple regression model for predicting graduate student Grade Point Averages....
RPI would like to develop a multiple regression model for predicting graduate student Grade Point Averages. The initial data from 30 grad students are in the file GPA.sav. The file contains the following variables: GPA (graduate grade point averages), GREQ (score on the quantitative section of the Graduate Record Exam, a commonly used entrance exam for graduate programs), GREV (score on the verbal section of the GRE), MAT (score on the Miller Analogies Test, another graduate entrance exam), and AR,...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel Births 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel(y) Births(x) 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below: Sales (units) Price ($) Advertising ($) Holiday 500 100 50 Yes 480 120 40 Yes 485 110 45 No 510 103 55 Yes 490 108 40 No 488 109 30 No 496 106 45 Yes Compile a spreadsheet for the data and determine the predicted number of units sold if the watch is sold...
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below: Sales (units) Price ($) Advertising ($) Holiday 500 100 50 Yes 480 120 40 Yes 485 110 45 No 510 103 55 Yes 490 108 40 No 488 109 30 No 496 106 45 Yes Compile an excel spreadsheet for the above data and determine the regression equation Answer (a) X3 = 1 if...
Castle View Games would like to invest in a division to develop software for video games....
Castle View Games would like to invest in a division to develop software for video games. To evaluate this decision, the firm first attempts to project the working capital needs for this operation. Its chief financial officer has developed the following estimates (in millions of dollars): Year 1 Year 2 Year 3 Year 4 Year 5 Cash 6 12 15 15 15 Accounts receivable 21 22 24 24 24 Inventory 5 7 10 12 13 Accounts payable 18 22 24...
Develop the best logistic regression model that can predict the wage by using the combination of...
Develop the best logistic regression model that can predict the wage by using the combination of any following variables: total unit (X2), constructed unit (X3), equipment used (X4), city location (X5) and total cost of a project (X6). Make sure that you partition your data with 60% training test, 40% validation test, and default seed of 12345 before running the logistic regression (15 points) Wage - X1 Total Unit - X2 Contracted Units - X3 Equipment Used - X4 City...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT