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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started