Question: Part 1, Table 1: Vehicle type/class Year Make Model Price MPG (city) MPG (highway) number of cylinders Minivan 2021 Toyota Sienna $34,270.00 36 36 4
Part 1, Table 1:
| Vehicle type/class | Year | Make | Model | Price | MPG (city) | MPG (highway) | number of cylinders |
| Minivan | 2021 | Toyota | Sienna | $34,270.00 | 36 | 36 | 4 |
| Minivan | 2021 | Honda | Odyssey | $32,965.00 | 19 | 28 | 6 |
| SUV | 2021 | Toyota | RAV4 Hybrid | $29,802.00 | 41 | 38 | 4 |
| SUV | 2021 | Toyota | Highlander Hybrid | $37,605.00 | 36 | 35 | 4 |
| SUV | 2021 | Subaru | Forester | $24,865.00 | 26 | 33 | 4 |
| Sedan | 2022 | Toyota | Camry | $28,375.00 | 51 | 53 | 4 |
| Sedan | 2022 | Lexus | ES | $41,875.00 | 43 | 44 | 4 |
| Sedan | 2022 | Honda | Accord | $27,685.00 | 48 | 47 | 4 |
| SUV | 2022 | BMW | X5 | $58,613.00 | 21 | 26 | 6 |
| Sedan | 2022 | Audi | A7 | $70,245.00 | 21 | 30 | 6 |
Look at to the raw data in table 1. 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 Exceland provide the results in your post along with your raw data. Looking at theR2value, explain what this indicates about the strength of the relation. Then write out your Regression Equation, state if your p-value and conclusion.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
