Question

There are 7 variables listed: 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 response. Looking at the r squared value, explain what this indicates about the strength of the relation.

Vehicle Year Make Model Price MPG (City) MPG (Highway) Drive Type
Truck 2019 Ford F150 Lariat $77,001 18 23 4WD
Truck 2020 GMC 1500 Denali $61,637 19 25 4WD
Truck 2017 Chevrolet Silverado 1500 $28,250 16 22 2WD
Truck 2018 RAM 3500 Big Horn $49,432 16 19 4WD
Truck 2004 Ford F250 XLT $14,790 14 17 4WD
Truck 2006 Ford F350 Super Duty $18,025 15 19 4WD
Truck 2011 Ford F250 Super Duty $23,900 17 21 4WD
Truck 2014 RAM 1500 Crew Cab SLT $26,998 18 20 4WD
Truck 2010 Ford F250 Lariat $27,498 18 22 4WD
Truck 2019 Ford F-350 XL $34, 320 19 22 4WD

Answer 1

It’s mixed up uuuuppp