W7: Regression and Correlation

There are 7 variables listed:

Vehicle type/class

Year

Make

Model

Price

MPG (city)

MPG (highway)

Choose any 2 of variables listed above that you feel are correlated and explain why you feel that they are correlated. Do you suspect the relation is positive or negative? Why? Which would be considered the independent variable, which the dependent variable? Why?

Run a regression analysis in Exceland provide the results in your post along with your raw data. Looking at the R²value, explain what this indicates about the strength of the relation. Then write out your Regression Equation, state if your p-value and conclusion.

Below is the information she is referring to from week one. Choose 2 of the variables above that she has listed in referencing my excel doc.

You need to use the picture below of the excel document that I have included to answer the question

2022	RAM	1500	TRX	$ 91,000.00	9	12	F4WD	702	650	6,439 lbs
2023	Ford	F150	Raptor R	$ 96,000.00	12	17	4WD	700	645	6,050 lbs
2023	Chevrolet	Corvette	3LT	$ 76,000.00	15	27	RWD	670	460	3,366 lbs
2022	Honda	Civic	Type R	$ 37,950.00	22	28	FWD	306	295	3,121 lbs
2022	Toyota	Supra	GR	$ 55,650.00	21	31	RWD	340	500	2,868 lbs
2022	Ford	Bronco	Raptor	$ 68,500.00	15	16	4WD	418	440	5,733 lbs
2022	LandrRov	RangRov	Sport	$ 183,100.00	14	19	AWD	575	516	5,448 lbs
2022	Jeep	Grand	Wagoneer	$ 109,435.00	13	18	RWD	392	404	6,420 lbs
2022	Dodge	SRT	Hellcat	$ 89,190.00	12	21	RWD	797	707	5,450 lbs
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