1. Perform an ANOVA on the data provided to answer the following questions (20 points).
a. Does GPA differ by the grade level?
b. Does the average number of discipline referrals differ by GPA?
B C E F G Gender Id Number of Disipline Referrals Student GPA Excused Absences Unexcused Absences Grade Level 2 13 14 3.3 10 3 F 5 2.2 9 IF 3.1 5 M 18 12 2.7 17 6 F 19 27 3.3 4 7 F 11 10 2.4 16 8 F 13 18 3.2 7 10 M 14 23 1.8 12 10 12 10 18 1.8 15 21 13 2.4 12 22 19 1.3 12 13 M 23 1.9 19 M 25 20 2.6 17 15 27 13 3.7 17 16 28 3.7 16 17 29 16 3.1 18 18 F 30 128 3.9 19 31 24 2 20 M 33 18 1.2 14 21 but 37 26 3 1 22 M 38 27 3.2 23 M 39 10 1.3 13 24 F 42 12 1.8 15 25 F 148 17 3.8 26 149 16 1.5 11 27 M 52 30 2.8 14 28 F 55 25 1.6 12 29 M 57 25 2 4 30 M 59 19 2.7 16 31 My 60 26 3.1 16 32 65 2 3.8 12 33 M 66 15 1.2 2 34 M 73 15 3.9 4 35 174 30 3.9 12 36 F 175 19 1.3 19 37 F 81 1 2.3 15 36 M 184 30 3.7 6 39 F 85 17 1.2 12 40 M 87 22 1.3 11 co 41 F 88 11 3.8 19 42 F 89 26 2.2 10A B C 43 M 94 9 E 44 M 1.5 F G 99 18 13 45 F 1.8 100 25 |19 46 F 2.2 18 101 7 47 F 2.7 102 1 19 48 M 3.4 105 17 49 F 3.5 107 9 20 50 M 13 111 23 15 51 M 1.6 112 25 52 F 1.3 120 129 17 53 M 2.1 121 13 3 54 M 122 3.9 23 11 55 M 19 123 18 17 56 F 1.2 125 6 14 57 M 3.5 126 19 15 58 F 1.1 129 17 |17 59 F 1.2 130 10 12 60 M 131 2.8 17 10 14 61 F 15 132 7 7 6 62 M 135 2.7 29 15 63 M 137 11 3.6 16 64 M 3.9 139 16 5 3.1 65 140 15 17 66 M 3.3 19 145 20 67 M 2.7 147 68 2.5 150 13 13 69 F 151 3.7 24 17 70 M 2.7 155 13 6 71 M 3.1 160 12 18 72 M 2 161 14 11 4 73 F 162 17 4 19 74 F 1.8 163 1 10 75 M 165 3.5 17 8 76 F 167 3.3 8 10 77 M 1.2 168 12 78 M 2 170 28 13 79 F 173 1.7 20 80 M 3.7 175 27 19 81 3.9 178 26 11 82 F 3 185 20 6 83 M 2.7 187 28 84 F 1.6 186 12 35 M 1.4 189 24 3.3A C E 85 M F 189 24 G 3.3 86 M 5 190 127 |3.1 13 87 191 15 1.2 86 M 193 22 |1.8 89 F 197 15 3.4 19 90 M 200 14 14 91 M 92 29 3.9 1 92 F 35 15 1.8 9 93 M 128 12 2.7 20 94 M 195 26 2.2 11 95 M 23 2.4 7 96 M 7 17 4 97 M 20 51 1 2.5 14 98 M 77 21 2.9 19 99 M 141 24 1.6 11 100 F 171 13 2.7 20 101 M 64 20 2.8 18 102 F 78 23 3.5 14 103 F 96 17 1.7 13 104 F 108 28 3.3 7 105 M 114 10 13.4 20 106 F 166 20 2.7 16 107 F 20 2.5 108 M 10 120 1.3 11 109 F 45 126 F 3.2 6 62 123 2.5 17 171 F 67 25 2.9 4 112 M 68 19 3.1 113 F 20 118 7 2.9 15 114 F 127 19 F 3.6 4 115 134 20 F 2.7 19 138 24 3 |15 117 M 144 19 2.2 14 118 M 194 12 1.5 119 F 15 14 2.9 14 120 F 12 30 1.8 18 121 M 15 11 3.7 122 M 6 16 18 13.4 | 11 123 M 17 19 2.6 124 M 1 19 15 17 1.1 18 125 F 20 11 3.4 ) -1 126 M 24 13 3.2 127 F 26 1.8 17 128 F 37129 F 34 19 130 F 36 14 2.7 2 131 F 40 3.8 13 132 M 41 2.3 16 133 F 43 3.6 18 134 M 44 2 1.4 6 135 46 1 2.5 17 136 47 30 3.7 14 137 50 23 2.5 13 18 138 F 2 53 20 1.6 15 1.1 3 139 M 54 4 17 140 F 3.7 10 56 20 16 141 F 58 24 3.3 4 17 142 F 61 122 3.2 5 143 F 63 15 13.7 11 144 M 69 14 2.2 6 145 F 70 3.9 6 20 146 F 71 17 3.1 8 147 F 1.9 10 72 28 12 148 F 76 14 13.1 12 149 F 79 6 3.4 10 150 M 80 12 2.3 8 151 F 82 19 2.3 20 152 M 15 83 14 2.2 7 153 F 86 14 2.9 8 154 F 6 06 19 12 155 M 191 28 1.4 13 156 F 93 29 2.7 4 18 157 F 8 95 15 1.4 4 158 M 97 3 2.6 3 159 M 98 24 1.5 12 13 160 F 13 103 22 3.6 19 161 F 104 8 162 M 2.9 12 106 1 17 163 F 109 28 1.3 2 164 F 2.8 10 110 25 14 165 M 7 113 6 2.7 15 166 F 115 20 2.5 10 167 M 9 116 12 2.4 168 F 8 117 20 2.9 11 169 F 119 30 1.5 17 170 M 124 1.8 12 10 3.8 15 GA B C D 170 M 124 E 10 F 3.8 G 171 F 15 133 24 172 M 1.1 20 10 136 7 173 F 2.8 13 6 142 19 174 F 3.5 143 2 13 3.5 175 F 12 146 29 176 |M 2.6 148 3 2 2 177 F 149 10 6 12 178 M 1.9 152 8 1 179 M 1.1 6 153 23 3.9 11 10 180 F 154 5 1 181 F 156 19 14 3 12 182 F 157 30 2.5 183 M 158 15 4 2.5 184 F 8 159 4 185 M 1.1 164 20 3.9 186 F 19 169 9 187 F 1.8 6 172 25 188 F 1.7 174 12 14 11 189 M 1.9 176 19 26 190 M 2.8 177 21 191 F 3.9 179 19 2.6 192 M 180 15 7 193 M 1.5 181 26 10 194 M 1.7 6 182 2 195 F 1 14 183 1 196 F 18 184 29 197 F 1.8 13 186 5 2.6 198 M 2 192 8 199 M 2.8 196 10 17 10 2.8 200 F 20 198 22 201 M 2.7 4 199 1 10 2.6 17 12 10 5
