Q. Given below is information on car class (compact, midsize or large), displacement, fuel type (premium or regular) and highway MPG. a. Come up with a regression equation. b. Interpret the coefficients of the variables. c. Is the model significant? d. Which of the variables are significant? e. Predict the Hwy MPG for a car that is a compact, has a displacement of 3.1 and uses regular fuel. Class Displacement Fuel Type Hwy MPG 1 Compact 3.1 P. 25 2. Compact 3.1 25 Compact 3 P 25 Compact 3 P. 25 5 Compact 3 25 6 Compact 3 P 25 7 Compact 2.4 25 8 Compact 3.5 25 9 Compact 3 P 25 10 Compact 2.4 P 24 Compact 2.8 P 24 12 Compact 2.5 24 13 Compact 3 P 24 14 Compact 2.5 P 24 15 Compact 2.4 R 24 16 Compact 5.3 P 24 Compact 6 P 24 18 Compact 3.5 R 24 19 Compact 3.5 R 24 20 Compact 3.5 R 24 21 Compact 3.5 R 24 22 Compact 3.5 R 24 23 Compact 3.8 R 24 24 Compact 3.5 R 24 25 Compact 3.5 P 24 26 Compact 5.3 P 24 27 Compact 4.6 P 24 28 Compact 3.5 P 24 29 Compact 4.2 P 24 30 Compact 4.6 P 24 31 Compact 4.6 P 24 32 Compact 4.6 24 33 Compact 3.5 24 34 Compact 3.6 P 24 35 Compact 3.2 P 24 36 Compact 3.2 P 24 37 Compact 3.5 R 24 38 Compact 2.4 R 24 39 Compact 3.5 R 24 40 Compact 3.5 R 24 41 Compact 3.2 P 23 42 Compact 4.2 23 43 Compact 4.8 23 4.8 P 23 44 Compact P 45 3.5 23 Compact 4.6 R 23 46 Compact 4.6 R 23 47 Compact 5.7 R 23 48 Compact 78 Compact 4.5 P 21 79 Compact 5.5 P 21 80 Compact 4.6 P 21 81 Compact 4.2 P 20 82 Compact 4.2 P 20 83 Compact 6 20 84 Compact 4.5 20 85 Compact 5.5 P 20 86 Compact 6 19 87 Compact 5.2 19 88 Compact 5.2 19 89 Compact 4.4 P 19 90 Compact 5.5 19 91 Compact 6.2 19 92 Compact 6.2 P 18 93 Compact 6.2 18 94 Compact 6.1 18 95 Compact 6.1 18 96 Compact 4.6 R 18 97 Compact 4.6 R 18 98 Compact 6.1 P 18 99 Compact 5.5 P. 17 100 Compact 5.5 P 17 101 Compact 6.2 P 17 102 Compact 6 P 17 103 Compact 5.5 17 104 Compact 5 17 105 Compact 5 17 106 16 Compact 5.5 P 107 Compact 6 P 16 108 Compact 5.5 P 16 109 Compact P 16 110 Compact 5.7 P 16 111 Compact 5.7 P 15 112 Midsize 1.8 R 37 113 Midsize 2 R 35 114 Midsize 1.6 R 35 115 Midsize 1.8 R 35 116 Midsize 1.6 R 34 117 Midsize 2.4 R 34 118 Midsize 2 R 33 119 Midsize 1.6 R 33 120 Midsize 2 R 33 121 Midsize 2 R 33 122 Midsize 1.8 R 33 123 Midsize 2.5 R 33 124 Midsize 2 R 33 125 Midsize 1.6 R 32 126 Midsize 1.6 R 32 127 Midsize 1.6 R 32 128 Midsize 2 R 32 129 Midsize 2.4 R 32 130 Midsize 2 R 32 131 Midsize 1.8 R 32 132 Midsize 2.5 R 32 133 Midsize 2.4 32 134 Midsize 2 31 135 Midsize 2.4 R 31 136 Midsize 2 R 31 137 Midsize 2 R 31 138 Midsize 2.4 R 31 139 Midsize 2.4 R 31 140 Midsize 2.4 R. 31 141 Midsize 2.4 R 31 142 Midsize 2.4 31 143 Midsize 2.2 R 31 144 Midsize 2.4 R 31 145 Midsize 2.4 R 31 146 Midsize 2.5 R 31 147 Midsize 1.8 R 31 148 Midsize 2 R 31 149 Midsize 2.4 R 31 150 Midsize 2.4 R 31 151 Midsize 2 P 30 152 Midsize 2.4 R 30 153 Midsize 2.4 R 30 154 Midsize 2 R 30 155 Midsize 2.4 R 30 156 Midsize 2.4 R 30 157 Midsize 2.4 R 30 158 Midsize 2.4 R 30 159 Midsize 2 R 30 160 Midsize 2.5 R 30 161 Midsize 2.4 R 30 162 Midsize 2 P 29 163 Midsize 2 29 164 Midsize 2 P. 29 165 Midsize 2 P 29 166 Midsize 2 P 29 167 Midsize 2.3 R 29 168 Midsize 2.3 R 29 169 Midsize 2 R 29 170 Midsize 2 R 29 171 Midsize 3.5 R 29 172 Midsize 2.5 R 29 173 Midsize 2.5 R 29 174 Midsize 2.5 R 29 175 Midsize 2.5 R 29 176 Midsize 3.5 R 29 177 Midsize 3.5 R 29 178 Midsize 3.5 R 29 179 Midsize 2.5 P 29 180 Midsize 2 P 29 181 Midsize 3.5 R 29 182 Midsize 1.8 R 29 183 Midsize 2.4 R 29 184 Midsize 2.3 R 29 185 Midsize 2.3 R 29 186 Midsize 2.3 R 29 187 Midsize 3.5 R 29 188 Midsize 2.4 28 Midsize 2.4 189 28 28 P 190 Midsize 2 191 28 Midsize 3 P. 192 Midsize 3 P. 28 193 Midsize 2.5 P. 28 194 Midsize 2.5 28 195 Midsize 2.4 P 28 196 Midsize 2.4 28 197 Midsize 2.4 P 28 198 Midsize 2.4 P. 28 199 Midsize 3.5 R 28 200 Midsize 2 R 28 201 Midsize 2 R 28 202 Midsize 2 R 28 203 Midsize 2 R 28 204 Midsize 3.9 R 28 205 Midsize 3.5 R 28 206 Midsize 3.3 R 28 207 Midsize 3.5 R 28 208 Midsize 3.5 R 28 209 Midsize 3 28 210 Midsize 2.3 P 28 211 Midsize 2 P 28 212 Midsize 3.8 R 28 213 Midsize 3.5 R 28 214 Midsize 2.3 R 28 215 Midsize 2.7 R 28 216 Midsize 2.3 R 28 217 Midsize 3.5 R 28 218 Midsize 2.3 R 28 219 28 Midsize 3.8 220 28 R Midsize 3.5 221 Midsize 2 P 27 222 Midsize 3.1 P 27 223 Midsize 2.5 27 224 Midsize 2.5 P 27 225 Midsize 2.5 P 27 226 Midsize 2.5 27 227 Midsize 2.5 R 27 228 Midsize 2.5 R 27 229 Midsize 2.5 R 27 230 Midsize 2.5 27 231 Midsize 3.3 R 27 232 Midsize 3.5 P 27 233 Midsize 3.1 27 234 Midsize 3 P 27 235 Midsize 3.5 P 27 236 Midsize 3.5 27 237 Midsize 3.5 27 238 Midsize 2.7 R 27 239 Midsize 2.7 R 27 240 Midsize 2.7 R 27 241 Midsize 2 R 27 242 Midsize 2.7 R 27 243 Midsize 2.4 R 27 244 Midsize 3 R 26 245 Midsize 3 R 26 246 Midsize 3.6 R 26 Q. Given below is information on car class (compact, midsize or large), displacement, fuel type (premium or regular) and highway MPG. a. Come up with a regression equation. b. Interpret the coefficients of the variables. c. Is the model significant? d. Which of the variables are significant? e. Predict the Hwy MPG for a car that is a compact, has a displacement of 3.1 and uses regular fuel. Class Displacement Fuel Type Hwy MPG 1 Compact 3.1 P. 25 2. Compact 3.1 25 Compact 3 P 25 Compact 3 P. 25 5 Compact 3 25 6 Compact 3 P 25 7 Compact 2.4 25 8 Compact 3.5 25 9 Compact 3 P 25 10 Compact 2.4 P 24 Compact 2.8 P 24 12 Compact 2.5 24 13 Compact 3 P 24 14 Compact 2.5 P 24 15 Compact 2.4 R 24 16 Compact 5.3 P 24 Compact 6 P 24 18 Compact 3.5 R 24 19 Compact 3.5 R 24 20 Compact 3.5 R 24 21 Compact 3.5 R 24 22 Compact 3.5 R 24 23 Compact 3.8 R 24 24 Compact 3.5 R 24 25 Compact 3.5 P 24 26 Compact 5.3 P 24 27 Compact 4.6 P 24 28 Compact 3.5 P 24 29 Compact 4.2 P 24 30 Compact 4.6 P 24 31 Compact 4.6 P 24 32 Compact 4.6 24 33 Compact 3.5 24 34 Compact 3.6 P 24 35 Compact 3.2 P 24 36 Compact 3.2 P 24 37 Compact 3.5 R 24 38 Compact 2.4 R 24 39 Compact 3.5 R 24 40 Compact 3.5 R 24 41 Compact 3.2 P 23 42 Compact 4.2 23 43 Compact 4.8 23 4.8 P 23 44 Compact P 45 3.5 23 Compact 4.6 R 23 46 Compact 4.6 R 23 47 Compact 5.7 R 23 48 Compact 78 Compact 4.5 P 21 79 Compact 5.5 P 21 80 Compact 4.6 P 21 81 Compact 4.2 P 20 82 Compact 4.2 P 20 83 Compact 6 20 84 Compact 4.5 20 85 Compact 5.5 P 20 86 Compact 6 19 87 Compact 5.2 19 88 Compact 5.2 19 89 Compact 4.4 P 19 90 Compact 5.5 19 91 Compact 6.2 19 92 Compact 6.2 P 18 93 Compact 6.2 18 94 Compact 6.1 18 95 Compact 6.1 18 96 Compact 4.6 R 18 97 Compact 4.6 R 18 98 Compact 6.1 P 18 99 Compact 5.5 P. 17 100 Compact 5.5 P 17 101 Compact 6.2 P 17 102 Compact 6 P 17 103 Compact 5.5 17 104 Compact 5 17 105 Compact 5 17 106 16 Compact 5.5 P 107 Compact 6 P 16 108 Compact 5.5 P 16 109 Compact P 16 110 Compact 5.7 P 16 111 Compact 5.7 P 15 112 Midsize 1.8 R 37 113 Midsize 2 R 35 114 Midsize 1.6 R 35 115 Midsize 1.8 R 35 116 Midsize 1.6 R 34 117 Midsize 2.4 R 34 118 Midsize 2 R 33 119 Midsize 1.6 R 33 120 Midsize 2 R 33 121 Midsize 2 R 33 122 Midsize 1.8 R 33 123 Midsize 2.5 R 33 124 Midsize 2 R 33 125 Midsize 1.6 R 32 126 Midsize 1.6 R 32 127 Midsize 1.6 R 32 128 Midsize 2 R 32 129 Midsize 2.4 R 32 130 Midsize 2 R 32 131 Midsize 1.8 R 32 132 Midsize 2.5 R 32 133 Midsize 2.4 32 134 Midsize 2 31 135 Midsize 2.4 R 31 136 Midsize 2 R 31 137 Midsize 2 R 31 138 Midsize 2.4 R 31 139 Midsize 2.4 R 31 140 Midsize 2.4 R. 31 141 Midsize 2.4 R 31 142 Midsize 2.4 31 143 Midsize 2.2 R 31 144 Midsize 2.4 R 31 145 Midsize 2.4 R 31 146 Midsize 2.5 R 31 147 Midsize 1.8 R 31 148 Midsize 2 R 31 149 Midsize 2.4 R 31 150 Midsize 2.4 R 31 151 Midsize 2 P 30 152 Midsize 2.4 R 30 153 Midsize 2.4 R 30 154 Midsize 2 R 30 155 Midsize 2.4 R 30 156 Midsize 2.4 R 30 157 Midsize 2.4 R 30 158 Midsize 2.4 R 30 159 Midsize 2 R 30 160 Midsize 2.5 R 30 161 Midsize 2.4 R 30 162 Midsize 2 P 29 163 Midsize 2 29 164 Midsize 2 P. 29 165 Midsize 2 P 29 166 Midsize 2 P 29 167 Midsize 2.3 R 29 168 Midsize 2.3 R 29 169 Midsize 2 R 29 170 Midsize 2 R 29 171 Midsize 3.5 R 29 172 Midsize 2.5 R 29 173 Midsize 2.5 R 29 174 Midsize 2.5 R 29 175 Midsize 2.5 R 29 176 Midsize 3.5 R 29 177 Midsize 3.5 R 29 178 Midsize 3.5 R 29 179 Midsize 2.5 P 29 180 Midsize 2 P 29 181 Midsize 3.5 R 29 182 Midsize 1.8 R 29 183 Midsize 2.4 R 29 184 Midsize 2.3 R 29 185 Midsize 2.3 R 29 186 Midsize 2.3 R 29 187 Midsize 3.5 R 29 188 Midsize 2.4 28 Midsize 2.4 189 28 28 P 190 Midsize 2 191 28 Midsize 3 P. 192 Midsize 3 P. 28 193 Midsize 2.5 P. 28 194 Midsize 2.5 28 195 Midsize 2.4 P 28 196 Midsize 2.4 28 197 Midsize 2.4 P 28 198 Midsize 2.4 P. 28 199 Midsize 3.5 R 28 200 Midsize 2 R 28 201 Midsize 2 R 28 202 Midsize 2 R 28 203 Midsize 2 R 28 204 Midsize 3.9 R 28 205 Midsize 3.5 R 28 206 Midsize 3.3 R 28 207 Midsize 3.5 R 28 208 Midsize 3.5 R 28 209 Midsize 3 28 210 Midsize 2.3 P 28 211 Midsize 2 P 28 212 Midsize 3.8 R 28 213 Midsize 3.5 R 28 214 Midsize 2.3 R 28 215 Midsize 2.7 R 28 216 Midsize 2.3 R 28 217 Midsize 3.5 R 28 218 Midsize 2.3 R 28 219 28 Midsize 3.8 220 28 R Midsize 3.5 221 Midsize 2 P 27 222 Midsize 3.1 P 27 223 Midsize 2.5 27 224 Midsize 2.5 P 27 225 Midsize 2.5 P 27 226 Midsize 2.5 27 227 Midsize 2.5 R 27 228 Midsize 2.5 R 27 229 Midsize 2.5 R 27 230 Midsize 2.5 27 231 Midsize 3.3 R 27 232 Midsize 3.5 P 27 233 Midsize 3.1 27 234 Midsize 3 P 27 235 Midsize 3.5 P 27 236 Midsize 3.5 27 237 Midsize 3.5 27 238 Midsize 2.7 R 27 239 Midsize 2.7 R 27 240 Midsize 2.7 R 27 241 Midsize 2 R 27 242 Midsize 2.7 R 27 243 Midsize 2.4 R 27 244 Midsize 3 R 26 245 Midsize 3 R 26 246 Midsize 3.6 R 26