statistics report: regression and hypothesis testing for the dependent and independent things that effects the topic

profilealsh3
copy_of_regression_data.xls
Home>Business & Finance homework help>Economics homework help>statistics report: regression and hypothesis testing for the dependent and independent things that effects the topic

Sheet1

Prof Gender Aplia ApliaScore Pre-Test Post-Test Performance CGPA CECH Standing
1 2 1 179 1 11 83 3.04 55 2
1 2 1 161 8 19 92 3 38 2
1 2 1 169 12 24 100 3.71 24 1
1 2 1 43 7 9 17 2.05 48 2
1 2 1 90 11 12 8 2.32 40 2
1 2 1 153 5 16 92 2.73 19 1
1 2 1 161 8 19 92 2.88 38 2
1 2 1 111 7 15 67 2.46 9 1
1 2 1 102 9 12 25 2.59 40 2
1 2 1 123 10 12 17 2.53 79 3
1 2 1 61 6 17 92 3.19 22 1
1 2 1 177 7 12 42 2.75 12 1
1 2 1 72 6 13 58 2.94 21 1
1 2 1 82 7 8 8 0 1
1 2 1 96 6 9 25 0 1
1 2 1 95 13 18 42 2.29 31 2
1 2 1 146 4 14 83 2.8 71 3
1 1 1 160 5 11 33 2.74 47 2
1 1 1 165 8 10 11 3.06 33 2
1 1 1 188 14 16 11 3.67 12 1
1 1 1 143 7 14 39 3.37 38 2
1 1 1 159 12 15 17 3.33 50 2
1 1 1 121 11 15 22 3.08 42 2
1 1 1 79 7 13 33 2.44 52 2
1 1 1 85 7 25 100 3.14 15 1
1 1 1 119 10 14 22 3.2 27 1
1 1 1 130 7 9 11 2.68 18 1
1 1 1 89 7 15 44 2.47 57 2
1 1 1 162 8 15 39 3.67 12 1
1 1 1 140 6 11 28 3.07 51 2
1 1 1 91 7 15 44 3.06 16 1
1 1 1 181 14 23 50 4 15 1
1 1 1 123 9 20 61 3.63 37 2
1 1 1 127 8 11 17 2.4 15 1
1 1 1 188 8 16 44 3.5 33 2
1 1 1 178 11 14 17 3.39 30 1
1 1 1 139.5 10 12 12 1.99 57 2
1 1 1 168 11 15 24 2.32 12 1
1 1 1 120.5 9 19 59 3.79 19 1
1 1 1 140 6 17 65 3.85 41 2
1 1 1 124.5 3 16 76 3.7 3 1
1 1 1 144 4 21 100 3.85 31 2
1 1 1 107 8 19 65 2.58 53 2
1 1 1 120.5 3 9 35 2.89 26 1
1 1 0 0 10 14 24 2.61 71 3
1 1 1 81 7 8 6 3.05 29 1
1 1 0 0 7 10 18 2.46 63 3
1 1 1 51 8 10 12 2.58 103 4
1 1 0 0 8 17 53 3.16 35 2
1 1 1 161 10 15 29 3.28 42 2
1 2 0 0 10 13 21 2.58 22 1
1 2 0 0 9 14 36 3.76 27 1
1 2 0 0 16 20 29 1.88 9 1
1 2 1 73.5 5 16 79 2.1 55 2
1 2 0 0 7 18 79 2.56 18 1
1 2 0 0 11 23 86 3.92 12 1
1 2 0 0 6 12 43 2.95 18 1
1 2 0 0 5 17 86 3.23 25 1
1 2 0 0 5 10 36 2.42 12 1
1 2 1 164 7 13 43 2.39 13 1
1 2 1 100.33 9 14 36 3.01 16 1
1 2 0 9 15 43 2.42 66 3
1 2 1 147 10 14 29 2.94 42 2
1 2 1 50 6 20 100 1.95 56 2
1 2 1 53 9 15 43 2.22 36 2
1 2 1 170 13 19 43 3.73 40 2
1 2 1 158.67 14 20 43 3.74 31 2
1 2 1 101 6 11 36 1.93 16 1
2 1 1 105 6 10 24 2.76 35 2
2 1 1 154 7 24 100 2.81 28 1
2 1 1 112 12 15 18 2.87 68 3
2 1 1 170 8 21 76 3.34 32 2
2 1 1 139 7 12 29 3.18 52 2
2 1 1 42 8 13 29 2.48 42 2
2 1 1 204 11 21 59 4 31 2
2 1 1 94 17 24 41 3.32 108 4
2 1 1 121 6 15 53 2.88 48 2
2 1 1 207 12 14 12 3.79 16 1
2 1 1 101 7 17 59 3.97 30 1
2 1 1 185 14 14 0 2.5 114 4
2 2 1 79 14 19 56 1.95 30 1
2 2 1 73 12 16 44 2.86 25 1
2 2 1 178 7 12 56 3.03 42 2
2 2 1 147 20 28 89 3.35 12 1
2 2 1 162 9 16 78 3.25 12 1
2 2 1 109 4 7 33 3.7 3 1
2 2 1 121 16 20 44 3.06 18 1
2 2 1 87 8 9 11 3.3 3 1
2 2 1 166 6 15 100 2.43 42 2
2 2 1 195 11 17 67 3.02 15 1
2 2 1 0 15 17 22 3.04 30 1
2 1 1 151 4 7 23 2.5 16 1
2 1 1 0 4 15 85 2.1 15 1
2 1 1 130 5 9 31 2.72 15 1
2 1 1 53 7 13 46 3.54 15 1
2 1 1 87 9 12 23 3 6 1
2 1 0 0 3 16 100 2.48 26 1
2 1 1 115 7 9 15 2.15 6 1
2 1 1 53 3 14 85 2.3 6 1
2 1 1 131 6 12 46 2.07 23 1

