I chose to focus on highway mpg versus city mpg but needed help to see if I'm doing the work correctly.

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 Excel and provide the results in your post along with your raw data. Looking at the R2 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 MPG MPG Class Year Make Model Price (City) (Hwy) Cylinders Gladiator Truck 2020 Jeep Rubicon 43,545 17 22 V6 Cherokee 4 - SUV 2020 Jeep Trailhawk AWD 38,000 21 29 turbocharged Grand Cherokee V8 SUV 2020 Jeep Trackhawk 88,500 11 17 supercharged Compass Trailhawk 4WD Crossover 2020 Jeep (M) 32,700 22 31 4 Renegade 4 - Crossover 2019 Jeep Trailhawk 4WD 23,000 21 29 turbocharged Wrangler SUV 2019 Jeep Rubicon 60,000 18 23 V6 Wrangler 4 - SUV 2019 Jeep Unlimited 60,000 23 25 turbocharged SUV 2020 Chevrolet Tahoe LT 57,295 15 21 V8 4 - SUV 2020 Lexus NX 300 46,235 22 28 turbocharged