Five years ago, an automobile manufacturer started offering an extended warranty to buyers of its sport-utility vehicle.

Five years ago, an automobile manufacturer started offering an extended warranty to buyers of its sport-utility vehicle.  The extended warranty covered defects occurring after the initial three-year warranty expired.  Of the 10,000 people who bought the sport-utility vehicle in the first year of the program, 15% purchased the extended warranty.  In the Warranty Department, you have recently received data on a random sample of 200 of the cars sold in the first year that the extended warranty was available. For this sample, the average extended-warranty expenditure per car for the one-year period after the initial warranty elapsed was $350., with a standard deviation of $100.a.  What is a 95 percent confidence interval for the mean one-year extended-warranty expenditure per automobile?b.  At its introduction, the extended warranty was priced at $224 per year per automobile.  Compute a 95 percent confidence interval for the one-year profitability of the extended warranty.c.  How large a sample would the Warranty Department require if it wanted its 95 percent confidence interval for the mean warranty expenditure to be no more than+_$5*Please show all work, use excel and identify the value and units measured.

sample mean (m)=sample size (n) =standard deviation (s)=a) $350200100 For 95% confidence interval, alpha =t critical for 95% interval=So, standard error for 95% confidence = 0.051.972=...