Services
Discover
Homeschooling
Ask a Question
Log in
Sign up
Filters
Done
Question type:
Essay
Multiple Choice
Short Answer
True False
Matching
Topic
Statistics
Study Set
Business Statistics Study Set 2
Quiz 15: Multiple Regression
Path 4
Access For Free
Share
All types
Filters
Study Flashcards
Question 21
Multiple Choice
Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. The regression coefficient for Advertising was found to be +3.0926, which of the following is the correct Interpretation for this value?
Question 22
Multiple Choice
A sample of 33 companies was randomly selected and data collected on the average annual bonus, turnover rate (%) , and trust index (measured on a scale of 0 - 100) . Using the output below, and a significance level of α = .01, we can conclude that Dependent Variable is Turnover Rate
Predictor
Coef
SE Coef
T
P
Constant
12.1005
0.7826
15.46
0.000
Trust Index
−
0.07149
0.01966
−
3.64
0.001
Average Bonus
−
0.0007216
0.0001481
−
4.87
0.000
\begin{array} { l r r r r } \text { Predictor } & \text { Coef } & \text { SE Coef } & \text { T } & \text { P } \\ \text { Constant } & 12.1005 & 0.7826 & 15.46 & 0.000 \\ \text { Trust Index } & - 0.07149 & 0.01966 & - 3.64 & 0.001 \\ \text { Average Bonus } & - 0.0007216 & 0.0001481 & - 4.87 & 0.000 \end{array}
Predictor
Constant
Trust Index
Average Bonus
Coef
12.1005
−
0.07149
−
0.0007216
SE Coef
0.7826
0.01966
0.0001481
T
15.46
−
3.64
−
4.87
P
0.000
0.001
0.000
S
=
1.49746
R
−
S
q
=
79.6
%
R
−
S
q
(
a
d
j
)
=
78.3
%
S = 1.49746 \quad \mathrm { R } - \mathrm { Sq } = 79.6 \% \mathrm { R } - \mathrm { Sq } ( \mathrm { adj } ) = 78.3 \%
S
=
1.49746
R
−
Sq
=
79.6%
R
−
Sq
(
adj
)
=
78.3%
Analysis of Variance
Source
DF
SS
MS
Regression
2
262.73
131.36
Residual Error
30
67.27
2.24
Total
32
330.00
\begin{array} { l r r r } \text { Source } & \text { DF } & \text { SS } & \text { MS } \\ \text { Regression } & 2 & 262.73 & 131.36 \\ \text { Residual Error } & 30 & 67.27 & 2.24 \\ \text { Total } & 32 & 330.00 & \end{array}
Source
Regression
Residual Error
Total
DF
2
30
32
SS
262.73
67.27
330.00
MS
131.36
2.24
Question 23
Multiple Choice
Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. The adjusted R2 value was reported As 83.3%. This means that
Question 24
Multiple Choice
Using the output below, calculate the predicted turnover rate for a company having a trust index score of 70 and an average annual bonus of $6500.
Dependent Variable is Turnover Rate
Predictor
Coef
SE Coef
T
P
Constant
12.1005
0.7826
15.46
0.000
Trust Index
−
0.07149
0.01966
−
3.64
0.001
Average Bonus
−
0.0007216
0.0001481
−
4.87
0.000
\begin{array}{l}\text { Dependent Variable is Turnover Rate }\\\begin{array} { l r r r r } \text { Predictor } & \text { Coef } & \text { SE Coef } & \text { T } & \text { P } \\\text { Constant } & 12.1005 & 0.7826 & 15.46 & 0.000 \\\text { Trust Index } & - 0.07149 & 0.01966 & - 3.64 & 0.001 \\\text { Average Bonus } & - 0.0007216 & 0.0001481 & - 4.87 & 0.000\end{array}\end{array}
Dependent Variable is Turnover Rate
Predictor
Constant
Trust Index
Average Bonus
Coef
12.1005
−
0.07149
−
0.0007216
SE Coef
0.7826
0.01966
0.0001481
T
15.46
−
3.64
−
4.87
P
0.000
0.001
0.000
Question 25
Multiple Choice
Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. The plot of residuals versus Predicted values is shown below. What does the residual plot suggest?
Question 26
Multiple Choice
Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. According to the output below, the Calculated t-statistic to determine if amount spent on advertising is a significant Independent variable in explaining Sony Bravia sales is
Dependent Variable is sales
Predictor
Coef
SE Coef
T
P
Constant
90.19
25.08
3.60
0.001
Price
−
0.03055
0.01005
−
3.04
0.005
Advertising
3.0926
0.3680
8.40
0.000
\begin{array}{l}\text { Dependent Variable is sales }\\\begin{array} { l r r r r } \text { Predictor } & \text { Coef } & \text { SE Coef } & \text { T } & \text { P } \\\text { Constant } & 90.19 & 25.08 & 3.60 & 0.001 \\\text { Price } & - 0.03055 & 0.01005 & - 3.04 & 0.005 \\\text { Advertising } & 3.0926 & 0.3680 & 8.40 & 0.000\end{array}\end{array}
Dependent Variable is sales
Predictor
Constant
Price
Advertising
Coef
90.19
−
0.03055
3.0926
SE Coef
25.08
0.01005
0.3680
T
3.60
−
3.04
8.40
P
0.001
0.005
0.000
Question 27
Multiple Choice
Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. Using the output below, estimate The number of units sold on average at a store that sells the Sony Bravia for $2199 And spends 10% of its advertising budget on the product.
Dependent Variable is Sales
Predictor
Coef
SE Coef
T
P
Constant
90.19
25.08
3.60
0.001
Price
−
0.03055
0.01005
−
3.04
0.005
Advertising
3.0926
0.3680
8.40
0.000
\begin{array}{l}\text { Dependent Variable is Sales }\\\begin{array} { l r r r r } \text { Predictor } & \text { Coef } & \text { SE Coef } & \text { T } & \text { P } \\\text { Constant } & 90.19 & 25.08 & 3.60 & 0.001 \\\text { Price } & - 0.03055 & 0.01005 & - 3.04 & 0.005 \\\text { Advertising } & 3.0926 & 0.3680 & 8.40 & 0.000\end{array}\end{array}
Dependent Variable is Sales
Predictor
Constant
Price
Advertising
Coef
90.19
−
0.03055
3.0926
SE Coef
25.08
0.01005
0.3680
T
3.60
−
3.04
8.40
P
0.001
0.005
0.000
Question 28
Multiple Choice
Selling price and amount spent advertising were entered into a multiple regression to determine what affects flat panel LCD TV sales. The correct null and alternative Hypotheses for testing the regression coefficient of Price is