A town official claims that the average vehicle in their area sells formore thanthe 40thpercentile 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, run a hypothesis test to determine if the claim can be supported.Make sure you state all the important values. Use alpha = .05 to test your claim. You will want to use the function =PERCENTILE.INCin Excel to find the 40thpercentile of your data set.

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.

Numbers below

Mean= 46972.5

Standard Error= 7926.00590356412

Median= 39782.5

Standard Deviation= 25064.2314032035

Sample Variance= 628215695.833333

Range 83165

Minimum 24010

Maximum 107175

Sum 469725

Count 10

Confidence Level(95.0%) 17929.8710271284

Car Price

24,010

28,265

29,635

31,430

32,785

46,780

51,415

52,250

65,980

107,175