Please review the Regression Excel output below and then answer the following qu
ID: 3341142 • Letter: P
Question
Please review the Regression Excel output below and then answer the following questions:
Write down the regression model in proper form.
Interpret the slope coefficient for the predictor variable “Prevent Attacks”
Which of the following three predictor variables if any are predictive of “Perceived Riskiness of Flying (Y)”? Please use the p-value criterion with alpha of .05 level. Also use the confidence interval criterion at 95% level.
Please report R2 and provide an interpretation.
Assume the values for “Passengers Lost” = 40, “Prevent Attacks” = 1 and “Minimize Harm” = 1. What is your prediction for Y?
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.308
R Square
0.095
Adjusted R Square
0.072
Standard Error
1.731
Observations
122.000
ANOVA
df
SS
MS
F
Significance F
Regression
3.000
36.929
12.310
4.109
0.008
Residual
118.000
353.497
2.996
Total
121.000
390.426
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
4.916
0.616
7.980
0.000
3.696
6.135
Passengers Lost
-0.001
0.002
-0.615
0.540
-0.004
0.002
Prevent Attacks
-0.405
0.119
-3.415
0.001
-0.640
-0.170
Minimize Harm
0.137
0.101
1.359
0.177
-0.063
0.337
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.308
R Square
0.095
Adjusted R Square
0.072
Standard Error
1.731
Observations
122.000
ANOVA
df
SS
MS
F
Significance F
Regression
3.000
36.929
12.310
4.109
0.008
Residual
118.000
353.497
2.996
Total
121.000
390.426
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
4.916
0.616
7.980
0.000
3.696
6.135
Passengers Lost
-0.001
0.002
-0.615
0.540
-0.004
0.002
Prevent Attacks
-0.405
0.119
-3.415
0.001
-0.640
-0.170
Minimize Harm
0.137
0.101
1.359
0.177
-0.063
0.337
Explanation / Answer
Perceved Riskiness of Flying Y = 4.916 - 0.001 Passenger - 0.405Prevent attack +0.137 Minimize Harm
The slope of the prevent attack is -0.405 which is < 0, so it is negative correlation between prevent attack and Perceived Riskiness of Flying.
If prevent attack is increase 1 unit then Perceived Riskness of Flying is decreased 0.405
P-value of attack 0.01 < alpha 0.05, so it is significant
It Confidence interval is (-0.642,-0.170)
R^2 = 0.095 = 9.5% of variation in Perceved Riskiness of Flying Y can be explained by Prevent attacks, passneger los and inize harm
The prediction of Y is Y = 4.916 - 0.001 *40 - 0.405*1 +0.137 *1=3.888
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.