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 theR²value, explain what this indicates about the strength of the relation. Then write out your Regression Equation, state if your p-value and conclusion.

Vehicle Type/Class	Year	Make	Model	Price	MPG (City)	MPG (Highway)
BMW X5	2022	BMW	X5	$60,395	21	26
GMC Yukon	2022	GMC	Yukon XL	$58,595	15	17
Ford SUV	2022	Ford	Expedition	$58,695	19	24
Volvo	2022	Volvo	XC90	$58,895	19	27
Mustang Electric	2022	Ford	MACH-E	$43,995	TBD	TBD
Mazda SUV	2022	Mazda	CX-9	$42,885	20	23
Volvo SUV	2022	Volvo	XC40	$42,945	22	30
Acura	2022	Acura	RDX	$42,975	22	28
Tesla	2022	Tesla	Model Y	$60,190	TBD	TBD
Lexus	2022	Lexus	RX	$58,485	29	28