A 1 Name 2 Acura CL B C ICITYMPG WEIGHT HP E TYPE 19 3470 225...

Transcribed Image Text:

A 1 Name 2 Acura CL B C ICITYMPG WEIGHT HP E TYPE 19 3470 225 Truck 3 Acura NSX 4 Acura RL 17 3155 290 Auto 18 3920 225 Truck 5 Acura RSX 25 2750 160 Service 6 Acura TL 19 3495 225 Truck 7 Aston Martin DB7 Vantage 11 4235 420 Auto 8 Aston Martin Vanquish 12 4110 460 Truck 9 Audi A4 Cabriolet 22 3250 170 Truck 10 Audi A6 17 3515 220 Auto 11 Audi A8 12 Audi TT 13 Bentley Arnage R 14 Bentley Continental R 15 BMW Z4 Roadster 16 BMW Z8 17 BMW 3 series 18 BMW 5 series 19 BMW 7 series 20 Buick Century 21 Buick LeSabre 22 Buick Park Avenue 23 Buick Regal 24 Cadillac CTS 25 Cadillac DeVille 26 Cadillac Seville 27 Chevrolet Cavalier 28 Chevrolet Corvette 29 Chevrolet Impala 30 Chevrolet Malibu 31 Chevrolet Monte Carlo 21 32 Dodge Intrepid 33 Dodge Neon 34 Dodge Stratus Coupe 35 Dodge Stratus Sedan 36 Dodge Viper 37 Chrysler Concorde 38 Chrysler PT Cruiser 39 Chrysler Sebring Convertible 40 Chrysler Sebring Coupe 41 Chrysler Sebring Sedan +22=222222222666222222222222222 17 4070 310 Auto 2920 180 Auto 10 5700 400 Service 11 5400 420 Truck 20 3100 184 Service 3495 394 Service 23 2780 184 Auto 20 3450 184 Truck 18 4510 325 Service 20 3355 175 Auto 20 3565 205 Truck 20 3780 205 Auto 19 3460 200 Truck 18 3570 220 Truck 18 3985 275 Auto 18 3990 275 Service 24 2615 140 Auto 19 3245 350 Truck 21 3310 180 Auto 20 3105 170 Truck 3340 180 Auto 20 3470 200 Auto 27 2580 132 Service 3065 147 Truck 20 3200 150 Truck 11 3360 500 Auto 20 3480 200 Service 20 3110 150 Service 21 3395 150 Truck 3065 147 Truck 20 3200 150 Auto 42 Chrysler 300M 18 3580 250 Truck 43 Ferrari Enzo 44 Ferrari 360 Modena 12 3010 660 Truck 10 3065 395 Auto 45 Ferrari 360 Spider 10 3495 395 Service 46 Ferrari 456M GT 11 3725 436 Service 47 Ferrari 575M Maranelli 10 3815 515 Truck 48 Ford Crown Victoria 18 4060 224 Service 49 Ford Escort ZX2 26 2480 130 Service 50 Ford Focus 28 2585 110 Truck B E 51 Ford Mustang 52 Ford Taurus 53 Ford Thunderbird 54 Honda Accord 55 Honda Civic 56 Honda Civic Hybrid 57 Honda Insight 58 Honda S2000 59 Hyundai Accent 60 Hyundai Elantra 61 Hyundai Sonata 62 Hyundai Tiburon 22123622222 20 3065 190 Auto 20 3345 155 Auto 17 3775 280 Service 3020 160 Service 33 2410 115 Service 47 2660 85 Truck 1850 67 Truck 20 2755 240 Service 28 2255 105 Service 25 2955 140 Auto 3180 149 Truck 2635 140 Service 63 Hyundai XG 350 18 3650 194 Service 64 Infiniti G35 19 3470 260 Truck 65 Infiniti 135 19 3340 255 Auto 66 Infiniti M45 17 3900 340 Service 67 Infiniti Q45 17 4050 340 Truck 68 Jaguar XJ8 17 3995 290 Auto 69 Jaguar Vanden Plas 17 4005 290 Truck 70 Jaguar XK8 17 3760 294 Truck 71 Jaguar S-Type 17 3940 240 Service 72 Jaguar X-Type 19 3430 194 Truck 73 Kia Optima 21 3070 149 Service 74 Kia Rio 30 2240 105 Auto 75 Kia Spectra 25 2480 125 Truck 76 Lamborghini Murcielago 9 4020 580 Truck 77 Lexus ES300 21 3440 210 Service 78 Lexus GS300 18 3645 220 Truck 79 Lexus IS300 80 Lexus LS430 18 3255 215 Service 18 3955 290 Service 81 Lexus SC430 18 3840 300 Service 82 Lotus Esprit V8 15 3045 350 Truck 83 Lincoln LS 18 3675 232 Service 84 Lincoln Town Car 17 4370 239 Auto 85 Maserati Coupe 11 3600 390 Service 86 Maserati Spyder 11 3790 390 Truck 87 Mazda Miata 25 2300 142 Truck 88 Mazda Protg 29 2450 105 Auto 89 Mazda 6 25 2800 160 Service 90 Mercury Grand Marquis 17 4050 224 Truck 91 Mercury Marauder 17 4195 302 Service 92 Mercury Sable 20 3345 155 Truck 93 Mini Cooper 26 2490 115 Service 94 Mercedes-Bens C-Class 20 3360 168 Service 95 Mercedes-Bens C230 Sports Coupe 20 3310 189 Auto 96 Mercedes-Bens CLK 21 3500 215 Auto 97 Mercedes-Bens CL/S Class 17 4130 275 Truck 98 Mercedes-Bens E-Class 20 3625 221 Truck 99 Mercedes-Bens SL 100 Mercedes-Bens SLK 101 Mitsubishi Diamante 15 4045 302 Truck 23 2910 190 Service 18 3440 210 Truck . 102 Mitsubishi Eclipse 103 Mitsubishi Galant 22 23 2910 147 Truck 21 3030 140 Service 104 Mitsubishi Lancer 26 2645 120 Service 105 Mitsubishi Lancer Evolution VIII 18 3300 270 Service 106 Morgan Plus 8 18 2230 188 Truck 107 Nissan Altima 23 3000 175 Auto 108 Nissan Maxima 109 Nissan Sentra 110 Nissan 350Z 111 Oldsmobile Alero 112 Oldmobile Aurora 113 Panoz Esperante 114 Pontiac Bonneville 115 Pontiac Grand Am 116 Pontiac Grand Prix 117 Pontiac Sunfire 118 Pontiac Vibe 119 Porsche Boxster 120 Porsche 911 Carrera 121 Porsche 911 Turbo 122 Saab 9-3 123 Saab 9-5 124 Saleen S7 125 Saturn Ion 126 Saturn L-Series 127 Subaru Baja 128 Subaru Impreza 129 Subaru Legacy 130 Suzuki Aerio 131 Toyota Avalon 132 Toyota Camry 133 Toyota Camry Solara 134 Toyota Celica 135 Toyota Corolla 136 Toyota Echo 137 Toyota Matriz 138 Totota MR2 Spyder 139 Totota Prius 140 Volkswagen New Beetle 141 Volkswagen Golf 142 Volkswagen Jetta 143 Volkswagen Passat 144 Volvo C70 145 Volvo S40 146 Volvo S60 147 Volvo S80 148 Volvo V70 222222222222222222222222222222222222 21 3240 255 Truck 27 2520 126 Auto 20 3188 287 Truck 25 2945 140 Service 18 3800 250 Service 3125 320 Truck 20 3590 205 Service 24 3065 140 Auto 20 3385 175 Service 24 2605 140 Auto 29 2700 130 Auto 20 2810 225 Service 17 2910 320 Service 15 3395 415 Service 20 3175 175 Auto 21 3470 185 Truck 10 2750 550 Truck 26 2750 140 Service 25 2990 135 Service 20 3485 165 Service 20 2965 165 Truck 21 3225 165 Auto 26 2605 145 Truck 21 3415 210 Truck 23 3085 157 Service 20 3120 157 Auto 28 2425 140 Auto 32 2500 130 Auto 34 2035 108 Auto 30 2680 130 Service 25 2195 138 Auto 52 2765 98 Service 24 2815 115 Auto 24 2770 115 Auto 24 2890 115 Truck 3225 170 Auto 19 3285 196 Auto 2865 170 Service 21 3145 168 Truck 18 3275 197 Auto 3370 197 Truck Estimating Fuel Efficiency: The Chief Science Officer (CSO) of a large multinational automotive company wants more information concerning the factors that influence vehicle fuel efficiency. Therefore, company scientists are developing an equation to predict mileage in city driving (CITYMPG) using the following variables: weight (in pounds), horsepower (@ 6,300 RPMs) and vehicle type (either automobile (Auto), truck, (Truck), or service vehicle (Service)). However, evidence exists to suggest that a log-linear relationship exists between horsepower and city mileage. Therefore, use the natural log of horsepower in the model. Finally, code the variable vehicle type so that "service vehicle" serves as the reference group. The data are available in the worksheet entitled "CARS8_HW10". (a) State the model equation. CITYMPG = 0 + BWEIGHT + $HORSEPOWER + BAUTO + BTRUCK + SERVICE CITYMPG = 0 + BWEIGHT + $HORSEPOWER +33 VEHICLETYPE CITYMPG = Po + BWEIGHT + $HORSEPOWER + BAUTO + TRUCK O CITYMPG = 0 + BWEIGHT + BLN(HORSEPOWER) + 3AUTO + TRUCK + SERVICE CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) + 3 VEHICLETYPE O CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) + AUTO + BTRUCK (b) Is there a difference in city based mileage among the different vehicles types after accounting for the effects of weight and horsepower? Perform a hypothesis test to answer this question. Use a 5% level of significance. State the hypotheses to be tested. OH B =B = = = 0 H.: At least one of the coefficients is not equal to 0. OH: B = B = 0 H.: At least one of the coefficients is not equal to 0. H.: At least one of the coefficients is not equal to 0. O H: None of the coefficients are equal to 0. O H: At least one of the coefficients is not equal to 0. H B = B = 0 Interpret the hypotheses you specified above. H: At least one explanatory variable is important in explaining/predicting city mileage. H: None of the explanatory variables are important in explaining/predicting city mileage. O H: There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. H.: There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. O H: None of the explanatory variables are important in explaining/predicting city mileage. H: At least one explanatory variable is important in explaining/predicting city mileage. O H: There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. H.: There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. O H: None of the explanatory variables are important in explaining/predicting city mileage. H.: All of the explanatory variables are important in explaining/predicting city mileage. Activate Windows State the decision rule. O Reject H, if p < 0.05. Do not reject H if p > 0.05. O Reject H if p < 0.025. Do not reject H if p > 0.025. O Reject H if p > 0.05. Do not reject H, if p 0.05. O Reject H if p > 0.025. Do not reject H, if p 0.025. State the reduced model equation. O CITYMPG = Po + SVEHICLETYPE O CITYMPG = B + B WEIGHT + BHORSEPOWER O BO + B WEIGHT + BLN(HORSEPOWER) + BAUTO + B TRUCK O CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) + 3 VEHICLETYPE O CITYMPG =B0+ $AUTO + $TRUCK O CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) State the appropriate test statistic name, degrees of freedom, test statistic value, and the associated p-value (Enter the degrees of freedom as a whole number, the test statistic value to three decimal places, and the p-value to four decimal places). --Select-- ( State your decision. )= ---Select-- Reject the null hypothesis. There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. Reject the null hypothesis. There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. O Fail to reject the null hypothesis. There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. Fail to reject the null hypothesis. There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. (c) Regardless of your conclusions above, use the full model specified above (with all the variables) to answer the following questions. What is the predicted city miles per gallon for a truck that weighs 3,750 lbs. and has 400 horsepower? (Round your answer to three decimal places.) MPG What is the predicted city miles per gallon for a service vehicle that weighs 3,750 lbs. and has 400 horsepower? (Round your answer to three decimal places.) MPG What is the predicted city miles per gallon for an automobile that weighs 3,750 lbs. and has 400 horsepower? (Round your answer to three decimal places.) MPG (d) How do you account for the differences in the estimates in part (c)? O There are major differences in city mileage among the different vehicles types, therefore, this probably is an important phenomenon that is generalizable to the entire population of vehicles. There are slight differences in city mileage among the different vehicles types, however, this is indistinguishable from sampling error and, therefore, probably not an important phenomenon that is generalizable to the entire population of vehicles. O Weight explains the majority of differences in city mileage in vehicles. O Vehicle type explains the majority of differences in city mileage in vehicles. (e) Regardless of your conclusions above, use the full model specified above (with all the variables) to answer the following questions. Choose the proper interpretation of the coefficient for automobiles from your analysis above by mentally inserting the ABSOLUTE VALUE of that number in the blanks below. After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get miles per gallon less than the other vehicles, on average. miles per gallon more than service vehicles, on average. miles per gallon more than trucks, on average. miles per gallon less than service vehicles, on average. miles per gallon more than the other vehicles, on average. miles per gallon less than trucks, on average. Provide a 99% confidence interval for the coefficient for automobiles. (Enter your answers to three decimal places.) ) MPG Choose the proper interpretation of the confidence interval for the coefficient for automobiles from your analysis above. Because the confidence interval for automobiles does not include zero, there is a statistically significant difference in city mileage between automobiles and trucks at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles includes zero, there is also no statistically significant difference in city mileage between automobiles and service vehicles at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles includes zero, there is also no statistically significant difference in city mileage between automobiles and the other vehicles types at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles does not include zero, there is a statistically significant difference in city mileage between automobiles and the other vehicles types at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles includes zero, there is also no statistically significant difference in city mileage between automobiles and trucks at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles does not include zero, there is a statistically significant difference in city mileage between automobiles and service vehicles at the 99% confidence level after accounting for vehicle weight and horsepower. A 1 Name 2 Acura CL B C ICITYMPG WEIGHT HP E TYPE 19 3470 225 Truck 3 Acura NSX 4 Acura RL 17 3155 290 Auto 18 3920 225 Truck 5 Acura RSX 25 2750 160 Service 6 Acura TL 19 3495 225 Truck 7 Aston Martin DB7 Vantage 11 4235 420 Auto 8 Aston Martin Vanquish 12 4110 460 Truck 9 Audi A4 Cabriolet 22 3250 170 Truck 10 Audi A6 17 3515 220 Auto 11 Audi A8 12 Audi TT 13 Bentley Arnage R 14 Bentley Continental R 15 BMW Z4 Roadster 16 BMW Z8 17 BMW 3 series 18 BMW 5 series 19 BMW 7 series 20 Buick Century 21 Buick LeSabre 22 Buick Park Avenue 23 Buick Regal 24 Cadillac CTS 25 Cadillac DeVille 26 Cadillac Seville 27 Chevrolet Cavalier 28 Chevrolet Corvette 29 Chevrolet Impala 30 Chevrolet Malibu 31 Chevrolet Monte Carlo 21 32 Dodge Intrepid 33 Dodge Neon 34 Dodge Stratus Coupe 35 Dodge Stratus Sedan 36 Dodge Viper 37 Chrysler Concorde 38 Chrysler PT Cruiser 39 Chrysler Sebring Convertible 40 Chrysler Sebring Coupe 41 Chrysler Sebring Sedan +22=222222222666222222222222222 17 4070 310 Auto 2920 180 Auto 10 5700 400 Service 11 5400 420 Truck 20 3100 184 Service 3495 394 Service 23 2780 184 Auto 20 3450 184 Truck 18 4510 325 Service 20 3355 175 Auto 20 3565 205 Truck 20 3780 205 Auto 19 3460 200 Truck 18 3570 220 Truck 18 3985 275 Auto 18 3990 275 Service 24 2615 140 Auto 19 3245 350 Truck 21 3310 180 Auto 20 3105 170 Truck 3340 180 Auto 20 3470 200 Auto 27 2580 132 Service 3065 147 Truck 20 3200 150 Truck 11 3360 500 Auto 20 3480 200 Service 20 3110 150 Service 21 3395 150 Truck 3065 147 Truck 20 3200 150 Auto 42 Chrysler 300M 18 3580 250 Truck 43 Ferrari Enzo 44 Ferrari 360 Modena 12 3010 660 Truck 10 3065 395 Auto 45 Ferrari 360 Spider 10 3495 395 Service 46 Ferrari 456M GT 11 3725 436 Service 47 Ferrari 575M Maranelli 10 3815 515 Truck 48 Ford Crown Victoria 18 4060 224 Service 49 Ford Escort ZX2 26 2480 130 Service 50 Ford Focus 28 2585 110 Truck B E 51 Ford Mustang 52 Ford Taurus 53 Ford Thunderbird 54 Honda Accord 55 Honda Civic 56 Honda Civic Hybrid 57 Honda Insight 58 Honda S2000 59 Hyundai Accent 60 Hyundai Elantra 61 Hyundai Sonata 62 Hyundai Tiburon 22123622222 20 3065 190 Auto 20 3345 155 Auto 17 3775 280 Service 3020 160 Service 33 2410 115 Service 47 2660 85 Truck 1850 67 Truck 20 2755 240 Service 28 2255 105 Service 25 2955 140 Auto 3180 149 Truck 2635 140 Service 63 Hyundai XG 350 18 3650 194 Service 64 Infiniti G35 19 3470 260 Truck 65 Infiniti 135 19 3340 255 Auto 66 Infiniti M45 17 3900 340 Service 67 Infiniti Q45 17 4050 340 Truck 68 Jaguar XJ8 17 3995 290 Auto 69 Jaguar Vanden Plas 17 4005 290 Truck 70 Jaguar XK8 17 3760 294 Truck 71 Jaguar S-Type 17 3940 240 Service 72 Jaguar X-Type 19 3430 194 Truck 73 Kia Optima 21 3070 149 Service 74 Kia Rio 30 2240 105 Auto 75 Kia Spectra 25 2480 125 Truck 76 Lamborghini Murcielago 9 4020 580 Truck 77 Lexus ES300 21 3440 210 Service 78 Lexus GS300 18 3645 220 Truck 79 Lexus IS300 80 Lexus LS430 18 3255 215 Service 18 3955 290 Service 81 Lexus SC430 18 3840 300 Service 82 Lotus Esprit V8 15 3045 350 Truck 83 Lincoln LS 18 3675 232 Service 84 Lincoln Town Car 17 4370 239 Auto 85 Maserati Coupe 11 3600 390 Service 86 Maserati Spyder 11 3790 390 Truck 87 Mazda Miata 25 2300 142 Truck 88 Mazda Protg 29 2450 105 Auto 89 Mazda 6 25 2800 160 Service 90 Mercury Grand Marquis 17 4050 224 Truck 91 Mercury Marauder 17 4195 302 Service 92 Mercury Sable 20 3345 155 Truck 93 Mini Cooper 26 2490 115 Service 94 Mercedes-Bens C-Class 20 3360 168 Service 95 Mercedes-Bens C230 Sports Coupe 20 3310 189 Auto 96 Mercedes-Bens CLK 21 3500 215 Auto 97 Mercedes-Bens CL/S Class 17 4130 275 Truck 98 Mercedes-Bens E-Class 20 3625 221 Truck 99 Mercedes-Bens SL 100 Mercedes-Bens SLK 101 Mitsubishi Diamante 15 4045 302 Truck 23 2910 190 Service 18 3440 210 Truck . 102 Mitsubishi Eclipse 103 Mitsubishi Galant 22 23 2910 147 Truck 21 3030 140 Service 104 Mitsubishi Lancer 26 2645 120 Service 105 Mitsubishi Lancer Evolution VIII 18 3300 270 Service 106 Morgan Plus 8 18 2230 188 Truck 107 Nissan Altima 23 3000 175 Auto 108 Nissan Maxima 109 Nissan Sentra 110 Nissan 350Z 111 Oldsmobile Alero 112 Oldmobile Aurora 113 Panoz Esperante 114 Pontiac Bonneville 115 Pontiac Grand Am 116 Pontiac Grand Prix 117 Pontiac Sunfire 118 Pontiac Vibe 119 Porsche Boxster 120 Porsche 911 Carrera 121 Porsche 911 Turbo 122 Saab 9-3 123 Saab 9-5 124 Saleen S7 125 Saturn Ion 126 Saturn L-Series 127 Subaru Baja 128 Subaru Impreza 129 Subaru Legacy 130 Suzuki Aerio 131 Toyota Avalon 132 Toyota Camry 133 Toyota Camry Solara 134 Toyota Celica 135 Toyota Corolla 136 Toyota Echo 137 Toyota Matriz 138 Totota MR2 Spyder 139 Totota Prius 140 Volkswagen New Beetle 141 Volkswagen Golf 142 Volkswagen Jetta 143 Volkswagen Passat 144 Volvo C70 145 Volvo S40 146 Volvo S60 147 Volvo S80 148 Volvo V70 222222222222222222222222222222222222 21 3240 255 Truck 27 2520 126 Auto 20 3188 287 Truck 25 2945 140 Service 18 3800 250 Service 3125 320 Truck 20 3590 205 Service 24 3065 140 Auto 20 3385 175 Service 24 2605 140 Auto 29 2700 130 Auto 20 2810 225 Service 17 2910 320 Service 15 3395 415 Service 20 3175 175 Auto 21 3470 185 Truck 10 2750 550 Truck 26 2750 140 Service 25 2990 135 Service 20 3485 165 Service 20 2965 165 Truck 21 3225 165 Auto 26 2605 145 Truck 21 3415 210 Truck 23 3085 157 Service 20 3120 157 Auto 28 2425 140 Auto 32 2500 130 Auto 34 2035 108 Auto 30 2680 130 Service 25 2195 138 Auto 52 2765 98 Service 24 2815 115 Auto 24 2770 115 Auto 24 2890 115 Truck 3225 170 Auto 19 3285 196 Auto 2865 170 Service 21 3145 168 Truck 18 3275 197 Auto 3370 197 Truck Estimating Fuel Efficiency: The Chief Science Officer (CSO) of a large multinational automotive company wants more information concerning the factors that influence vehicle fuel efficiency. Therefore, company scientists are developing an equation to predict mileage in city driving (CITYMPG) using the following variables: weight (in pounds), horsepower (@ 6,300 RPMs) and vehicle type (either automobile (Auto), truck, (Truck), or service vehicle (Service)). However, evidence exists to suggest that a log-linear relationship exists between horsepower and city mileage. Therefore, use the natural log of horsepower in the model. Finally, code the variable vehicle type so that "service vehicle" serves as the reference group. The data are available in the worksheet entitled "CARS8_HW10". (a) State the model equation. CITYMPG = 0 + BWEIGHT + $HORSEPOWER + BAUTO + BTRUCK + SERVICE CITYMPG = 0 + BWEIGHT + $HORSEPOWER +33 VEHICLETYPE CITYMPG = Po + BWEIGHT + $HORSEPOWER + BAUTO + TRUCK O CITYMPG = 0 + BWEIGHT + BLN(HORSEPOWER) + 3AUTO + TRUCK + SERVICE CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) + 3 VEHICLETYPE O CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) + AUTO + BTRUCK (b) Is there a difference in city based mileage among the different vehicles types after accounting for the effects of weight and horsepower? Perform a hypothesis test to answer this question. Use a 5% level of significance. State the hypotheses to be tested. OH B =B = = = 0 H.: At least one of the coefficients is not equal to 0. OH: B = B = 0 H.: At least one of the coefficients is not equal to 0. H.: At least one of the coefficients is not equal to 0. O H: None of the coefficients are equal to 0. O H: At least one of the coefficients is not equal to 0. H B = B = 0 Interpret the hypotheses you specified above. H: At least one explanatory variable is important in explaining/predicting city mileage. H: None of the explanatory variables are important in explaining/predicting city mileage. O H: There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. H.: There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. O H: None of the explanatory variables are important in explaining/predicting city mileage. H: At least one explanatory variable is important in explaining/predicting city mileage. O H: There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. H.: There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. O H: None of the explanatory variables are important in explaining/predicting city mileage. H.: All of the explanatory variables are important in explaining/predicting city mileage. Activate Windows State the decision rule. O Reject H, if p < 0.05. Do not reject H if p > 0.05. O Reject H if p < 0.025. Do not reject H if p > 0.025. O Reject H if p > 0.05. Do not reject H, if p 0.05. O Reject H if p > 0.025. Do not reject H, if p 0.025. State the reduced model equation. O CITYMPG = Po + SVEHICLETYPE O CITYMPG = B + B WEIGHT + BHORSEPOWER O BO + B WEIGHT + BLN(HORSEPOWER) + BAUTO + B TRUCK O CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) + 3 VEHICLETYPE O CITYMPG =B0+ $AUTO + $TRUCK O CITYMPG = B + BWEIGHT + BLN(HORSEPOWER) State the appropriate test statistic name, degrees of freedom, test statistic value, and the associated p-value (Enter the degrees of freedom as a whole number, the test statistic value to three decimal places, and the p-value to four decimal places). --Select-- ( State your decision. )= ---Select-- Reject the null hypothesis. There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. Reject the null hypothesis. There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. O Fail to reject the null hypothesis. There is a significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. Fail to reject the null hypothesis. There is no significant difference in city mileage among the different vehicle types after accounting for weight and horsepower. (c) Regardless of your conclusions above, use the full model specified above (with all the variables) to answer the following questions. What is the predicted city miles per gallon for a truck that weighs 3,750 lbs. and has 400 horsepower? (Round your answer to three decimal places.) MPG What is the predicted city miles per gallon for a service vehicle that weighs 3,750 lbs. and has 400 horsepower? (Round your answer to three decimal places.) MPG What is the predicted city miles per gallon for an automobile that weighs 3,750 lbs. and has 400 horsepower? (Round your answer to three decimal places.) MPG (d) How do you account for the differences in the estimates in part (c)? O There are major differences in city mileage among the different vehicles types, therefore, this probably is an important phenomenon that is generalizable to the entire population of vehicles. There are slight differences in city mileage among the different vehicles types, however, this is indistinguishable from sampling error and, therefore, probably not an important phenomenon that is generalizable to the entire population of vehicles. O Weight explains the majority of differences in city mileage in vehicles. O Vehicle type explains the majority of differences in city mileage in vehicles. (e) Regardless of your conclusions above, use the full model specified above (with all the variables) to answer the following questions. Choose the proper interpretation of the coefficient for automobiles from your analysis above by mentally inserting the ABSOLUTE VALUE of that number in the blanks below. After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get After accounting for the effects of vehicle weight and horsepower, automobiles get miles per gallon less than the other vehicles, on average. miles per gallon more than service vehicles, on average. miles per gallon more than trucks, on average. miles per gallon less than service vehicles, on average. miles per gallon more than the other vehicles, on average. miles per gallon less than trucks, on average. Provide a 99% confidence interval for the coefficient for automobiles. (Enter your answers to three decimal places.) ) MPG Choose the proper interpretation of the confidence interval for the coefficient for automobiles from your analysis above. Because the confidence interval for automobiles does not include zero, there is a statistically significant difference in city mileage between automobiles and trucks at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles includes zero, there is also no statistically significant difference in city mileage between automobiles and service vehicles at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles includes zero, there is also no statistically significant difference in city mileage between automobiles and the other vehicles types at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles does not include zero, there is a statistically significant difference in city mileage between automobiles and the other vehicles types at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles includes zero, there is also no statistically significant difference in city mileage between automobiles and trucks at the 99% confidence level after accounting for vehicle weight and horsepower. O Because the confidence interval for automobiles does not include zero, there is a statistically significant difference in city mileage between automobiles and service vehicles at the 99% confidence level after accounting for vehicle weight and horsepower.