Sheet2

Performance Gender ApliaScore CGPA
83 2 179 3.04 SUMMARY OUTPUT
92 2 161 3
100 2 169 3.71 Regression Statistics
17 2 43 2.05 Multiple R 0.3209442553
8 2 90 2.32 R Square 0.103005215
92 2 153 2.73 Adjusted R Square 0.0740698993
92 2 161 2.88 Standard Error 27.114293653
67 2 111 2.46 Observations 97
25 2 102 2.59
17 2 123 2.53 ANOVA
92 2 61 3.19 df SS MS F Significance F
42 2 177 2.75 Regression 3 7851.43127799 2617.14375933 3.5598441794 0.0172285839
58 2 72 2.94 Residual 93 68372.1975879894 735.184920301
42 2 95 2.29 Total 96 76223.6288659794
83 2 146 2.8
33 1 160 2.74 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
11 1 165 3.06 Intercept -3.099288042 18.249061873 -0.1698327324 0.8655105773 -39.3383082195 33.1397321354 -39.3383082195 33.1397321354
11 1 188 3.67 Gender 16.482454343 5.6648106743 2.9096213961 0.0045269795 5.233263028 27.731645658 5.233263028 27.731645658
39 1 143 3.37 ApliaScore -0.0161210502 0.0498606719 -0.3233219613 0.747177315 -0.1151344629 0.0828923624 -0.1151344629 0.0828923624
17 1 159 3.33 CGPA 9.5502878731 5.2821943642 1.8080152328 0.0738365134 -0.9391032791 20.0396790253 -0.9391032791 20.0396790253
22 1 121 3.08
33 1 79 2.44
100 1 85 3.14
22 1 119 3.2
11 1 130 2.68
44 1 89 2.47
39 1 162 3.67
28 1 140 3.07
44 1 91 3.06
50 1 181 4
61 1 123 3.63
17 1 127 2.4
44 1 188 3.5
17 1 178 3.39
12 1 139.5 1.99
24 1 168 2.32
59 1 120.5 3.79
65 1 140 3.85
76 1 124.5 3.7
100 1 144 3.85
65 1 107 2.58
35 1 120.5 2.89
24 1 0 2.61
6 1 81 3.05
18 1 0 2.46
12 1 51 2.58
53 1 0 3.16
29 1 161 3.28
21 2 0 2.58
36 2 0 3.76
29 2 0 1.88
79 2 73.5 2.1
79 2 0 2.56
86 2 0 3.92
43 2 0 2.95
86 2 0 3.23
36 2 0 2.42
43 2 164 2.39
36 2 100.33 3.01
29 2 147 2.94
100 2 50 1.95
43 2 53 2.22
43 2 170 3.73
43 2 158.67 3.74
36 2 101 1.93
24 1 105 2.76
100 1 154 2.81
18 1 112 2.87
76 1 170 3.34
29 1 139 3.18
29 1 42 2.48
59 1 204 4
41 1 94 3.32
53 1 121 2.88
12 1 207 3.79
59 1 101 3.97
0 1 185 2.5
56 2 79 1.95
44 2 73 2.86
56 2 178 3.03
89 2 147 3.35
78 2 162 3.25
33 2 109 3.7
44 2 121 3.06
11 2 87 3.3
100 2 166 2.43
67 2 195 3.02
22 2 0 3.04
23 1 151 2.5
85 1 0 2.1
31 1 130 2.72
46 1 53 3.54
23 1 87 3
100 1 0 2.48
15 1 115 2.15
85 1 53 2.3
46 1 131 2.07

Sheet3

