Use Excel to Answer.
A random sample of six cars from aparticular model year had the fuel consumption figures, measure inmiles per gallon, shown below.
- Using T.INV, find a 90% confidence interval for the populationmean of fuel consumption for cars of this model year. Assume thedistribution is normal. (Round to 2 digits, since ourraw data below are expressed with one digit.) (Show work in spaceprovided.)
(ii) Calculate the same interval usingCONFIDENCE.T. (Show work in space provided.)
(iii) Calculate the same intervalusing T.INV.2T.
(Note: when calculating the lower andupper bounds of the interval, do not use a rounded mean that you’vecalculated with AVERAGE. Use the unrounded mean. Roundonly the final answers, which are the lower and upper bounds of theinterval. Also, make sure to use STDEV.S to calculate thesample standard deviation.)
Data:
28.6
18.4
19.2
25.8
19.4
20.5
