In: Statistics and Probability
This is a computational problem that will cover questions A-L. Dr. Pam Wilson-Gomez is interested in determining if there is a significant relationship between x and y. She measured a person’s mood (x, 1=worst, 20=best) and the person’s creativity (y, 1=lowest, 15=highest).
Person's mood (x) |
Person's creativity (y) |
x2 |
y2 |
xy |
15 14 10 9 8 8 7 6 4 2 |
4 6 4 8 7 8 10 9 14 12 |
|||
Σx = |
Σy = |
Σx2 = |
Σy2 = |
Σxy= |
k) Calculate the regression equation for predicting scores on the person's creativity, based on the person's mood.
Group of answer choices
b (slope) is
[ Choose ] .689 x' = .689y - 13.919 13.919 2.206 25.632 -.689 y' = -.689x + 13.919
a (y intercept) is
[ Choose ] .689 x' = .689y - 13.919 13.919 2.206 25.632 -.689 y' = -.689x + 13.919
What is the equation?
[ Choose ] .689 x' = .689y - 13.919 13.919 2.206 25.632 -.689 y' = -.689x + 13.919
If x = 17, y' =
[ Choose ] .689 x' = .689y - 13.919 13.919 2.206 25.632 -.689 y' = -.689x + 13.919
L) Find the standard error of the estimate for y.
Group of answer choices
.795
4.772
1.560
Undetermined
Person's mood | Person's creativity | x2 | y2 | xy | |
(x) | (y) | ||||
15 | 4 | 225 | 16 | 60 | |
14 | 6 | 196 | 36 | 84 | |
10 | 4 | 100 | 16 | 40 | |
9 | 8 | 81 | 64 | 72 | |
8 | 7 | 64 | 49 | 56 | |
8 | 8 | 64 | 64 | 64 | |
7 | 10 | 49 | 100 | 70 | |
6 | 9 | 36 | 81 | 54 | |
4 | 14 | 16 | 196 | 56 | |
2 | 12 | 4 | 144 | 24 | |
Sum | 83 | 82 | 835 | 766 | 580 |
Σx = 83, Σy = 82, Σx2 = 835, Σy2 = 766, Σxy= 580
Using Excel, go to Data, select Data Analysis, choose Regression
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.957 | ||||
R Square | 0.916 | ||||
Adjusted R Square | 0.907 | ||||
Standard Error | 6.977 | ||||
Observations | 11 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 4780.822 | 4780.822 | 98.217 | 0.000 |
Residual | 9 | 438.087 | 48.676 | ||
Total | 10 | 5218.909 | |||
Coefficients | Standard Error | t Stat | P-value | ||
Intercept | 0.577 | 2.563 | 0.225 | 0.827 | |
X | 0.973 | 0.098 | 9.910 | 0.000 |
Regression equation: y = 0.577 + 0.973x
slope = 0.973
y intercept = 0.577
If x = 17, y' = 0.577 + 0.973*17 = 17.118
Standard Error = 6.977