3. Open the EXCEL file Car Weights and Mileage. a) Which is the explanatory variable? Which is the response variable? [2 points] b) Use the EXCEL functions to find the mean

and standard deviation of the mileage variable? [4 points] c) Give the weight and mileage for the heaviest car. [2 points] d) What is the correlation statistic? Based on this statistic, describe the relationship between weight and mileage. [4 points] e) Convert miles per gallon to kilometers per gallon in EXCEL:=miles*1.609 [2 points] f) Calculate the z-scores for miles per gallon and kilometers per gallon in EXCEL. Why are the z-scores the same? [4 points] g) For the Mercedes Benz, interpret the meaning of the z-score. [2 points]