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.

Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA of SS MS F Significance F Regression Residual Total Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept Years Old RESIDUAL OUTPUT Observation Predicted Price Residuals Standard Residuals 6 10Vehichle Type |Year Make Model Price MPG (City) MPG (highway)| Cylinders SUV 2018 Toyota 4Runner $25,962.00 17 20 6 SUV 2019 Ford Escape $21,232.00 23 30 4 SUV 2020 Chevrolet Equinox $24,800.00 25 30 4 SUV 2019 Subaru Forester $24,998.00 26 33 4 Car 2019 Chevrolet Impala $45,075.00 18 28 6 Car 2019 Ford Mustang $31,995.00 15 24 8 Car 2019 Subaru Impreza $19,995.00 28 36 4 Car 2020 Nissan Altima $19,975.00 28 39 4 Car 2018 Chevrolet Cruz $14,587.00 29 40 4 Car 2020 Nissan Maxima $24,999.00 20 30 6 Car 2021 Bugatti Chiron $2,990,000.00 9 14 16 Qualitative Quantitive Qualitative Qualitative Quantitive Quantitive Quantitive Quantitive Correlation, r -0.8101776 R-squared 0.65638775