Performance Gender Aplia CGPA Prof Standing
83 2 1 3.04 1 2 SUMMARY OUTPUT
92 2 1 3 1 2
100 2 1 3.71 1 1 Regression Statistics
17 2 1 2.05 1 2 Multiple R 0.3501762388
8 2 1 2.32 1 2 R Square 0.1226233982
92 2 1 2.73 1 1 Adjusted R Square 0.0749398873
92 2 1 2.88 1 2 Standard Error 26.9642067169
67 2 1 2.46 1 1 Observations 98
25 2 1 2.59 1 2
17 2 1 2.53 1 3 ANOVA
92 2 1 3.19 1 1 df SS MS F Significance F
42 2 1 2.75 1 1 Regression 5 9348.6827558341 1869.7365511668 2.5716100966 0.0317911091
58 2 1 2.94 1 1 Residual 92 66890.2968360027 727.0684438696
42 2 1 2.29 1 2 Total 97 76238.9795918368
83 2 1 2.8 1 3
33 1 1 2.74 1 2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
11 1 1 3.06 1 2 Intercept 1.9957312698 23.6606035954 0.0843482822 0.9329627996 -44.9962697819 48.9877323214 -44.9962697819 48.9877323214
11 1 1 3.67 1 1 Gender 15.8601951087 5.7801813641 2.743892295 0.0072995097 4.380255992 27.3401342254 4.380255992 27.3401342254
39 1 1 3.37 1 2 Aplia -1.7120013723 8.3451376927 -0.2051495656 0.8379084944 -18.286165157 14.8621624123 -18.286165157 14.8621624123
17 1 1 3.33 1 2 CGPA 8.3931427441 5.0527353366 1.6611087233 0.1000959476 -1.6420257711 18.4283112593 -1.6420257711 18.4283112593
22 1 1 3.08 1 2 Prof 4.5486017676 6.0211266838 0.7554403032 0.4519146056 -7.4098755517 16.507079087 -7.4098755517 16.507079087
33 1 1 2.44 1 2 Standing -4.5155706906 3.7844133202 -1.1932023034 0.2358581731 -12.0317422035 3.0006008223 -12.0317422035 3.0006008223
100 1 1 3.14 1 1
22 1 1 3.2 1 1
11 1 1 2.68 1 1
44 1 1 2.47 1 2
39 1 1 3.67 1 1
28 1 1 3.07 1 2
44 1 1 3.06 1 1
50 1 1 4 1 1
61 1 1 3.63 1 2
17 1 1 2.4 1 1
44 1 1 3.5 1 2
17 1 1 3.39 1 1
12 1 1 1.99 1 2
24 1 1 2.32 1 1
59 1 1 3.79 1 1
65 1 1 3.85 1 2
76 1 1 3.7 1 1
100 1 1 3.85 1 2
65 1 1 2.58 1 2
35 1 1 2.89 1 1
24 1 0 2.61 1 3
6 1 1 3.05 1 1
18 1 0 2.46 1 3
12 1 1 2.58 1 4
53 1 0 3.16 1 2
29 1 1 3.28 1 2
21 2 0 2.58 1 1
36 2 0 3.76 1 1
29 2 0 1.88 1 1
79 2 1 2.1 1 2
79 2 0 2.56 1 1
86 2 0 3.92 1 1
43 2 0 2.95 1 1
86 2 0 3.23 1 1
36 2 0 2.42 1 1
43 2 1 2.39 1 1
36 2 1 3.01 1 1
43 2 0 2.42 1 3
29 2 1 2.94 1 2
100 2 1 1.95 1 2
43 2 1 2.22 1 2
43 2 1 3.73 1 2
43 2 1 3.74 1 2
36 2 1 1.93 1 1
24 1 1 2.76 2 2
100 1 1 2.81 2 1
18 1 1 2.87 2 3
76 1 1 3.34 2 2
29 1 1 3.18 2 2
29 1 1 2.48 2 2
59 1 1 4 2 2
41 1 1 3.32 2 4
53 1 1 2.88 2 2
12 1 1 3.79 2 1
59 1 1 3.97 2 1
0 1 1 2.5 2 4
56 2 1 1.95 2 1
44 2 1 2.86 2 1
56 2 1 3.03 2 2
89 2 1 3.35 2 1
78 2 1 3.25 2 1
33 2 1 3.7 2 1
44 2 1 3.06 2 1
11 2 1 3.3 2 1
100 2 1 2.43 2 2
67 2 1 3.02 2 1
22 2 1 3.04 2 1
23 1 1 2.5 2 1
85 1 1 2.1 2 1
31 1 1 2.72 2 1
46 1 1 3.54 2 1
23 1 1 3 2 1
100 1 0 2.48 2 1
15 1 1 2.15 2 1
85 1 1 2.3 2 1
46 1 1 2.07 2 1