Engine Size Hwy Fuel Efficiency 3.82 23.00 3.96 41.00 2.77 46.00 2.90 43.00 1.98
ID: 3354652 • Letter: E
Question
Engine Size Hwy Fuel Efficiency 3.82 23.00 3.96 41.00 2.77 46.00 2.90 43.00 1.98 31.00 2.11 34.00 2.37 32.00 2.64 30.00 2.90 38.00 3.03 35.00 3.03 37.00 3.16 47.00 3.30 22.00 3.43 29.00 4.22 35.00 4.48 39.00 3.56 29.00 3.69 24.00 3.43 47.00 3.56 37.00 1.71 39.00 1.85 28.00 2.37 46.00 2.64 45.00 3.69 29.00 3.82 22.00 3.03 28.00 3.16 37.00 3.43 40.00 3.56 20.00 1.98 21.00 2.11 23.00 2.64 32.00 2.90 29.00 2.90 29.00 3.03 21.00 3.16 46.00 3.30 34.00 4.09 28.00 4.22 46.00 2.64 19.00 2.90 41.00 3.30 36.00 3.56 22.00 1.85 42.00 1.98 20.00 2.37 20.00 2.64 21.00 1.98 31.00 2.11 43.00 2.90 19.00 3.03 36.00 3.56 37.00 3.69 37.00 1.85 21.00 3.56 44.00 2.37 26.00 2.64 28.00 3.03 28.00 3.16 39.00 2.90 36.00 1.98 23.00 3.96 37.00 2.90 46.00 3.56 23.00 2.64 47.00 2.11 37.00 3.30 37.00 2.90 34.00 2.37 42.00 The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. (See exercise 35 on page 77 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 engine size? Question 5B What is the variance for highway fuel efficiency? Question 5C What is IQR for engine size? Question Whatis the shape of the highway fuel efficiency distribution? Why? INOTE 1: Skewed right must select?, skewed left must selects, etc.) NOTE 2: The shape of the distribution is based on the formatted 4-decimal numbers showing in your output. rule predicts th Question 7 percent of the enginesize data should lie between 0.9499 and 4.9829 liters, which are standard deviation(s)away from the mea 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 EfficiencyExplanation / Answer
5)
1. Range = maximum- minimum
= 4.48 - 1.71
= 2.77
2. Variance = sum(xi-mean)^2/(n-1); where n is sample size. In excel pl use the formula: "=VAR.S(data)"
= 74.31553
3. IQR is interquartile range = 3rd quartile - 1st quartile
=3.5275-2.4375
= 1.09
7)empirical rule , 99.7 % 3 sd
excel
Please rate
5a 5b 5c 1.71 74.31553 3.5275 4.48 2.4375 2.77 1.09 7) 2.966714 mean 0.671882 sd 0.951069 4.98236Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.