A town official claims that the average vehicle in their area sells for more thanthe 40^thpercentile of your data set. Using the data below, as well as the summary statistics you found for the original data set, 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 40^thpercentile 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.

Vehicle type/class Year Make Model Price MPG (city) MPG (highway) Cargo Space (cu ft) Reason for Choice SUV 1999 Cadillac Escalade 4710 11 15 118.2 First vehicle purchased. SUV 2009 Cadillac Escalade 17104 12 19 108.9 Second vehicle purchased. Truck 2001 Chevrolet Silverado 3668 13 16 First truck driven loaned to me by my dad. Car 2015 Chevrolet Malibu 14388 25 36 16.3 Vehicle my wife drives SUV 2017 Cadillac Escalade 53368 15 20 15.2 Vehicle my grandfather drives Car 2002 Volkswagen ioH 3825 21 28 18 Vehicle that I owned and drove in Germany. Truck 2010 GM Yukon 11140 21 22 108.9 Vehicle that I a Car 2021 Audi A8 87545 17 26 12.5 Vehicle that my wife would like to upgrade to. Car 201 Infiniti EX 15201 17 24 18.6 one of y roommate Car 2006 Mercedes-Benz S-350 6759 16 23 15.4 Vehicle that one of my roommates drives. Qualitative Qualitative Qualitative Qualitative Quantitative Quantitative Quantitative Quantitative Mean 22270.8 16.8 22.9 43.2 The mean for the MPG was not that far off from the median when it comes to Median 12764 16.5 22.5 17.2 MPG for the vehicles. The deviation was fairly high for the price since some bordered on the lower end and some on the higher end. When it came to Deviation 25621.8 4.2 5.8 45.4 cargo space you could see that the truck threw off the calculations since it technically has no cargo space aside from the bed of the truck