ANSWER USING CELL REFERENCE Sear Sheet Layout TsCharts Fill | Calibri (Body} -11

Question

ANSWER USING CELL REFERENCE

Sear Sheet Layout TsCharts Fill | Calibri (Body} -11 Clear |BI Home | Data abe Normal 2 Normal 2 2 Normal 3 Normal 4 Insert Delete FermatThemes Aa 82 69 70The 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 fora 7smilar problem.) Use the data in the FuelData sheet in this workbook to generate excel output to answer the following questions. Please note that units 72are "liters" for engine size and "miles per gallon" for highway fuel efficiency. Put the output in given space on FuelData sheet. Each orange numerical 73 answer cell below MUST reference generated Excel output cells in the FuelData sheet. 74 75 76 What is range for engine size? 78 79 80 81 82 83 84 85 86 87 Question SA Question 58 What is the variance for highway fuel effidiency? Question 5C What is IQR for engine size? 89 90 91 92 93 94 95 96 97 98 Question 6 What is the shape of the highway fuel efficiency distribution? Why? INOTE 1: Skewed right must select>, skewed left must select

Explanation / Answer

5a Range = maximum- minimum
= 4.48 - 1.71
= 2.77
5b. Variance = sum(xi-mean)^2/(n-1); where n is sample size. In excel pl use the formula: "=VAR.S(data)"

= 74.31553
5c . IQR is interquartile range = 3rd quartile - 1st quartile
=3.5275-2.4375
= 1.09

7)empirical rule , 99.7 %    3 sd

excel formulation below

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 A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.