A town official claims that the average vehicle in their area sells formore 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 azort-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.

Make	Model	Price
GMC	1500	81900
Jeep	Wrangler	44000
Harley	Road King	19929
Chevy	Corvette	60900
Ram	1500	36500
ford	150	31520
chevy	1500	34600
Toyota	Tundra	35950
Toyota	Tacoma	27150
Ford	Ranger	25930
	Mean	39837.9
	Medium	35275
	SD	18570.6237

Column1
Mean	39837.9
Standard Error	5872.54684
Median	35275
Mode	#N/A
Standard Deviation	18570.6237
Sample Variance	344868064
Kurtosis	2.18179803
Skewness	1.52658474
Range	61971
Minimum	19929
Maximum	81900
Sum	398379
Count	10
Confidence Level(95.0%)	13284.6239

Mean	39837.9
Confidence Level(95.0%)	13284.6239
Lower	26553.2761
Higher	53122.5239