Question: It is important to remember that typically a two-factor regression model cannot accurately describe the entire situation. Look at the dependent variable that your peer
It is important to remember that typically a two-factor regression model cannot accurately describe the entire situation. Look at the dependent variable that your peer chose. Name at least 2 independent factors you would use to run a Multiple Linear Regression (MLR)and explain why you feel they are related. Then use those factors to run a Multiple Linear Regression (MLR) on your peer's data and see if thevariables you chose are related to the dependent variable they chose. What is your MLR equation? Is your MLR significant? Are any of the Independent factors significant? What is theR2value? Explain and interpret this value and how it relates to the MLR. Make sure you include your MLR Excel output as an attachment in your response post.
| Vehicle type/ class (Qualitative) | Year (Quantitative) | Make (Qualitative) | Model (Qualitative) | Price in $ (Quantitative) | MPG (City) (Quatitative) | MPG (Highway) (Quantiative) | Reviews (Quantitative) | Years old |
| SUV | 2023 | BMW | X5 | $61,600 | 21 | 26 | 4.7 | 0 |
| SUV | 2023 | Honda | CR-V | $28,410 | 28 | 34 | 4.8 | 0 |
| SUV | 2022 | Audi | Q3 | $35,900 | 23 | 30 | 4.6 | 1 |
| SUV | 2023 | Mecedes-Benz | GLA | $37,500 | 24 | 34 | 4.8 | 0 |
| Sedan | 2022 | Mercedes-Benz | C-CLASS | $43,550 | 25 | 35 | 4.7 | 1 |
| Sedan | 2023 | Toyota | CAMRY | $25,945 | 28 | 39 | 4.6 | 0 |
| Sedan | 2021 | Honda | CIVIC | $24,183 | 30 | 38 | 4.7 | 2 |
| Hatchback | 2021 | Mazda | MAZDA 3 | $20,187 | 26 | 34 | 4 | 2 |
| Van | 2022 | Honda | ODYSSEY | $33,335 | 19 | 28 | 4.6 | 1 |
| Truck | 2023 | Toyota | TACOMA | $28,585 | 20 | 23 | 4.6 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
