Please explain how to do this this is the table of info, sorry for the size, it

Question

Please explain how to do this

this is the table of info, sorry for the size, it was hard to fit everything within 2 pictures

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 5AWhat is range for engine size? Question 5B What is the variance for highway fuel efficiency? Question 5C What is IQR for engine size? Question6 What is the shape of the highway fuel efficiency distribution? Why? (NOTE 1: Skewed right must select skewed left must select

Explanation / Answer

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.98236

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---