Please see the link for spreadsheets or see screenshots below:

DJ-ulUTIU'I-B-LAJNl VEHICLE ELJZDMB [mpg]:l2 EMISSIONS [g'km] MI MI MI MI MI | MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI p. VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN B C 23 232 23 232 2? 233 24 233 2? 244 2? 244 23 223 23 223 23 232 24 2?1 23 2?3 22 234 22 232 23 324 21 334 32 235 33 233 25 233 24 23? 24 2?4 23 233 23 253 23 243 25 233 23 253 25 233 23 243 25 233 24 2?4 23 233 23 233 24 233 23 233 21 313 24 23? 21 313 13 333 24 23? 24 233 23 243 25 233 24 2?4 23 233 23 233 23 253 23 243 43 43 53 51 52 53 54 55 53 5? 53 53 33 31 32 33 34 35 33 3? 33 33 T3 T1 T2 T3 T4 T5 73 T? 73 73 33 31 32 33 34 35 33 3? 33 33 33 31 32 33 34 MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN 25 25 24 23 23 23 23 23 23 23 23 24 22 22 22 21 21 33 23 24 22 25 25 24 25 25 24 22 24 22 21 25 24 24 23 13 25 25 25 24 22 25 25 24 23 2? 25 233 233 23? 251 232 251 232 251 232 251 232 2?1 233 232 234 315 313 233 243 32 53 53 3? 53 53 3? 32 ?3 34 33 32 3? 3? 233 333 255 253 253 23? 232 253 253 23? 243 242 255 MMLAJMNMNMNMNMN [\\J 85 88 8? 88 88 100 101 102 103 104 105 108 10? 108 108 110 111 112 113 114 115 118 11? 118 118 120 121 122 123 124 125 Ml MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI 125 |MI 12? 128 128 130 131 132 133 134 135 138 13? 138 138 140 141 Ml MI MI MI MI MI MI MI MI MI MI MI MI MI VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN VAN 2? 25 28 2? 25 2? 25 24 22 24 24 22 28 25 24 28 25 24 22 23 23 21 25 24 23 18 24 28 25 24 22 $1 24 24 28 28 28 28 28 24 24 23 25 28 25 24 242 255 248 242 255 242 255 2?1 280 2?4 28? 28? 248 280 28? 248 280 28? 28? 281 283 315 282 2?1 288 343 2?4 248 280 28? 28? 248 280 28? 2?4 235 235 223 235 235 2?8 288 283 255 248 280 288 142 MINIVAN 25 255 143 MINIVAN 26 246 144 MINIVAN 25 260 145 MINIVAN 24 269 146 MINIVAN 23 283 147 MINIVAN 25 258 148 MINIVAN 24 269 149 MINIVAN 22 297 150 MINIVAN 19 343 151 MINIVAN 24 267 152 MINIVAN 24 267 153 MINIVAN 24 276 154 MINIVAN 25 255 155 MINIVAN 26 246 156 MINIVAN 25 260 157 MINIVAN 24 269 158 MINIVAN 23 283 159 MINIVAN 25 255 160 MINIVAN 26 246 161 MINIVAN 25 260 162 MINIVAN 24 269 163 MINIVAN 24 276 164 MINIVAN 25 255 165 MINIVAN 24 267 166 MINIVAN 24 269 167 MINIVAN 23 283 168 MINIVAN 26 246 169 MINIVAN 25 262 170 MINIVAN 24 269 171 MINIVAN 26 246 172 MINIVAN 25 262 173 MINIVAN 24 269 174 MINIVAN 24 274 175 MINIVAN 23 283 176 MINIVAN 22 290 177 MINIVAN 24 274 178 MINIVAN 24 274 179 MINIVAN 25 255 180 MINIVAN 24 267 181 MINIVAN 24 267 182 MINIVAN 26 246 183 MINIVAN 25 262 184 MINIVAN 24 269 185 MINIVAN 23 283 186 MINIVAN 26 246 187 MINIVAN 25 262\f\f\f\f\f\f\f\f\fUnderstanding the Table Model 4WD/4X4 = Four-wheel drive AWD = All-wheel drive CNG = Compressed natural gas FFV = Flexible-fuel vehicle NGV = Natural gas vehicle # = High output engine that provides more power than the standard engine of the same size Transmission A = Automatic AM = Automated manual AS = Automatic with select shift AV = Continuously variable M = Manual 3-10 = Number of gears Fuel Type X = Regular gasoline Z = Premium gasoline D = Diesel E = Ethanol (E85) N = Natural Gas Fuel Consumption City and highway fuel consumption ratings are shown in litres per 100 kilometres (L/100 km) - combined rating (55% city, 45% hwy) is shown in L/100 km and in miles per imperial gallon (mpg) CO2 Emissions (g/km) Estimated tailpipe carbon dioxide emissions ( in grams per kilometre) are based on fuel type and the combined fuel consumption rating.Question 1: Place in this spreadsheet the data on SUVs and Minivans. Your variables of interest are COMB {mpg} and C02 Emissions {g/km}. Question 2: Place in this spreadsheet the data on SUVs and Minivans. Yourvariables of interest are COMB {mpg} and C02 Emissions {g/km}. - Use the text boxes provided for your analysis. This applies to all answers. - Use bullet points. Question 3: Construct histograms for COMB {mpg} for each vehicle class. How do you compare them with your findings in C12? Question 4: Test whether the COMB {mpg} for SUVs and minivans are significantly different at the 5% level of significance. 3. Develop the appropriate hypotheses and perform the test. b. What is your conclusion based on yourtest result? Question 5: Investigate the relationship between COMB {mpg} and CO2 Emissions {g/km} for both the vehicle classes. a. Construct and interpret the scatterplot to show how changes in COMB (mpg) changes C02 Emissions {g/km). Show the regression equation and R2 on the plot. b. Generate the regression output. c. Analyze the slope, the correlation coefficient and coefficient of determination. Use bullet points. d. Interpret the estimation equation. e. Perform the test to conclude if the linear model describes the relationship between COMB {mpg} and C02 Emissions {g/km} for both the vehicle classes