Vehicle Type/Class Year Make Model Price MPG (city) MPG (highway) Variable Pickup Truck 2018 Dodge RAM $48,400 22 20 Qualitive Pickup Truck 2018 Ford F150 $41,990 16 22 Qualitive Van 2020 KIA Sedona $30,400 18 24 Qualitive Pickup Truck 2022 Chevrolet Silverado $66,040 14 19 Qualitive SUV 2022 Chevrolet Tahoe $66,990 15 20 Qualitive Pickup Truck 2016 Toyota Tacoma $34,999 18 23 Qualitive Jeep 2019 Wrangler Sahara $41,057 22 24 Qualitive Pickup Truck 2021 GMC Canyon Denali $43,411 17 24 Qualitive Pickup Truck 2022 GMC Canyon Elevation $43,620 17 24 Qualitive Mean: $46,323 Median: $43,411 Mode: #N/A SD: 11852.17003 Sample Size: 11 P: 0.6 Q: 0.4Using 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 nding a p and g from Week 3. Using this information, calculate two 95% condence 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 Tcritical 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 Zcritical value, Make sure you include these values in your post, so your fellow classmates can use them to calculate their own condence intervals. Once you calculate the condence intervals you will need to interpret your interval and explain what this means in words. Do the condence intervals surprise you, knowing what you have learned about confidence intervals, proportions and normal distribution? Please the Week 5 Confidence TInterval' Mean and Unknown SD PDF and the Week 5 Confidence IntervalI 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