Human Interaction And Problem solving

profileLionking
RegressionforMONDAY.xlsx
Home>Information Systems homework help>Human Interaction And Problem solving

VANN EX.

ACT Scores Test Average
21 88 Is there a relationship between ACT scores and test averages in _________class?
18 78
23 91
17 76
26 93
27 97
22 84
15 75
19 80
18 79
20 86
13 74
24 90
15 75
16 78
23 91
21 89
18 82
20 85

VANN EX. ANS

ACT Scores Test Average
21 88
18 78
23 91
17 76
26 93
27 97
22 84 SUMMARY OUTPUT
15 75
19 80 Regression Statistics
18 79 Multiple R 0.9577121814
20 86 R Square 0.9172126225
13 74 Adjusted R Square 0.9123427767
24 90 Standard Error 1.1277405111
15 75 Observations 19
16 78
23 91 ANOVA
21 89 df SS MS F Significance F
18 82 Regression 1 239.5373175119 239.5373175119 188.3453136024 0.0000000001
20 85 Residual 17 21.620577225 1.2717986603
Total 18 261.1578947368
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -24.1063881174 3.2089453612 -7.5122463625 0.0000008503 -30.8766710289 -17.3361052058 -30.8766710289 -17.3361052058
Test Average 0.5242120517 0.0381970297 13.7238957152 0.0000000001 0.4436233635 0.6048007399 0.4436233635 0.6048007399
(r [17] = .95, p < .01). There is a relationship between ACT scores and the test score.

Prac

Hours studying Number correct on 6 qs. Quiz
1 4
2 5
4 6

Prac ANS

Hours studying Number correct on 6 qs. Quiz SUMMARY OUTPUT
1 4
2 5 Regression Statistics
4 6 Multiple R 0.9819805061
R Square 0.9642857143
Adjusted R Square 0.9285714286
Answer: Standard Error 0.4082482905
Observations 3
(r [1] = .98, p > .05 ANOVA
There is no relationship between df SS MS F Significance F
studying and number correct. Regression 1 4.5 4.5 27 0.1210377183
This sample size was very small Residual 1 0.1666666667 0.1666666667
You want at least 30 in each Total 2 4.6666666667
group you examine to rule
out random chance. Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -5.1666666667 1.4624940646 -3.5327778702 0.1756097164 -23.7494156765 13.4160823431 -23.7494156765 13.4160823431
Number correct on 6 qs. Quiz 1.5 0.2886751346 5.1961524227 0.1210377183 -2.1679653624 5.1679653624 -2.1679653624 5.1679653624
RESIDUAL OUTPUT
Observation Predicted Hours studying Residuals
1 0.8333333333 0.1666666667
2 2.3333333333 -0.3333333333
3 3.8333333333 0.1666666667

Number correct on 6 qs. Quiz Residual Plot

4 5 6 0.16666666666666696 -0.33333333333333304 0.16666666666666785

Number correct on 6 qs. Quiz

Residuals

PPT EX

Subject Test A Test B
1 10 7
2 9 8
3 9 6
4 8 9
5 6 4
6 5 6
7 5 5
8 3 3
9 1 2

PPT ANS

Subject Test A Test B SUMMARY OUTPUT
1 10 7
2 9 8 Regression Statistics r [7] = .84, p < .01)
3 9 6 Multiple R 0.84137898 There was a correlation between
4 8 9 R Square 0.707918588 test A and test B.
5 6 4 Adjusted R Square 0.666192672
6 5 6 Standard Error 1.7519055147
7 5 5 Observations 9
8 3 3
9 1 2 ANOVA
df SS MS F Significance F
Regression 1 52.0713450292 52.0713450292 16.9659208449 0.0044653283
Residual 7 21.4842105263 3.0691729323
Total 8 73.5555555556
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.0526315789 1.6076587573 0.032738029 0.9747974224 -3.7488773068 3.8541404647 -3.7488773068 3.8541404647
Test B 1.1105263158 0.2696125699 4.1189708478 0.0044653283 0.4729938944 1.7480587372 0.4729938944 1.7480587372
RESIDUAL OUTPUT
Observation Predicted Test A Residuals
1 7.8263157895 2.1736842105
2 8.9368421053 0.0631578947
3 6.7157894737 2.2842105263
4 10.0473684211 -2.0473684211
5 4.4947368421 1.5052631579
6 6.7157894737 -1.7157894737
7 5.6052631579 -0.6052631579
8 3.3842105263 -0.3842105263
9 2.2736842105 -1.2736842105

Test B Line Fit Plot

Test A 7 8 6 9 4 6 5 3 2 10 9 9 8 6 5 5 3 1 Predicted Test A 7 8 6 9 4 6 5 3 2 7.8263157894736857 8.9368421052631604 6.7157894736842119 10.047368421052635 4.4947368421052634 6.7157894736842119 5.6052631578947372 3.3842105263157896 2.2736842105263153

Test B

Test A