Please I need anzwers

1. Please classify all variables you have collected into types. Explain why these variables belong to the partiluar type and measurement. 2. Do foreign and domestic cars differ in their prices? If so how? Use graphical (box plot) and numeric methods to compare two groups? (hint comment on average, median prices and variations in prices) 3. What is the distribution of cars according to their Repair Record 1978? Please draw a relevant graph (pie chart, bar chart, histogram or another graph that you think is relevant) and comment 4. Calculate the coefficient of correlation and coefficient of determination between car price and a variable that you think impacts the most the price of used car. What does the statistic calculated in question (3) tell. 5. What cars are well overpriced and which ones are underpriced? Please give relevant statistics to show these outlier cases. 6. Based on your analysis what car do you recommend you friend to buy and what cars you recommend to avoid. For each recommendation must be supported by your analysis. c E F 1 M H 196 222 218 170 200 16 20 21 10 16 17 13 20 16 13 207 40 43 43 34 42 43 42 44 43 45 34 43 31 41 40 43 35 46 46 46 J 196 350 231 304 196 231 231 425 350 350 231 250 200 200 151 250 98 318 318 225 98 140 400 400 302 140 302 N. 43 51 41 39 302 5 Buick Century 6 Buick Electra 7 Buick LeSabre 8 Buick Opel 9 Buick Regal 10 Buick Riviera 11 Buick Skylark 12 Cad, Deville 13 Cad. Eldorado 14 Cad. Seville 15 Chev. Chevette 16 Chev. Impala 17 Chev. Malibu 18 Chev. Monte Carlo 19 Chev. Monas 20 Chev. Nova 21 Dodge Colt 22 Dodge Diplomat 23 Dodge Magnum 24 Dodge St. Regis 25 Ford Fiesta 26 Ford Mustang 27 Linc. Continental 28 Linc. Mark V 29 Linc. Versailles 30 Merc. Bobcat 31 Merc. Cougar 32 Merc. Marquis 33 Merc. Monarch 34 Merc. XR-7 35 Merc. Zephyr 36 Olds 98 37 Olds Cutl Supr 38 Olds Cutlase 39 Olds Delta 88 40 Olds Omega 41 Olds Starfire 42 Old: Toronado 43 Plym. Arrow 44 Plym. Champ 45 Plym. Horizon 46 Plym. Sapporo 47 Plym. Volare 48 Pont. Catalina 49 Pont. Firebird 50 Pont. Grand Prix 51 Pont. Le Mono 52 Pont. Phoenix 53 Pont. Sunbird 54 Audi 5000 55 Audi Fox 56 BMW 320i 57 Datsun 200 58 Datsun 210 59 Datsun 510 60 Datsun 810 61 Fiat Strada 62 Honda Accord 63 Honda Civic 64 Mazda GLC 65 Peugeot 604 66 Renault Le Car 67 Subaru 68 Toyota Celica 69 Toyota Corolla 70 Toyota Corona 71 VW Docher 72 VW Diesel 73 VW Rabbit 74 VW Scirocco 75 Volvo 260 76 B 4816 7827 5788 4453 5189 10372 4082 11385 14500 15906 3299 5705 4504 5104 3667 3955 3984 4010 5886 6342 4389 4187 11497 13594 13466 3829 5379 6165 4516 6303 3291 8814 5172 4733 4890 4181 4195 10371 4647 4425 4482 6486 4060 5798 4934 5222 4723 4424 4172 9690 6295 9735 6229 4589 5079 8129 4296 5799 4499 3995 12990 3895 3798 5899 3748 5719 7140 5397 4697 6850 11995 20 17 16 7 13 8 17 17 21 9 10 22 18 15 9 16 23 15 16 17 20 16 16 20 14 10 17 11 11 17 44 41 45 43 43 42 42 42 D 20 Average 15 Good 18 Average 26 20 Average 16 Average 19 Average 14 Average 14 Fair 21 Average 29 Average 16 Good 22 Average 22 Fair 24 Fair 19 Average 30 Excellent 18 Fair 16 Fair 17 Fair 28 Good 21 Average 12 Average 12 Average 14 Average 22 Good 14 Good 15 Average 18 Average 14 Good 20 Average 21 Good 19 Average 19 Average 18 Good 19 Average 24 Poor 16 Average 28 Average 34 Excellent 25 Average 26 18 Fair 18 Good 18 Poor 19 Average 19 Average 19 24 Fair 17 Excellent 23 Average 25 Good 23 Good 35 Excellent 24 Good 21 Good 21 Average 25 Excellent 28 Good 30 Good 14 26 Average 35 Excellent 18 Excellent 31 Excellent 18 Excellent 23 Good 41 Excellent 25 Good 25 Good 17 Excellent 4.5 4 4 3 2 3.5 3.5 4 3.5 3 2.5 4 3.5 2 2 3.5 2 4 4 4.5 1.5 2 3.5 2.5 3.5 3 3.5 3.5 3 3 3.5 4 2 4.5 4 4.5 2 3.5 2 2.5 4 1.5 5 4 1.5 2 3.5 3.5 2 3 2.5 2.5 1.5 2 2.5 2.5 2.5 3 2.5 3.5 3.5 3 2.5 2.5 G 3250 4080 3670 2230 3280 3880 3400 4330 3900 4290 2110 3690 3180 3220 2750 3430 2120 3600 3600 3740 1800 2650 4840 4720 3830 2580 4060 3720 3370 4130 2830 4060 3310 3300 3690 3370 2730 4030 3260 1800 2200 2520 3330 3700 3470 3210 3200 3420 2690 2830 2070 2650 2370 2020 2280 2750 2130 2240 1760 1980 3420 1830 2050 2410 2200 2670 2160 2040 1930 1990 3170 200 221 204 204 163 212 193 200 179 197 163 206 206 220 147 179 233 230 201 169 221 212 198 217 195 220 198 198 218 200 180 206 170 157 165 182 201 214 198 201 199 203 179 189 174 177 170 165 170 184 161 172 149 154 192 142 164 174 165 175 172 155 155 156 193 K L 2.93 Domestic 2.41 Domestic 2.73 Domestic 2.87 Domestic 2.93 Domestic 2.93 Domestic 3.08 Domestic 2.28 Domestic 2.19 Domestic 2.24 Domestic 2.93 Domestic 2.56 Domestic 2.73 Domestic 2.73 Domestic 2.73 Domestic 2.56 Domestic 3.54 Domestic 2.47 Domestic 2.47 Domestic 2.94 Domestic 3.15 Domestic 3.08 Domestic 2.47 Domestic 2.47 Domestic 2.47 Domestic 2.73 Domestic 2.75 Domestic 2.26 Domestic 2.43 Domestic 2.75 Domestic 3.08 Domestic 2.41 Domestic 2.93 Domestic 2.93 Domestic 2.73 Domestic 3.08 Domestic 2.73 Domestic 2.41 Dometic 3.05 Domestic 2.97 Domestic 3.37 Domestic 3.54 Domestic 3.23 Domestic 2.73 Domestic 3.08 Domestic 2.93 Domestic 2.93 Domestic 3.08 Domestic 2.73 Domestic 3.2 Foreign 3.7 Foreign 3.64 Foreign 3.89 Foreign 3.7 Foreign 3.54 Foreign 3.55 Foreign 3.37 Foreign 3.05 Foreign 3.3 Foreign 3.73 Foreign 3.58 Foreign 3.72 Foreign 3.81 Foreign 3.06 Foreign 3.21 Foreign 3.05 Foreign 3.74 Foreign 3.76 Foreign 3.78 Foreign 3.78 Foreign 2.98 Foreign 16 20 7 16 17 13 7 15 11 12 6 250 302 140 350 231 231 231 231 151 350 156 86 105 119 225 231 231 231 231 231 151 131 97 121 119 85 119 146 105 107 91 86 163 79 97 134 97 134 97 90 40 43 37 37 36 38 44 42 42 45 40 43 41 37 36 34 35 34 36 36 34 33 8 8 16 10 5 11 14 10 11 14 9 11 12 15 15 16 14 2 2.5 3 3 2 2.5 34 36 36 35 36 36 35 35 36 37 97 163 Sheet1 1. Please classify all variables you have collected into types. Explain why these variables belong to the partiluar type and measurement. 2. Do foreign and domestic cars differ in their prices? If so how? Use graphical (box plot) and numeric methods to compare two groups? (hint comment on average, median prices and variations in prices) 3. What is the distribution of cars according to their Repair Record 1978? Please draw a relevant graph (pie chart, bar chart, histogram or another graph that you think is relevant) and comment 4. Calculate the coefficient of correlation and coefficient of determination between car price and a variable that you think impacts the most the price of used car. What does the statistic calculated in question (3) tell. 5. What cars are well overpriced and which ones are underpriced? Please give relevant statistics to show these outlier cases. 6. Based on your analysis what car do you recommend you friend to buy and what cars you recommend to avoid. For each recommendation must be supported by your analysis. c E F 1 M H 196 222 218 170 200 16 20 21 10 16 17 13 20 16 13 207 40 43 43 34 42 43 42 44 43 45 34 43 31 41 40 43 35 46 46 46 J 196 350 231 304 196 231 231 425 350 350 231 250 200 200 151 250 98 318 318 225 98 140 400 400 302 140 302 N. 43 51 41 39 302 5 Buick Century 6 Buick Electra 7 Buick LeSabre 8 Buick Opel 9 Buick Regal 10 Buick Riviera 11 Buick Skylark 12 Cad, Deville 13 Cad. Eldorado 14 Cad. Seville 15 Chev. Chevette 16 Chev. Impala 17 Chev. Malibu 18 Chev. Monte Carlo 19 Chev. Monas 20 Chev. Nova 21 Dodge Colt 22 Dodge Diplomat 23 Dodge Magnum 24 Dodge St. Regis 25 Ford Fiesta 26 Ford Mustang 27 Linc. Continental 28 Linc. Mark V 29 Linc. Versailles 30 Merc. Bobcat 31 Merc. Cougar 32 Merc. Marquis 33 Merc. Monarch 34 Merc. XR-7 35 Merc. Zephyr 36 Olds 98 37 Olds Cutl Supr 38 Olds Cutlase 39 Olds Delta 88 40 Olds Omega 41 Olds Starfire 42 Old: Toronado 43 Plym. Arrow 44 Plym. Champ 45 Plym. Horizon 46 Plym. Sapporo 47 Plym. Volare 48 Pont. Catalina 49 Pont. Firebird 50 Pont. Grand Prix 51 Pont. Le Mono 52 Pont. Phoenix 53 Pont. Sunbird 54 Audi 5000 55 Audi Fox 56 BMW 320i 57 Datsun 200 58 Datsun 210 59 Datsun 510 60 Datsun 810 61 Fiat Strada 62 Honda Accord 63 Honda Civic 64 Mazda GLC 65 Peugeot 604 66 Renault Le Car 67 Subaru 68 Toyota Celica 69 Toyota Corolla 70 Toyota Corona 71 VW Docher 72 VW Diesel 73 VW Rabbit 74 VW Scirocco 75 Volvo 260 76 B 4816 7827 5788 4453 5189 10372 4082 11385 14500 15906 3299 5705 4504 5104 3667 3955 3984 4010 5886 6342 4389 4187 11497 13594 13466 3829 5379 6165 4516 6303 3291 8814 5172 4733 4890 4181 4195 10371 4647 4425 4482 6486 4060 5798 4934 5222 4723 4424 4172 9690 6295 9735 6229 4589 5079 8129 4296 5799 4499 3995 12990 3895 3798 5899 3748 5719 7140 5397 4697 6850 11995 20 17 16 7 13 8 17 17 21 9 10 22 18 15 9 16 23 15 16 17 20 16 16 20 14 10 17 11 11 17 44 41 45 43 43 42 42 42 D 20 Average 15 Good 18 Average 26 20 Average 16 Average 19 Average 14 Average 14 Fair 21 Average 29 Average 16 Good 22 Average 22 Fair 24 Fair 19 Average 30 Excellent 18 Fair 16 Fair 17 Fair 28 Good 21 Average 12 Average 12 Average 14 Average 22 Good 14 Good 15 Average 18 Average 14 Good 20 Average 21 Good 19 Average 19 Average 18 Good 19 Average 24 Poor 16 Average 28 Average 34 Excellent 25 Average 26 18 Fair 18 Good 18 Poor 19 Average 19 Average 19 24 Fair 17 Excellent 23 Average 25 Good 23 Good 35 Excellent 24 Good 21 Good 21 Average 25 Excellent 28 Good 30 Good 14 26 Average 35 Excellent 18 Excellent 31 Excellent 18 Excellent 23 Good 41 Excellent 25 Good 25 Good 17 Excellent 4.5 4 4 3 2 3.5 3.5 4 3.5 3 2.5 4 3.5 2 2 3.5 2 4 4 4.5 1.5 2 3.5 2.5 3.5 3 3.5 3.5 3 3 3.5 4 2 4.5 4 4.5 2 3.5 2 2.5 4 1.5 5 4 1.5 2 3.5 3.5 2 3 2.5 2.5 1.5 2 2.5 2.5 2.5 3 2.5 3.5 3.5 3 2.5 2.5 G 3250 4080 3670 2230 3280 3880 3400 4330 3900 4290 2110 3690 3180 3220 2750 3430 2120 3600 3600 3740 1800 2650 4840 4720 3830 2580 4060 3720 3370 4130 2830 4060 3310 3300 3690 3370 2730 4030 3260 1800 2200 2520 3330 3700 3470 3210 3200 3420 2690 2830 2070 2650 2370 2020 2280 2750 2130 2240 1760 1980 3420 1830 2050 2410 2200 2670 2160 2040 1930 1990 3170 200 221 204 204 163 212 193 200 179 197 163 206 206 220 147 179 233 230 201 169 221 212 198 217 195 220 198 198 218 200 180 206 170 157 165 182 201 214 198 201 199 203 179 189 174 177 170 165 170 184 161 172 149 154 192 142 164 174 165 175 172 155 155 156 193 K L 2.93 Domestic 2.41 Domestic 2.73 Domestic 2.87 Domestic 2.93 Domestic 2.93 Domestic 3.08 Domestic 2.28 Domestic 2.19 Domestic 2.24 Domestic 2.93 Domestic 2.56 Domestic 2.73 Domestic 2.73 Domestic 2.73 Domestic 2.56 Domestic 3.54 Domestic 2.47 Domestic 2.47 Domestic 2.94 Domestic 3.15 Domestic 3.08 Domestic 2.47 Domestic 2.47 Domestic 2.47 Domestic 2.73 Domestic 2.75 Domestic 2.26 Domestic 2.43 Domestic 2.75 Domestic 3.08 Domestic 2.41 Domestic 2.93 Domestic 2.93 Domestic 2.73 Domestic 3.08 Domestic 2.73 Domestic 2.41 Dometic 3.05 Domestic 2.97 Domestic 3.37 Domestic 3.54 Domestic 3.23 Domestic 2.73 Domestic 3.08 Domestic 2.93 Domestic 2.93 Domestic 3.08 Domestic 2.73 Domestic 3.2 Foreign 3.7 Foreign 3.64 Foreign 3.89 Foreign 3.7 Foreign 3.54 Foreign 3.55 Foreign 3.37 Foreign 3.05 Foreign 3.3 Foreign 3.73 Foreign 3.58 Foreign 3.72 Foreign 3.81 Foreign 3.06 Foreign 3.21 Foreign 3.05 Foreign 3.74 Foreign 3.76 Foreign 3.78 Foreign 3.78 Foreign 2.98 Foreign 16 20 7 16 17 13 7 15 11 12 6 250 302 140 350 231 231 231 231 151 350 156 86 105 119 225 231 231 231 231 231 151 131 97 121 119 85 119 146 105 107 91 86 163 79 97 134 97 134 97 90 40 43 37 37 36 38 44 42 42 45 40 43 41 37 36 34 35 34 36 36 34 33 8 8 16 10 5 11 14 10 11 14 9 11 12 15 15 16 14 2 2.5 3 3 2 2.5 34 36 36 35 36 36 35 35 36 37 97 163 Sheet1