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.

2022	CHEVY	CAMARO	25,000	19	29	275
2022	CHEVY	CORVETTE	60,900	16	24	455
2022	DODGE	CHALLENGER	30,075	19	30	303
2022	DODGE	CHARGER	31,350	19	30	292
2022	KIA	STINGER	36,290	22	32	300
2022	AUDI	S7	80,000	18	28	444
2022	AUDI	S8	117,000	14	23	563
2022	BMW	M3	72,000	16	23	473
2022	FORD	MUSTANG	27,205	21	29	310
2022	TOYOTA	SUPRA	43,290	25	32	255