A town official claims that the average vehicle in their area sells for more than the 40th percentile of your data set. Using th
e data, you obtained in week 1, as well as the summary statistics you found for the original data set (excluding the super car outlier), run a hypothesis test to determine if the claim can be supported. Make sure you state all the important values, so your fellow classmates can use them to run a hypothesis test as well. Use alpha = .05 to test your claim.(Note: You will want to use the function =PERCENTILE.INC in Excel to find the 40th percentile of your data set)First determine if you are using a z or t-test and explain why. Then conduct a four-step hypothesis test including a sentence at the end justifying the support or lack of support for the claim and why you made that choice.$29,925$46,561$46,711$29,235$42,342$27,249$60,428$59,512$49,196$82,135With Original 10Mean 47329.4Median 46636Standard Deviation 16978.06749Count 10