Problem 07-15 (Categorical Independent V Check My Work (3 remaining) and The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (U.5. Department of Energy website, February 22, 2008). A portion of the data for 311 compact, midsize, and large cars follows. The column labeled Class identifies the size of the car: Compact, Midsize, or Large. The column labeled Displacement shows the engine's displacement in liters. The column labeled Fuel Type shows whether the car uses premium (P) or regular (R) fuel, and the column labeled HwyMPG shows the fuel cfficiency rating for highway driving in terms of miles per gallon. The complete dato set is contained in the DATAfile named FuelData Cick on the datafile logo to reference the data or rguar (aroect DATA Tild (a) Develop an estimated regression cquation that can be used to predict the fuel efficiency for highway driving, given the engine's displacement Let x represent the engine's displacoment. If required, round your answers to three decimal places. For subtractive or negetive numbers use a minus sign even if there is a +sign before the blank. (Example:-300) is there a relationship between HnyMPG and displacement at the 0.05 level of significance? -Select your answer How much of the variation in the sample values of HwyMPG is is cxplained by this estimated regression equation? If required, round your answer to one decimal places. (b) Create a scatter chart in Excel with HwyMPG on the y-axis and displacement on the x-axis for which the points representing compact, midsize, and large automebiles are shown in difterent shapes and or colors. Choose the correct chart below place (iv) Select your answer What does this chart suggest about the relationship between the class of automobile (compact, midsize, and large) and HwyMPG? The input in the box below will not be graded, but may be reviewed and considered by your instructor blank c) Cons der the addition of the dun my vanables ClassMidsize and ClassLarge to the simple lincar e ress on modd n part a) The value of ClassMidsize s l i the car is midsize car and 0 otherwise; the valuc of ClassLarge s l if the car is a large car and 0 otherwise. Thus, for a compact caf, the value of CassMidsize and the value of ClassLarge are both O. Develop the estimated regression equation that can be used to predict the fuel emciency for highwary driving, given the engine's displacement and the dummy variables ClassMidsize and ClassLarge. Let ri represent engine's displacement. Let x2 represent variable ClassMidsize Let x3 represent variable Clasclarge If required, round your answers to three decimal places. For subtractive or negative numbers useminus sign even ithere is a sign before the blank. (Example: 300) x2 x3 How much of the variation in the sample values of HwyMPG does this estimated regression equation explain? If required, round your answer to one decimal places (d) Use significance level of 0.05 to determine whether the dummy variables added to the model in pert (c) are significant. Explein The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (e) Consider the addition of the dummy variable Fue Premium, where the value of FuelPremium is 1 if the car uses premium fuel and 0 if the car uses regular fuel. Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving, given the engine's displacement, the dummy variables ClossMidsize dummy variable FuelPremium. Let x1 represents engine's displacement Let x2 represents variable ClassMidsize Let x3 represents variable ClassLargc Let x4 represents variable FuelPremium If required, round your answers to three decimal places. For subtractive or negetive numbers use a minus sign even if there is a+sign before the blank. (Example: -300) and Class arge, and the Ydriving, x2 x4 How much of the variation in the sample values of HwyMPG does this estimated regression equation explain? If required, round your answer to one decimal places. (f) For the estimated regression equation developed in part (e), test for the significance of the relationship between each of the independent variables and the dependent variable using the 0.0S level of significance for each test. Explain he nut n the The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank et bo graded, but Explain Check My Work (3 remaining) 25 25 25 25 25 25 25 25 25 24 24 24 24 24 24 24 24 24 24 24 PPP PP P Ppp PPP PP R PpRRRRRRRppp PPP PPP P P P R R R R til 333345348 5 3 5 4 3 6 5 5 5 5 5855 365 26 6656 225 4 5 5 a 1 2 3 4 5 6 7 8 9 0-1-2-3 4-5-6-700 | 9 | 0 | 1 | 2 13 14 2280. 5 6 6 7 7 6 6 22853 .4 3 9 5 2 2 6 6 5 7 7 5 8 3 2 5 5 5 2 5 5 5 5 6 22655 44 4 4 4 4 4 5 5 2 3 4 5 6 7 8 9 6 6 6 6 6 6 6 6 6 69 7 1 2 3 4 5 76 7 8 9 0 1 2 3 4 5 86 Compact 87 Compact 88 Compact 89 Compact 90 Compact 5.2 P 5.2 P 6.2 91 Compact 92 Compact 93 Compact 94 Compact 95 Compact 96 Compact 97 Compact 98 Compact 99 Compact 100 Compact 101 Compact 102 Compact 103 Compact 104 Compact 105 Compact 106 Compact 107 Compact 108 Compact 109 Compact 110 Compact 1 Compact 112 Midsize 113 Midsize 114 Midsize 115 Midsize 116 Midsize 117 Midsize 118 Midsize 119 Midsize 120 Midsize 121 Midsize 122 Midsize 123 Midsize 124 Midsize 25 Midsize 126 Midsize 127 Midsize 128 Midsize 6.2 P 6.2 4.6 R 5.7 P 5.7 P 1.6 R 1.8 R 35 35 1.8 R 2.5 R 32 32 32 32 32 32 1.6 R 2 129 Midsize 130 Midsize 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 3 31 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 60 61 62 63 64 65 66 67 68 69 0 1 2 3 74 75 178 179 180 182 183 184 185 186 187 188 189 190 192 193 194 195 196 197 198 199 200 202 203 204 205 206 207 208 209 220 221 Midsizc 222 Midsizc 223 Midsizc 224 Midsize 225 Midsizc 226 Midsize 227 Midsizc 228 Midsize 229 Midsizc 230 Midsize 231 Midsize 232 Midsizc 233 Midsize 234 Midsize 235 Midsize 236 Midsize 237 Midsizc 238 Midsize 239 Midsize 240 Midsize 241 Midsize 242 Midsize 243 Midsize 244 Midsizc 2.5 R 2.5 R 2.5 R 3.3 R 2.7 R 245 Midsizc 246 Midsize 247 Large 248 Large 249 Large 250 Large 51 Large 252 Large 253 Large 254 Large 255 Large 256 Large 57 Large 258 Large 59 Large 260 Large 26 Large 262 Large 263 Large 264 Large 26 26 26 26 2.8 P 26 26 26 24 P 24 P 24 R 3.5 R 3.6 R 3.3 R 26 26 26 26 2.7 R 3.8 R 3.3 R 3.2 P 26 26 26 26 265 Large 266 Large 26 26 26 26 26 26 26 26 26 26 26 26 26 26 26 26 267 Large 268 Large 269 Large 270 Large 271 Large 272 Large 73 Large 274 Large 275 Large 276 Large 277 Large 78 Large 279 Large 280 Large 281 Large 282 Large 283 Large 284 Large 285 Large 286 Large 287 Large 288 Large 289 Large 290 Large 29 Large 292 Large 293 Large 294 Large 295 Large 296 Large 97 Large 298 Large 299 Large 300 Large 30 Large 302 Large 303 Large 304 Large 305 Large 306 Large 307 Large 308 Large 309 Large 310 Large 2.3 P 3.6 P 3.6 R 3.6 R 3.6 R 3.6 R 3.6 R 3.6 R 3.5 R 3.5 P 4.2 P 4.2 P 4.2 P 3.8 R 3.1 P 3.5 P 3.5 P 3.8 P 3.6 R 3.6 R 3.6 R 3.6 R 2.4 R 25 311 Large Problem 07-15 (Categorical Independent V Check My Work (3 remaining) and The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (U.5. Department of Energy website, February 22, 2008). A portion of the data for 311 compact, midsize, and large cars follows. The column labeled Class identifies the size of the car: Compact, Midsize, or Large. The column labeled Displacement shows the engine's displacement in liters. The column labeled Fuel Type shows whether the car uses premium (P) or regular (R) fuel, and the column labeled HwyMPG shows the fuel cfficiency rating for highway driving in terms of miles per gallon. The complete dato set is contained in the DATAfile named FuelData Cick on the datafile logo to reference the data or rguar (aroect DATA Tild (a) Develop an estimated regression cquation that can be used to predict the fuel efficiency for highway driving, given the engine's displacement Let x represent the engine's displacoment. If required, round your answers to three decimal places. For subtractive or negetive numbers use a minus sign even if there is a +sign before the blank. (Example:-300) is there a relationship between HnyMPG and displacement at the 0.05 level of significance? -Select your answer How much of the variation in the sample values of HwyMPG is is cxplained by this estimated regression equation? If required, round your answer to one decimal places. (b) Create a scatter chart in Excel with HwyMPG on the y-axis and displacement on the x-axis for which the points representing compact, midsize, and large automebiles are shown in difterent shapes and or colors. Choose the correct chart below place (iv) Select your answer What does this chart suggest about the relationship between the class of automobile (compact, midsize, and large) and HwyMPG? The input in the box below will not be graded, but may be reviewed and considered by your instructor blank c) Cons der the addition of the dun my vanables ClassMidsize and ClassLarge to the simple lincar e ress on modd n part a) The value of ClassMidsize s l i the car is midsize car and 0 otherwise; the valuc of ClassLarge s l if the car is a large car and 0 otherwise. Thus, for a compact caf, the value of CassMidsize and the value of ClassLarge are both O. Develop the estimated regression equation that can be used to predict the fuel emciency for highwary driving, given the engine's displacement and the dummy variables ClassMidsize and ClassLarge. Let ri represent engine's displacement. Let x2 represent variable ClassMidsize Let x3 represent variable Clasclarge If required, round your answers to three decimal places. For subtractive or negative numbers useminus sign even ithere is a sign before the blank. (Example: 300) x2 x3 How much of the variation in the sample values of HwyMPG does this estimated regression equation explain? If required, round your answer to one decimal places (d) Use significance level of 0.05 to determine whether the dummy variables added to the model in pert (c) are significant. Explein The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (e) Consider the addition of the dummy variable Fue Premium, where the value of FuelPremium is 1 if the car uses premium fuel and 0 if the car uses regular fuel. Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving, given the engine's displacement, the dummy variables ClossMidsize dummy variable FuelPremium. Let x1 represents engine's displacement Let x2 represents variable ClassMidsize Let x3 represents variable ClassLargc Let x4 represents variable FuelPremium If required, round your answers to three decimal places. For subtractive or negetive numbers use a minus sign even if there is a+sign before the blank. (Example: -300) and Class arge, and the Ydriving, x2 x4 How much of the variation in the sample values of HwyMPG does this estimated regression equation explain? If required, round your answer to one decimal places. (f) For the estimated regression equation developed in part (e), test for the significance of the relationship between each of the independent variables and the dependent variable using the 0.0S level of significance for each test. Explain he nut n the The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank et bo graded, but Explain Check My Work (3 remaining) 25 25 25 25 25 25 25 25 25 24 24 24 24 24 24 24 24 24 24 24 PPP PP P Ppp PPP PP R PpRRRRRRRppp PPP PPP P P P R R R R til 333345348 5 3 5 4 3 6 5 5 5 5 5855 365 26 6656 225 4 5 5 a 1 2 3 4 5 6 7 8 9 0-1-2-3 4-5-6-700 | 9 | 0 | 1 | 2 13 14 2280. 5 6 6 7 7 6 6 22853 .4 3 9 5 2 2 6 6 5 7 7 5 8 3 2 5 5 5 2 5 5 5 5 6 22655 44 4 4 4 4 4 5 5 2 3 4 5 6 7 8 9 6 6 6 6 6 6 6 6 6 69 7 1 2 3 4 5 76 7 8 9 0 1 2 3 4 5 86 Compact 87 Compact 88 Compact 89 Compact 90 Compact 5.2 P 5.2 P 6.2 91 Compact 92 Compact 93 Compact 94 Compact 95 Compact 96 Compact 97 Compact 98 Compact 99 Compact 100 Compact 101 Compact 102 Compact 103 Compact 104 Compact 105 Compact 106 Compact 107 Compact 108 Compact 109 Compact 110 Compact 1 Compact 112 Midsize 113 Midsize 114 Midsize 115 Midsize 116 Midsize 117 Midsize 118 Midsize 119 Midsize 120 Midsize 121 Midsize 122 Midsize 123 Midsize 124 Midsize 25 Midsize 126 Midsize 127 Midsize 128 Midsize 6.2 P 6.2 4.6 R 5.7 P 5.7 P 1.6 R 1.8 R 35 35 1.8 R 2.5 R 32 32 32 32 32 32 1.6 R 2 129 Midsize 130 Midsize 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 2 2 2 2 2 2 2 3 31 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 60 61 62 63 64 65 66 67 68 69 0 1 2 3 74 75 178 179 180 182 183 184 185 186 187 188 189 190 192 193 194 195 196 197 198 199 200 202 203 204 205 206 207 208 209 220 221 Midsizc 222 Midsizc 223 Midsizc 224 Midsize 225 Midsizc 226 Midsize 227 Midsizc 228 Midsize 229 Midsizc 230 Midsize 231 Midsize 232 Midsizc 233 Midsize 234 Midsize 235 Midsize 236 Midsize 237 Midsizc 238 Midsize 239 Midsize 240 Midsize 241 Midsize 242 Midsize 243 Midsize 244 Midsizc 2.5 R 2.5 R 2.5 R 3.3 R 2.7 R 245 Midsizc 246 Midsize 247 Large 248 Large 249 Large 250 Large 51 Large 252 Large 253 Large 254 Large 255 Large 256 Large 57 Large 258 Large 59 Large 260 Large 26 Large 262 Large 263 Large 264 Large 26 26 26 26 2.8 P 26 26 26 24 P 24 P 24 R 3.5 R 3.6 R 3.3 R 26 26 26 26 2.7 R 3.8 R 3.3 R 3.2 P 26 26 26 26 265 Large 266 Large 26 26 26 26 26 26 26 26 26 26 26 26 26 26 26 26 267 Large 268 Large 269 Large 270 Large 271 Large 272 Large 73 Large 274 Large 275 Large 276 Large 277 Large 78 Large 279 Large 280 Large 281 Large 282 Large 283 Large 284 Large 285 Large 286 Large 287 Large 288 Large 289 Large 290 Large 29 Large 292 Large 293 Large 294 Large 295 Large 296 Large 97 Large 298 Large 299 Large 300 Large 30 Large 302 Large 303 Large 304 Large 305 Large 306 Large 307 Large 308 Large 309 Large 310 Large 2.3 P 3.6 P 3.6 R 3.6 R 3.6 R 3.6 R 3.6 R 3.6 R 3.5 R 3.5 P 4.2 P 4.2 P 4.2 P 3.8 R 3.1 P 3.5 P 3.5 P 3.8 P 3.6 R 3.6 R 3.6 R 3.6 R 2.4 R 25 311 Large