Using the data set you collected in Week 1, excluding the su

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 forum. 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 Tests&Quizzes tab.Instructions: Your initial post should be at least 150 words.WEEK 1 DATA:STATISTICSVehicle TypeYearMakeModelPriceMPG (City)MPG (highway)CylindersSUV2019FordEscape$24,10523304SUV2020ChevroletTraverse$29,80018274SUV2020SubaruAscent$31,99521274SUV2019Toyota4runner$35,31017216Car2018FordFocus$17,95030404Car2020ToyotaPrius$24,20058534Car2019HyundaiSonata$22,65028374Car2019ChevroletImpala$28,02022296Truck2019FordF-150$28,15522306Truck2019ChevroletSilverado$28,30020236QualitativeQualitativeQualitativeQualitativeQuantitiveQuantitiveQuantitiveQuantitive