Use Excel to Answer. A random sample of six cars from a particular model year had the...

90.2K

Verified Solution

Question

Basic Math

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

Answer & Explanation Solved by verified expert

4.3 Ratings (669 Votes)

ANSObsX128621843192425851946205SUM 1319MEAN 2198333STD DEV4190664alpha010 size6We find mean and sample standard deviation using ExcelformulaFor meanAVERAGEB2B6 and then press ENTER Excelreturns value 2198333For sample standard deviationSTDEVSB2B6and then press ENTER Excel returns value See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member