Services
Discover
Ask a Question
Log in
Sign up
Filters
Done
Question type:
Essay
Multiple Choice
Short Answer
True False
Matching
Topic
Statistics
Study Set
Introduction to Business Statistics
Exam 16: Multiple Regression and Correlation
Path 4
Access For Free
Share
All types
Filters
Study Flashcards
Question 1
Essay
For y = annual household expenditure for appliances maintenance and repair,what independent variables could help explain the amount of money a household spends per year for this purpose?
Question 2
Essay
Under what circumstances would a multiple regression analysis be preferable to a simple regression analysis?
Question 3
Essay
Salary Data was collected from 40 employees to develop a regression model to predict the employee's annual salary using their years with the company (Years),their starting salary (Starting),and their Gender (Male = 0,Female = 1).The results from Excel regression analysis are shown below:
RegresionSlalinlics
Multiple R
0.719714957
R Square
0.516551199
Adjusted R Square
0.476253780
Standard Errar
10515.63461
Dbservations
40
\begin{array}{l}\begin{array} { l r } \hline { \text { RegresionSlalinlics } } \\\hline \text { Multiple R } & \text { 0.719714957 } \\\text { R Square } & \text { 0.516551199 } \\\text { Adjusted R Square } & 0.476253780 \\\text { Standard Errar } & 10515.63461 \\\text { Dbservations } & 40 \\\hline\end{array}\\\end{array}
RegresionSlalinlics
Multiple R
R Square
Adjusted R Square
Standard Errar
Dbservations
0.719714957
0.516551199
0.476253780
10515.63461
40
ANOVA
\text { ANOVA }
ANOVA
of
SS
MS
F
Significance
F
Regression
3
4334682510
1444894170
12.82165585
7.48476
E
−
06
Residual
36
4056901131
112691698.1
Total
39
8391583641
\begin{array}{lrrrrrr}\hline & \text { of } & & \text { SS } & \text { MS } & F & \text { Significance } F \\\hline \text { Regression } & 3 & 4334682510 & 1444894170 & 12.82165585 & 7.48476 \mathrm{E}-06 \\\text { Residual } & 36 & 4056901131 & 112691698.1 & & \\\text { Total } & 39 & 8391583641 & & & \\\hline\end{array}
Regression
Residual
Total
of
3
36
39
4334682510
4056901131
8391583641
SS
1444894170
112691698.1
MS
12.82165585
F
7.48476
E
−
06
Significance
F
Coefficients
Standard Error
t
Stat
P
-value
Intercept
27946.57894
4832.438706
5.783121245
1.35464
E
−
06
Years
1665.251558
425.0829092
3.917474737
0.000383313
Starting
0.266374185
0.12610443
2.112330112
0.041661598
Gender
−
3285.541043
5617.145392
−
0.584912943
0.56225464
\begin{array}{lcrrr}\hline & \text { Coefficients } &{\text { Standard Error }} & {t \text { Stat }} &{P \text {-value }} \\\hline \text { Intercept } & 27946.57894 & 4832.438706 & 5.783121245 & 1.35464 \mathrm{E}-06 \\\text { Years } & 1665.251558 & 425.0829092 & 3.917474737 & 0.000383313 \\\text { Starting } & 0.266374185 & 0.12610443 & 2.112330112 & 0.041661598 \\\text { Gender } & -3285.541043 & 5617.145392 & -0.584912943 & 0.56225464\end{array}
Intercept
Years
Starting
Gender
Coefficients
27946.57894
1665.251558
0.266374185
−
3285.541043
Standard Error
4832.438706
425.0829092
0.12610443
5617.145392
t
Stat
5.783121245
3.917474737
2.112330112
−
0.584912943
P
-value
1.35464
E
−
06
0.000383313
0.041661598
0.56225464
-For a male employee with 5 years of experience and a starting salary of $30,000,what is the approximate 95% confidence interval for his annual salary?
Question 4
Essay
What is the coefficient of multiple determination,and what does it tell us about the relationship between y and the independent variables.
Question 5
Short Answer
Professor A statistics professor investigated some of the factors that affect an individual student's final grade in his course.He proposed the multiple regression model
y
=
β
0
+
β
1
x
1
+
β
2
x
2
+
β
3
x
3
+
ϵ
y = \beta _ { 0 } + \beta _ { 1 } x _ { 1 } + \beta _ { 2 } x _ { 2 } + \beta _ { 3 } x _ { 3 } + \epsilon
y
=
β
0
+
β
1
x
1
+
β
2
x
2
+
β
3
x
3
+
ϵ
where: y = final mark (out of 100) x
1
= number of lectures skipped x
2
= number of late assignments x
3
= mid-term test mark (out of 100) The professor recorded the data for 50 randomly selected students.The computer output is shown below. The regression equation is:
y
^
=
41.6
−
3.18
x
1
−
1.17
x
2
+
.
63
x
3
\hat { y } = 41.6 - 3.18 x _ { 1 } - 1.17 x _ { 2 } + .63 x _ { 3 }
y
^
=
41.6
−
3.18
x
1
−
1.17
x
2
+
.63
x
3
Predictor
Coef
StDev
T
Constant
41.6
17.8
2.337
x
1
−
3.18
1.66
−
1.916
x
2
−
1.17
1.13
−
1.035
x
3
0.63
0.13
4.846
\begin{array}{l|lll|}\hline \text { Predictor } & \text { Coef } & \text { StDev } & T \\\hline \text { Constant } & 41.6 & 17.8 & 2.337 \\x_{1} & -3.18 & 1.66 & -1.916 \\x_{2} & -1.17 & 1.13 & -1.035 \\x_{3} & 0.63 & 0.13 & 4.846 \\\hline\end{array}
Predictor
Constant
x
1
x
2
x
3
Coef
41.6
−
3.18
−
1.17
0.63
StDev
17.8
1.66
1.13
0.13
T
2.337
−
1.916
−
1.035
4.846
S
=
13.74
S = 13.74
S
=
13.74
R
−
S
q
=
30.0
%
\mathrm { R } - \mathrm { Sq } = 30.0 \%
R
−
Sq
=
30.0%
Analysis of Variance
Source of Variation
df
SS
M
S
F
Regression
3
3716
1238.667
6.558
Error
46
8688
188.870
Total
49
12404
\begin{array}{l|llll}\hline \text { Source of Variation } & \text { df } & \text { SS } & M S & F \\\hline \text { Regression } & 3 & 3716 & 1238.667 & 6.558 \\\text { Error } & 46 & 8688 & 188.870 & \\\hline \text { Total } & 49 & 12404 & & \\\hline\end{array}
Source of Variation
Regression
Error
Total
df
3
46
49
SS
3716
8688
12404
MS
1238.667
188.870
F
6.558
-Do these data provide enough evidence to conclude at the 5% significance level that the model is useful in predicting the final mark? Test statistic = ____________________ Critical Value = ____________________ Conclusion: ____________________
Question 6
Short Answer
Grade A statistics teacher collected the following data to determine if the number of hours a student studied during the semester and the number of classes missed could be used to predict the final grade for the course.The following table shows the results of the model being applied to 8 students.
Student
Predicted Grade
Actural Grade
1
84
92
2
93
95
3
77
81
4
81
78
5
81
75
6
89
88
7
88
85
8
85
85
\begin{array} { | c | c | c | } \hline \text { Student } & \text { Predicted Grade } & \text { Actural Grade } \\\hline 1 & 84 & 92 \\\hline 2 & 93 & 95 \\\hline 3 & 77 & 81 \\\hline 4 & 81 & 78 \\\hline 5 & 81 & 75 \\\hline 6 & 89 & 88 \\\hline 7 & 88 & 85 \\\hline \mathbf { 8 } & 85 & 85 \\\hline\end{array}
Student
1
2
3
4
5
6
7
8
Predicted Grade
84
93
77
81
81
89
88
85
Actural Grade
92
95
81
78
75
88
85
85
-Calculate the residual sum of squares.
Question 7
True/False
It is a good idea to make point estimates based on x values that lie beyond the range of the underlying data.
Question 8
Essay
What is a dummy variable,and how is it useful to multiple regression? Give an example of three dummy variables that could be used in describing your home town.
Question 9
Short Answer
Regression Model A multiple regression model was developed to predict the grade point average (GPA)for MBA students based on two entrance exam scores,verbal (VGMAT)and math (MGMAT).The following table shows the actual GPA and predicted GPA for 7 students.
Student
Actural CPA
Predicted CPA
1
3.5
3.71
2
3.1
3.19
3
3.2
3.10
4
4.0
3.74
5
3.6
3.52
6
3.2
3.27
7
3.7
3.78
\begin{array} { | c | c | c | } \hline \text { Student } & \text { Actural CPA } & \text { Predicted CPA } \\\hline 1 & 3.5 & 3.71 \\\hline 2 & 3.1 & 3.19 \\\hline 3 & 3.2 & 3.10 \\\hline 4 & 4.0 & 3.74 \\\hline 5 & 3.6 & 3.52 \\\hline 6 & 3.2 & 3.27 \\\hline 7 & 3.7 & 3.78 \\\hline\end{array}
Student
1
2
3
4
5
6
7
Actural CPA
3.5
3.1
3.2
4.0
3.6
3.2
3.7
Predicted CPA
3.71
3.19
3.10
3.74
3.52
3.27
3.78
-Calculate the total sum of squares.
Question 10
Multiple Choice
In order to test the significance of a multiple regression model involving 4 independent variables and 30 observations,the numerator and denominator degrees of freedom (respectively) for the critical value of F are: