Several years ago, a Chinese automobile company aspired to enter the US market by developing manufacturing capabilities and producing cars locally. They contracted with a major automobile consulting company to better understand how the drive train affected the pricing of cars in the American market, which they suspected would be different from the Chinese market. The Final Exam Workbook contains a sample of 185 foreign and domestic automobiles that were being sold in the US. The variables are: price (in US dollars) engine size (in cc (cubic centimeters]) horsepower (in bhp [brake horsepower]) cylinders turbo (1=yes; 0=no) mpg (average miles per gallon) The variables are in the order listed above. The sample data is provided in two Question 1 tabs in the Final Exam Workbook. a. Using the first tab, labeled "Question 1 - parts a,b,c", build a model that relates price to the other variables listed above. Write the estimated regression equation. b. Is the model statistically significant at the a = .05 level? Write out the null and alternative hypotheses, the appropriate test statistic, the p-value for that test statistic and your conclusion, based on that p-value. C. The automobile company suspects that vehicle price depends on engine size, holding everything else equal. To evaluate this suspicion, write out the null and alternative hypotheses, the appropriate test statistic, the p-value for that test statistic and your conclusion based on that p-value, at the a ,05 level in turhanhamed can turbo 0 1 horsepower cylinders 115 5 160 5 73 4 82 4 111 4 82 4 0 mpg 20 19 29 25 27 26 23 30 1 0 4 4 62 1 0 0 0 512 (cc) 136 131 108 108 108 108 108 92 92 136 136 136 131 136 109 90 90 90 90 98 90 90 4 5 30 22 5 5 5 22 22 19 22 27 5 1 car name 2 audi 10015 3 audi 5000s (diesel) 4 subaru di s subaru i 6 subaru r2 7 subaru di 8 subaru di 9 toyota corolla 1600 (sw) 10 toyota carina 11 audi fox 12 audi 100ls 13 audi 5000 14 audi 4000 15 volkswagen rabbit 16 audi 100 is 17 chevrolet monte carlo 18 chevrolet vega 2300 19 dodge rampage 20 dodge challenger se 21 dodge d 200 22 dodge monaco (sw) za dodge colt hardtop 24 dodge colt (sw) 25 dodge coronet custom 26 dodge dart custom 27 dodge coronet custom (sw) 28 honda civic 29 honda civic Cvce 30 honda civic 31 honda accord avec 32 honda civic ecc 33 honda scoord bx 34 honda civic 1500 35 honda accord 36 honda civic 1300 62 110 110 110 140 110 102 70 70 68 68 102 68 4 price 17450 17859 7603 9233 11259 8013 11694 7898 8778 15250 17710 18920 23875 13295 13950 6295 6575 5572 6377 7957 6229 6692 7609 8558 8921 12964 6479 6855 5399 6529 7129 7295 7295 7895 9095 4 4 4 4 4 4 4 4 OOOOOOOOOOOOOOOOOOOOO 4 4 4 68 68 102 88 145 58 76 60 76 76 76 76 86 86 90 98 122 156 92 92 79 92 92 92 92 110 110 41 39 35 27 35 35 35 27 27 22 52 35 40 32 32 4 4 4 32 30 30 0 86 86 101 IOD 4 4 4 4 OOOO 0 0 70 4 0 0 0 20 4 0 0 4 4 4 30 30 26 28 41 41 31 35 35 35 35 29 29 29 29 29 39 4 4 4 D a D D 0 0 4 D 0 0 68 68 68 68 68 84 84 84 14 84 68 GB 68 102 116 88 145 145 145 88 4 a7 honda prelude 38 honda accord 39 honda civic 40 honda civic (auto) 41 in D Max 42 uzu D-Max V Cross 1a madara 44 maxda glc deluxe 45 marda 2 coupe 46 mazda rx 4 47 mazda glc deluxe mazda 626 49 mazda el custom 50 mazda glc custom 51 mazda rx-4 52 mazda 626 53 mitsubishi mirage 54 mitsubishi lancer 55 mitsubishi Outlandet 55 mitsubishi 57 mitsubishi mirage 58 mitsubishi 50 mitsubishi Outlander 50 mitsubishi 4 61 mitsubishi mirage 52 mitsubishi Montero ta mitsubishi pajero 64 mitsubishi Outlander 65 mitsubishi mirage 84 56 Nissan Ver 67 nisam rogue 6 nissan latio Le cantitat 70 niscan leaf 71 nisanju 77 nissan latio 73 nico Instructions 0 0 8845 110 10295 110 12945 110 10343 110 8917 90 8917 90 5195 91 G095 91 6795 91 6695 91 7395 91 8845 122 8495 172 10595 122 10245 122 11245 122 5389 92 6189 92 6609 92 7688 98 9959 110 8499 122 12629 156 14869 156 14.489 156 0989 122 3189 122 9229 110 9279 110 5499 97 92 5849 97 7349 97 7200 97 7799 97 7499 97 2999 97 An GIt 4 4 4 4 0 D 0 0 1 1 0 1 1 1 0 D 1 0 0 D 4 4 4 D o I 1 0 1 1 1 25 27 27 29 22 22 22 29 29 27 27 34 34 34 4 4 1 116 116 D 1 4 D 4 4 4 69 69 69 0 D D 0 9 69 4 4 4 a 0 34 34 34 0 69 4 69 4 D D 34 E E 1 0 34 odige TOR 2009 130 1 T 1 5572 olymouthtung 1 DE 1 lututungan sede 4 + 3 3F=*==*} X1 YJZS: D 1 0 4 4 4 4 4 3 0 0 121 97 738 108 108 108 108 108 32 99 7 1 B 0 0 4 0 0 4 0 0 0 98 1 V 0 D 98 122 122 0 0 0 0 0 30 30 30 31 0 1 4 1 4 4 3 3 4 4 4 4 $ 3 O 83 3995 5ab TESO 12170 500 3893 1960 9999le 30ab33 18820 Subaru 5118 9nbarud 7053 Subaru 7129 94 subaru 7775 55 Subaru baie 9960 96 Subaru teria 7463 97 subotu tribeca 10130 98 topola corona mark 5348 99 tota corona 6339 100 corolla 1200 64 101 vota corona hard op 6910 102 toyota mark 6938 103 tota corolla 1200 7138 104 toyota corona 7738 105 topola corolla Bas 06 toyota marki 925 107 Lovol Corollo 8943 108 toyota corona 3938 109 tavola corolla 1998 Toda marki T24B mi volkswagen 1131 deluxe sedan 7975 112 volkwagen type 3 8195 Tavolwagen 3495 4 volkswagen desher 9995 115 vw dasher 1695 Tswabbit 9990 17 volkswagen dasher 12230 17 incando 13499 119 nissan fuga 14399 120 son olti 13499 121 chevrolet imala 5151 22fuck opel isundele 34184 122 buckokyo 35056 T24burch century special 40960 buid tego sport coupe turbo! 45000 1 porsche corne 31401 aita-romeo giulia 20tomoro stelvio 16500 189 6420 bmw 220 15925 131 MB 6765 22 D 10348 15200 4 cury Coug 8503 Luged 11900) ged 12440 5500 1689! 150 1050 12764 22016 odlik 3050 0230 ubac Walia 0441 3309 1199 122 109 109 109 109 109 0 GOODS 0 0 0 0 0 0 0 D 0 0 3 0 100 30 30 88 152 152 152 48 155 155 184 6 0 0 0 19 181 181 81 67 234 234 308 304 203 130 130 0 20 22 50 17 17 0 0 8 8 8 0 0 8 8 0 5 23 288 111 SETEL 0 0 0 0 0 0 D 0 D 0 0 D 0 18 111 113 140 140 4 4 4 4 4 4 4 4 4 4 4 0 101 *01 78 90 120 175 97 97 95 3 97 142 145 143 0 1 0 per PONO 0 mo surpro.rn in 120 120 120 120 134 56 151 4 98 CCA WI 112 112 115 0 OR 90 11 14 0 Instructions Answers Questic A150 toyota tercel D E F B 999 146 0 0 116 116 4 4 0 0 116 4 O 27 27 27 27 26 26 4 0 116 114 4 114 4 D 146 146 146 141 141 141 141 130 130 141 0 0 4 114 114 0 0 4 1 1 4 4 1 162 162 114 160 114 1 O 4 0 4 1 1 1 1 4 0 149 toyota starlet 150 toyota tercel 151 toyota corolla 152 toyota cressida 153 volvo 1450 (sw) 154 volvo 144ea 155 volvo 244d1 156 volvo 245 157 volvo 2648! 158 volve diesel 159 volvo 145e(sw) 160 volvo 144ea 151 volve 26481 162 alfa romero Quadrifoglio 13 bmw x1 164 bmw xa 165 bmw 14 166 bmw x4 167 bnw x5 16 bmw x3 169 170 jaguar x 171 nissen teana 172 nissan kicks 173 nisan clipper 174 poechce panamera 175 porsche Cayenne 176 porsche boxter 177 toyota corolla liittack 178 toyota corona 17 toyota starlet 1180 toyoute tercel 181 volvo 24441 154 121 121 0 0 141 141 152 164 164 164 209 209 6 6 6 0 6 0 D 11199 11549 17669 12940 13415 15985 16515 18420 18950 16845 19045 22625 16500 20970 21105 24565 30750) 41315 36880 32250 35550 17199 19699 18399 32528 34028 37028 16558 15998 15690 15750 21485 IX) 10945 11H45 11145 15 26 26 20 20 25 22 22 22 25 25 23 19 19 18 17 17 22 20 22 21 21 0 0 6 6 0 0 209 6 0 D O 0 D 0 0 1 1 121 182 182 182 176 176 160 200 160 207 207 207 161 161 156 156 134 22 6 6 0 5 0 0 0 0 6 22 258 181 181 181 196 194 1414 171 171 171 161 173 126 70 vo 20 no 0 6 6 0 0 22 22 31 0 183626 0 0 0 0 D o 0 0 D 12 2 2 2 101 101 101 20 20 20 20 0 0 Several years ago, a Chinese automobile company aspired to enter the US market by developing manufacturing capabilities and producing cars locally. They contracted with a major automobile consulting company to better understand how the drive train affected the pricing of cars in the American market, which they suspected would be different from the Chinese market. The Final Exam Workbook contains a sample of 185 foreign and domestic automobiles that were being sold in the US. The variables are: price (in US dollars) engine size (in cc (cubic centimeters]) horsepower (in bhp [brake horsepower]) cylinders turbo (1=yes; 0=no) mpg (average miles per gallon) The variables are in the order listed above. The sample data is provided in two Question 1 tabs in the Final Exam Workbook. a. Using the first tab, labeled "Question 1 - parts a,b,c", build a model that relates price to the other variables listed above. Write the estimated regression equation. b. Is the model statistically significant at the a = .05 level? Write out the null and alternative hypotheses, the appropriate test statistic, the p-value for that test statistic and your conclusion, based on that p-value. C. The automobile company suspects that vehicle price depends on engine size, holding everything else equal. To evaluate this suspicion, write out the null and alternative hypotheses, the appropriate test statistic, the p-value for that test statistic and your conclusion based on that p-value, at the a ,05 level in turhanhamed can turbo 0 1 horsepower cylinders 115 5 160 5 73 4 82 4 111 4 82 4 0 mpg 20 19 29 25 27 26 23 30 1 0 4 4 62 1 0 0 0 512 (cc) 136 131 108 108 108 108 108 92 92 136 136 136 131 136 109 90 90 90 90 98 90 90 4 5 30 22 5 5 5 22 22 19 22 27 5 1 car name 2 audi 10015 3 audi 5000s (diesel) 4 subaru di s subaru i 6 subaru r2 7 subaru di 8 subaru di 9 toyota corolla 1600 (sw) 10 toyota carina 11 audi fox 12 audi 100ls 13 audi 5000 14 audi 4000 15 volkswagen rabbit 16 audi 100 is 17 chevrolet monte carlo 18 chevrolet vega 2300 19 dodge rampage 20 dodge challenger se 21 dodge d 200 22 dodge monaco (sw) za dodge colt hardtop 24 dodge colt (sw) 25 dodge coronet custom 26 dodge dart custom 27 dodge coronet custom (sw) 28 honda civic 29 honda civic Cvce 30 honda civic 31 honda accord avec 32 honda civic ecc 33 honda scoord bx 34 honda civic 1500 35 honda accord 36 honda civic 1300 62 110 110 110 140 110 102 70 70 68 68 102 68 4 price 17450 17859 7603 9233 11259 8013 11694 7898 8778 15250 17710 18920 23875 13295 13950 6295 6575 5572 6377 7957 6229 6692 7609 8558 8921 12964 6479 6855 5399 6529 7129 7295 7295 7895 9095 4 4 4 4 4 4 4 4 OOOOOOOOOOOOOOOOOOOOO 4 4 4 68 68 102 88 145 58 76 60 76 76 76 76 86 86 90 98 122 156 92 92 79 92 92 92 92 110 110 41 39 35 27 35 35 35 27 27 22 52 35 40 32 32 4 4 4 32 30 30 0 86 86 101 IOD 4 4 4 4 OOOO 0 0 70 4 0 0 0 20 4 0 0 4 4 4 30 30 26 28 41 41 31 35 35 35 35 29 29 29 29 29 39 4 4 4 D a D D 0 0 4 D 0 0 68 68 68 68 68 84 84 84 14 84 68 GB 68 102 116 88 145 145 145 88 4 a7 honda prelude 38 honda accord 39 honda civic 40 honda civic (auto) 41 in D Max 42 uzu D-Max V Cross 1a madara 44 maxda glc deluxe 45 marda 2 coupe 46 mazda rx 4 47 mazda glc deluxe mazda 626 49 mazda el custom 50 mazda glc custom 51 mazda rx-4 52 mazda 626 53 mitsubishi mirage 54 mitsubishi lancer 55 mitsubishi Outlandet 55 mitsubishi 57 mitsubishi mirage 58 mitsubishi 50 mitsubishi Outlander 50 mitsubishi 4 61 mitsubishi mirage 52 mitsubishi Montero ta mitsubishi pajero 64 mitsubishi Outlander 65 mitsubishi mirage 84 56 Nissan Ver 67 nisam rogue 6 nissan latio Le cantitat 70 niscan leaf 71 nisanju 77 nissan latio 73 nico Instructions 0 0 8845 110 10295 110 12945 110 10343 110 8917 90 8917 90 5195 91 G095 91 6795 91 6695 91 7395 91 8845 122 8495 172 10595 122 10245 122 11245 122 5389 92 6189 92 6609 92 7688 98 9959 110 8499 122 12629 156 14869 156 14.489 156 0989 122 3189 122 9229 110 9279 110 5499 97 92 5849 97 7349 97 7200 97 7799 97 7499 97 2999 97 An GIt 4 4 4 4 0 D 0 0 1 1 0 1 1 1 0 D 1 0 0 D 4 4 4 D o I 1 0 1 1 1 25 27 27 29 22 22 22 29 29 27 27 34 34 34 4 4 1 116 116 D 1 4 D 4 4 4 69 69 69 0 D D 0 9 69 4 4 4 a 0 34 34 34 0 69 4 69 4 D D 34 E E 1 0 34 odige TOR 2009 130 1 T 1 5572 olymouthtung 1 DE 1 lututungan sede 4 + 3 3F=*==*} X1 YJZS: D 1 0 4 4 4 4 4 3 0 0 121 97 738 108 108 108 108 108 32 99 7 1 B 0 0 4 0 0 4 0 0 0 98 1 V 0 D 98 122 122 0 0 0 0 0 30 30 30 31 0 1 4 1 4 4 3 3 4 4 4 4 $ 3 O 83 3995 5ab TESO 12170 500 3893 1960 9999le 30ab33 18820 Subaru 5118 9nbarud 7053 Subaru 7129 94 subaru 7775 55 Subaru baie 9960 96 Subaru teria 7463 97 subotu tribeca 10130 98 topola corona mark 5348 99 tota corona 6339 100 corolla 1200 64 101 vota corona hard op 6910 102 toyota mark 6938 103 tota corolla 1200 7138 104 toyota corona 7738 105 topola corolla Bas 06 toyota marki 925 107 Lovol Corollo 8943 108 toyota corona 3938 109 tavola corolla 1998 Toda marki T24B mi volkswagen 1131 deluxe sedan 7975 112 volkwagen type 3 8195 Tavolwagen 3495 4 volkswagen desher 9995 115 vw dasher 1695 Tswabbit 9990 17 volkswagen dasher 12230 17 incando 13499 119 nissan fuga 14399 120 son olti 13499 121 chevrolet imala 5151 22fuck opel isundele 34184 122 buckokyo 35056 T24burch century special 40960 buid tego sport coupe turbo! 45000 1 porsche corne 31401 aita-romeo giulia 20tomoro stelvio 16500 189 6420 bmw 220 15925 131 MB 6765 22 D 10348 15200 4 cury Coug 8503 Luged 11900) ged 12440 5500 1689! 150 1050 12764 22016 odlik 3050 0230 ubac Walia 0441 3309 1199 122 109 109 109 109 109 0 GOODS 0 0 0 0 0 0 0 D 0 0 3 0 100 30 30 88 152 152 152 48 155 155 184 6 0 0 0 19 181 181 81 67 234 234 308 304 203 130 130 0 20 22 50 17 17 0 0 8 8 8 0 0 8 8 0 5 23 288 111 SETEL 0 0 0 0 0 0 D 0 D 0 0 D 0 18 111 113 140 140 4 4 4 4 4 4 4 4 4 4 4 0 101 *01 78 90 120 175 97 97 95 3 97 142 145 143 0 1 0 per PONO 0 mo surpro.rn in 120 120 120 120 134 56 151 4 98 CCA WI 112 112 115 0 OR 90 11 14 0 Instructions Answers Questic A150 toyota tercel D E F B 999 146 0 0 116 116 4 4 0 0 116 4 O 27 27 27 27 26 26 4 0 116 114 4 114 4 D 146 146 146 141 141 141 141 130 130 141 0 0 4 114 114 0 0 4 1 1 4 4 1 162 162 114 160 114 1 O 4 0 4 1 1 1 1 4 0 149 toyota starlet 150 toyota tercel 151 toyota corolla 152 toyota cressida 153 volvo 1450 (sw) 154 volvo 144ea 155 volvo 244d1 156 volvo 245 157 volvo 2648! 158 volve diesel 159 volvo 145e(sw) 160 volvo 144ea 151 volve 26481 162 alfa romero Quadrifoglio 13 bmw x1 164 bmw xa 165 bmw 14 166 bmw x4 167 bnw x5 16 bmw x3 169 170 jaguar x 171 nissen teana 172 nissan kicks 173 nisan clipper 174 poechce panamera 175 porsche Cayenne 176 porsche boxter 177 toyota corolla liittack 178 toyota corona 17 toyota starlet 1180 toyoute tercel 181 volvo 24441 154 121 121 0 0 141 141 152 164 164 164 209 209 6 6 6 0 6 0 D 11199 11549 17669 12940 13415 15985 16515 18420 18950 16845 19045 22625 16500 20970 21105 24565 30750) 41315 36880 32250 35550 17199 19699 18399 32528 34028 37028 16558 15998 15690 15750 21485 IX) 10945 11H45 11145 15 26 26 20 20 25 22 22 22 25 25 23 19 19 18 17 17 22 20 22 21 21 0 0 6 6 0 0 209 6 0 D O 0 D 0 0 1 1 121 182 182 182 176 176 160 200 160 207 207 207 161 161 156 156 134 22 6 6 0 5 0 0 0 0 6 22 258 181 181 181 196 194 1414 171 171 171 161 173 126 70 vo 20 no 0 6 6 0 0 22 22 31 0 183626 0 0 0 0 D o 0 0 D 12 2 2 2 101 101 101 20 20 20 20 0 0