0% found this document useful (0 votes)
21 views10 pages

Study Hours vs. Points Analysis

The document presents data on hours spent studying and corresponding points earned, along with regression statistics indicating a strong correlation (Multiple R = 0.91) between study hours and points. It also includes analysis of the relationship between distance to work and days absent, showing a weaker correlation (Multiple R = 0.25). Overall, the data suggests that increased study time is associated with higher points earned, while distance to work has a lesser impact on absenteeism.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
21 views10 pages

Study Hours vs. Points Analysis

The document presents data on hours spent studying and corresponding points earned, along with regression statistics indicating a strong correlation (Multiple R = 0.91) between study hours and points. It also includes analysis of the relationship between distance to work and days absent, showing a weaker correlation (Multiple R = 0.25). Overall, the data suggests that increased study time is associated with higher points earned, while distance to work has a lesser impact on absenteeism.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Hours Spent Studying Total Points Earned

22 12
20 18
29 25
24 25
43 28
46 29
39 35
40 39
51 40
43 43
39 43
51 49
52 50
65 51
57 53
56 53
52 55
66 55
63 57
68 57
67 59
42 59
65 59
69 60 SUMMARY OUTPUT
72 60
66 61 Regression Statistics
53 61 Multiple R 0.9097859631
45 61 R Square 82.77%
58 62 Adjusted R Square 0.8265917356
81 62 Standard Error 7.177298036
60 62 Observations 156
57 62
77 62 ANOVA
78 63 df SS
67 64 Regression 1 38112.0519428
78 64 Residual 154 7933.09549309
72 64 Total 155 46045.1474359
58 64
71 65 Coefficients Standard Error
76 65 Intercept 8.674 2.44769743405
79 66 Hours Spent Studying 0.801 0.02946251738
83 66
65 66
72 66
71 66
52 67
78 67
70 67
81 67
80 68
79 68
72 68
75 68
91 68
65 68
84 69
77 69
78 70
72 70
84 70
83 70
67 70
80 71
78 71
72 72
70 72
94 72
92 72
84 73
98 73
78 73
78 73
84 73
74 74
90 74
83 74
84 74
83 75
78 75
93 75
80 75
101 76
81 76
83 76
91 76
83 76
93 76
78 76
78 77
65 77
84 77
97 77
88 77
93 78
93 78
95 78
95 79
91 79
95 79
94 79
95 80
102 80
105 80
83 80
99 80
97 81
79 81
101 81
88 82
93 83
95 85
94 85
104 85
88 85
80 86
98 86
83 86
91 86
90 87
83 87
92 88
88 88
99 89
101 90
101 90
99 90
102 90
84 90
110 91
93 91
105 91
109 91
91 92
104 92
95 92
98 92
91 93
104 93
104 94
106 95
95 95
106 95
92 95
101 96
95 96
109 96
95 96
101 96
105 97
104 97
104 97
105 98
95 99
109 100
110 100
101 100
MS F Significance F
38112.051943 739.8443652 1.096192E-60
51.513607098

