Vehicle type/class	Year	Make	Model	Price	MPG (city)	MPG (highway)	Drive type
sedan	2021	toyota	camry XLE	$ 33,372.00	24	34	all-wheel drive
sedan	2021	Nissan	Altima 2.5 SV	$ 31,633.00	28	39	all-wheel drive
sedan	2021	Honda	Accord Hybrid Touring	$ 37,435.00	44	41	2 wheel drive - front
sedan	2021	Audi	A4 2.0T Premium	$ 48,765.00	24	34	All wheel drive
sedan	2021	Volkswagen	Arteon SE	$ 38,774.00	22	32	2 wheel drive - front
sedan	2022	toyota	Prius Prime LE	$ 28,220.00	55	54	2 wheel drive - front
crossover	2021	Subaru	Crosstrek 2.0i Premium	$ 28,827.00	28	33	All wheel drive
sedan	2022	Hyundai	Accent SEL	$ 17,940.00	33	41	2 wheel drive - front
sedan	2020	Hyundai	Elantra SEL	$ 19,300.00	31	41	2 wheel drive - front
Hatchback	2021	maza	MAZDA3	$ 35,220.00	23	31	All wheel drive
			Mean	$ 31,948.60
			Median	$ 32,502.50
			SD	9141.969812
			Sample size	10
			p	0.5
			q	0.5

A town official claims that the average vehicle in their area sells for more thanthe 40^thpercentile of your data set. Using the 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 the descriptive statistics you found during Week 2 NOT the new SD you found during Week 4. Because again, we are using the original 10 sample data set NOT a new smaller sample size. 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. Hopefully this Excel function looks familiar to you from Week 2.)

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.