In Excel, Using the data set you collected in Week 1, excluding the super car outlier, you should have calculated the mean and standard deviation during Week 2 for price data. Along with finding a p and q from Week 3. Using this information, calculate two 95% confidence intervals. For the first interval you need to calculate a T-confidence interval for the sample population. You have the mean, standard deviation and the sample size, all you have left to find is the T-critical value and you can calculate the interval. For the second interval calculate a proportion confidence interval using the proportion of the number of cars that fall below the average. You have the p, q, and n, all that is left is calculating a Z-critical value,

Make sure you include these values in your post, so your fellow classmates can use them to calculate their own confidence intervals. Once you calculate the confidence intervals you will need to interpret your interval and explain what this means in words.

Do the confidence intervals surprise you, knowing what you have learned about confidence intervals, proportions and normal distribution? Please the Week 5 Confidence T-Interval Mean and Unknown SD PDF and the Week 5 Confidence Interval Proportions PDF at the bottom of the discussion. This will give you a step by step example on how to help you calculate this using Excel. These PDFs will also help you in Quizzes section.

Year	Make	Model	Price	MPG (city)	MPG (highway)	Drivetrain
2019	Toyota	4runner	$ 39,987	17	20	4WD
2019	Toyota	Camry	$ 31,987	19	39	4WD
2019	Ford	Explora	$ 26,776	16	22	4WD
2019	Genesis	GV70	$ 31,987	22	28	AWD
2019	Kia	Seltos	$ 30,587	27	31	AWD
2019	Toyota	Rav4	$ 35,363	27	34	AWD
2020	Hyundai	Palisade	$ 34,302	19	26	4WD
2020	Honda	CR-V	$ 34,323	40	35	4WD
2021	Ford	Escape	$ 34,339	23	31	AWD
2019	Chevrolet	Silverado	$ 43,657	16	22	4WD

Average $34,331

p= 0.6

q =0.4

n=10