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 alpha = .05 to test your claim.

(Note: You will want to use the function =PERCENTILE.INCin 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.

Sample size Below:

21,989

48,993

16,900

23,416

28,190

22,441

37,718

21,920

mean

31,565

median

25,803

SD

13458.25

Sample size

10