Question

Note: Ahswer Questions S-8 Dy Using the Excel output The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. (See exercise 35 on page 63 in your textbook for a similar problem.) Use the data in the FuelData sheet in this workbook to generate excel output to answer the following questions. Please note that units are "liters" for engine size and "miles per gallon" for highway fuel efficiency. Put the output in given space on FuelData sheet. Each orange numerical answer cell below MUST reference generated Excel output cells in the FuelData sheet. Question 5A What is range for enginesize? Question 5B What is the variance for highway fuel efficiency? Question 5C What is IQR for enginesize? Question 6 What is the shape of the highway fuel efficiency distribution? Why? NOTE 1:Skewed fight must select>,s kewed left must select < NOTE 2: The shape of the distribution is based on the formatted 4-decimal numbers showing in your output because Question 7 rule predicts that percent of the enginesize datashould lie between 12774 and 3.7797 liters, which are+ standard deviation s) away from the mean. Question 8 What varied the most in this study,engine size or highway fuel efficiency? Prove using the best measure of variability varied the most. Proof: Engine Size Hwy Fuel Efficiency

Answer 1