t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
3.5438303646 0.0005223847 3.838827439 13.509621541 3.838827439 13.509621541
27.200080243 1.096192E-60 0.7431799857 0.8595856882 0.7431799857 0.8595856882
Distance to Number of
Work (miles) Days Absent
6.3 11
14.3 7 SUMMARY OUTPUT
8.8 0
17.4 14 Regression Statistics
8.5 4 Multiple R 0.25212793
7.4 4 R Square 6.4%
4.3 6 Adjusted R S 0.05401307
7.6 8 Standard Erro 5.70626354
2.7 23 Observations 100
3.3 5
18.7 1 ANOVA
6.3 5 df SS MS F
13.8 1 Regression 1 216.618534 216.618534 6.65260843
14.5 12 Residual 98 3191.02147 32.5614435
16.6 0 Total 99 3407.64
14.1 14
2.9 8 CoefficientsStandard Error t Stat P-value
4.5 9 Intercept 10.6577574 1.19828483 8.89417706 3.03113E-14
19.6 13 Distance to W-0.25559649 0.09909663 -2.57926509 0.01138663
7.5 3
8.6 18
8.6 10
18.9 3 RESIDUAL OUTPUT
10.7 2
3.1 0 Observation
Predicted Number of DaysResiduals
Absent
19.7 4 1 9.04749958 3.95250042
10.7 15 2 7.00272768 1.99727232
18 11 3 8.40850836 -7.40850836
2.7 10 4 6.21037857 7.78962143
4.7 6 5 8.48518731 -4.48518731
8 7 6 8.76634344 -4.76634344
4.8 9 7 9.55869255 -3.55869255
4 7 8 8.71522414 -0.71522414
4.1 16 9 9.96764693 13.0323531
5.1 5 10 9.81428904 -4.81428904
3.8 4 11 5.87810314 -4.87810314
7.5 21 12 9.04749958 -4.04749958
15.7 7 13 7.13052593 -6.13052593
14.5 9 14 6.95160839 5.04839161
1 8 15 6.41485576 -6.41485576
13.9 11 16 7.05384698 6.94615302
17.7 7 17 9.91652763 -1.91652763
18.7 2 18 9.50757325 -0.50757325
5.2 3 19 5.6480663 7.3519337
17 4 20 8.74078379 -5.74078379
10.9 2 21 8.45962766 9.54037234
9.3 13 22 8.45962766 1.54037234
4.3 1 23 5.82698384 -2.82698384
9.8 8 24 7.92287504 -5.92287504
8.5 15 25 9.86540833 -9.86540833
17.2 3 26 5.62250665 -1.62250665
15.7 5 27 7.92287504 7.07712496
1.1 8 28 6.05702068 4.94297932
16.4 7 29 9.96764693 0.03235307
0.9 4 30 9.45645396 -3.45645396
10.6 5 31 8.61298555 -1.61298555
9.9 5 32 9.43089431 -0.43089431
15.8 5 33 9.6353715 -2.6353715
9.1 3 34 9.60981185 6.39018815
15.7 3 35 9.35421536 -4.35421536
18.6 2 36 9.68649079 -5.68649079
7.3 3 37 8.74078379 12.2592162
18.6 7 38 6.6448926 0.3551074
12.2 3 39 6.95160839 2.04839161
1.1 19 40 10.402161 -2.40216096
18.2 1 41 7.10496628 3.89503372
19.7 8 42 6.13369963 0.86630037
18.8 16 43 5.87810314 -3.87810314
10.2 0 44 9.32865571 -6.32865571
20.2 2 45 6.31261717 -2.31261717
8.9 3 46 7.87175574 -5.87175574
13.7 0 47 8.28071012 4.71928988
7 10 48 9.55869255 -8.55869255
3.3 7 49 8.15291187 -0.15291187
17.4 8 50 8.48518731 6.51481269
10.6 11 51 6.26149787 -3.26149787
2.2 24 52 6.6448926 -1.6448926
8.3 13 53 10.3766013 -2.37660131
12.3 14 54 6.46597506 0.53402494
17.3 1 55 10.4277206 -6.42772061
9.8 16 56 7.94843468 -2.94843468
13.8 8 57 8.12735222 -3.12735222
0.8 13 58 6.61933295 -1.61933295
12.5 7 59 8.33182941 -5.33182941
10.5 11 60 6.6448926 -3.6448926
16.9 14 61 5.90366279 -3.90366279
8 3 62 8.79190309 -5.79190309
9.2 21 63 5.90366279 1.09633721
11.2 17 64 7.53948031 -4.53948031
20.3 7 65 10.3766013 8.62339869
2.9 19 66 6.00590138 -5.00590138
1.7 18 67 5.62250665 2.37749335
20.4 0 68 5.85254349 10.1474565
7.5 16 69 8.05067328 -8.05067328
11.7 0 70 5.49470841 -3.49470841
4.9 3 71 8.38294871 -5.38294871
10 11 72 7.15608558 -7.15608558
10.3 3 73 8.86858204 1.13141796
19.8 12 74 9.81428904 -2.81428904
14.2 4 75 6.21037857 1.78962143
76 7.94843468 3.05156532
77 10.0954452 13.9045548
78 8.5363066 4.4636934
79 7.51392066 6.48607934
80 6.23593822 -5.23593822
81 8.15291187 7.84708813
82 7.13052593 0.86947407
83 10.4532803 2.54671975
84 7.46280136 -0.46280136
85 7.97399433 3.02600567
86 6.33817682 7.66182318
87 8.61298555 -5.61298555
88 8.30626977 12.6937302
89 7.79507679 9.20492321
90 5.46914876 1.53085124
91 9.91652763 9.08347237
92 10.2232434 7.77675658
93 5.44358911 -5.44358911
94 8.74078379 7.25921621
95 7.66727855 -7.66727855
96 9.40533466 -6.40533466
97 8.10179258 2.89820742
98 8.02511363 -5.02511363
99 5.59694701 6.40305299
100 7.02828733 -3.02828733
Distance to Work (miles) Residua
Plot
20
10

Residuals
0
-10 0 5 10 15 20
-20
Significance F Distance to Work (miles)
0.01138663

Distance to Work (miles) Line Fit P


Number of Days Absent
Lower 95% Upper 95% Lower 95.0% Upper 95.0% 30
8.2798002 13.0357147 8.2798002 13.0357147
20 Number of D
-0.45225053 -0.05894244 -0.45225053 -0.05894244 Predicted Nu
10 Absent
0
0 5 10 15 20 25
Distance to Work (miles)
ork (miles) Residual
Plot

10 15 20 25

ance to Work (miles)

k (miles) Line Fit Plot

Number of Days Absent


Predicted Number of Days
Absent

20 25
miles)

You might also like