Vehicle type/class	Year	Make	Model	Price	MPG (city)	MPG (highway)	Drive type
sedan	2021	toyota	camry XLE	$ 33,372.00	24	34	all-wheel drive
sedan	2021	Nissan	Altima 2.5 SV	$ 31,633.00	28	39	all-wheel drive
sedan	2021	Honda	Accord Hybrid Touring	$ 37,435.00	44	41	2 wheel drive - front
sedan	2021	Audi	A4 2.0T Premium	$ 48,765.00	24	34	All wheel drive
sedan	2021	Volkswagen	Arteon SE	$ 38,774.00	22	32	2 wheel drive - front
sedan	2022	toyota	Prius Prime LE	$ 28,220.00	55	54	2 wheel drive - front
crossover	2021	Subaru	Crosstrek 2.0i Premium	$ 28,827.00	28	33	All wheel drive
sedan	2022	Hyundai	Accent SEL	$ 17,940.00	33	41	2 wheel drive - front
sedan	2020	Hyundai	Elantra SEL	$ 19,300.00	31	41	2 wheel drive - front
Hatchback	2021	maza	MAZDA3	$ 35,220.00	23	31	All wheel drive
			Mean	$ 31,948.60
			Median	$ 32,502.50
			SD	9141.969812
			Sample size	10
			p	0.5
			q	0.5

Look back to the raw data you collected in week 1. There are 7 variables listed:

Vehicle type/class

Year

Make

Model

Price

MPG (city)

MPG (highway)

Choose TWO variables 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.