Regression and Correlation
Question Description
Look at the data attached in excel. 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 Excel and provide the results in your post. Looking at the r squared value, explain what this indicates about the strength of the relation.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."