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 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.

week number 1

Vehicle	Year	Make	Model	Sub Model	Retail	MPG/City	MPG/Hwy	Drive type	HP	TORQUE	Weight
Truck	2022	RAM	1500	TRX	91,000	9	12	F4WD	702	650	6,439 lbs
Truck	2023	Ford	F150	Raptor R	96,000	12	17	4WD	700	645	6,050 lbs
CAR	2023	Chevrolet	Corvette	3LT	76,000	15	27	RWD	670	460	3,366 lbs
CAR	2022	Honda	Civic	Type R	37,950	22	28	FWD	306	295	3,121 lbs
CAR	2022	Toyota	Supra	GR	55,650	21	31	RWD	340	500	2,868 lbs
SUV	2022	Ford	Bronco	Raptor	68,500	15	16	4WD	418	440	5,733 lbs
SUV	2022	LandrRov	RangRov	Sport	183,100	14	19	AWD	575	516	5,448 lbs
SUV	2022	Jeep	Grand	Wagoneer	109,435	13	18	RWD	392	404	6,420 lbs
CAR	2022	Dodge	SRT	Hellcat	89,190	12	21	RWD	797	707	5,450 lbs
CAR	2022	Nissan	GTR	Nismo	220,000	16	22	AWD	600	481	3,865 lbs

week 2

Vehicle	Year	Make	Model	Sub Model	Price	MPG/City	MPG/Hwy	Drive type	HP	TORQUE	Weight
Truck	2022	RAM	1500	TRX	$ 91,000.00	9	12	F4WD	702	650	6,439 lbs
Truck	2023	Ford	F150	Raptor R	$ 96,000.00	12	17	4WD	700	645	6,050 lbs
CAR	2023	Chevrolet	Corvette	3LT	$ 76,000.00	15	27	RWD	670	460	3,366 lbs
CAR	2022	Honda	Civic	Type R	$ 37,950.00	22	28	FWD	306	295	3,121 lbs
CAR	2022	Toyota	Supra	GR	$ 55,650.00	21	31	RWD	340	500	2,868 lbs
SUV	2022	Ford	Bronco	Raptor	$ 68,500.00	15	16	4WD	418	440	5,733 lbs
SUV	2022	LandrRov	RangRov	Sport	$ 183,100.00	14	19	AWD	575	516	5,448 lbs
SUV	2022	Jeep	Grand	Wagoneer	$ 109,435.00	13	18	RWD	392	404	6,420 lbs
CAR	2022	Dodge	SRT	Hellcat	$ 89,190.00	12	21	RWD	797	707	5,450 lbs
CAR	2022	Nissan	GTR	Nismo	$ 220,000.00	16	22	AWD	600	481	3,865 lbs
				Mean:	$ 102,682.50
				Meadian:	$ 90,095.00
				SD:	$ 56,688.14
				Sample Size	$ 10.00