The purpose of this assignment is to apply simple regression techniques to find factors that determine the car values. AS Instructions: 1. Open the dataset of FamilySedans (attached) and read the case entitled “Finding the Best Car Value” in its entirety at the end of Chapter 14. 2. Use descriptive statistics to summarize the data and make comments on them. 3. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the price of the car. 4. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the five-year owner costs. 5. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the road-test score. 6. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the predicted-reliability. 7. What conclusions can you derive from your analysis? FamilySedans Dataset Car Price ($) Cost/Mile Road-Test Score Predicted Reliability Value Score Nissan Altima 2.5 S (4-cyl.) 23,970.00 0.59 91 4 1.75 Kia Optima LX (2.4) 21,885.00 0.58 81 4 1.73 Subaru Legacy 2.5i Premium 23,830.00 0.59 83 4 1.73 Ford Fusion Hybrid 32,360.00 0.63 84 5 1.70 Honda Accord LX-P (4-cyl.) 23,730.00 0.56 80 4 1.62 Mazda6 i Sport (4-cyl.) 22,035.00 0.58 73 4 1.60 Hyundai Sonata GLS (2.4) 21,800.00 0.56 89 3 1.58 Ford Fusion SE (4-cyl.) 23,625.00 0.57 76 4 1.55 Chevrolet Malibu LT (4-cyl.) 24,115.00 0.57 74 3 1.48 Kia Optima SX (2.0T) 29,050.00 0.72 84 4 1.43 Ford Fusion SEL (V6) 28,400.00 0.67 80 4 1.42 Nissan Altima 3.5 SR (V6) 30,335.00 0.69 93 4 1.42 Hyundai Sonata Limited (2.0T) 28,090.00 0.66 89 3 1.39 Honda Accord EX-L (V6) 28,695.00 0.67 90 3 1.36 Mazda6 s Grand Touring (V6) 30,790.00 0.74 81 4 1.34 Ford Fusion SEL (V6, AWD) 30,055.00 0.71 75 4 1.32 Subaru Legacy 3.6R Limited 30,094.00 0.71 88 3 1.29 Chevrolet Malibu LTZ (V6) 28,045.00 0.67 83 3 1.20 Chrysler 200 Limited (V6) 27,825.00 0.70 52 5 1.20 Chevrolet Impala LT (3.6) 28,995.00 0.67 63 3 1.05
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
Car | Price ($) | Cost/Mile | Road-Test Score | Predicted Reliability | Value Score |
Nissan Altima 2.5 S (4-cyl.) | 23,970.00 | 0.59 | 91 | 4 | 1.75 |
Kia Optima LX (2.4) | 21,885.00 | 0.58 | 81 | 4 | 1.73 |
Subaru Legacy 2.5i Premium | 23,830.00 | 0.59 | 83 | 4 | 1.73 |
Ford Fusion Hybrid | 32,360.00 | 0.63 | 84 | 5 | 1.70 |
Honda Accord LX-P (4-cyl.) | 23,730.00 | 0.56 | 80 | 4 | 1.62 |
Mazda6 i Sport (4-cyl.) | 22,035.00 | 0.58 | 73 | 4 | 1.60 |
Hyundai Sonata GLS (2.4) | 21,800.00 | 0.56 | 89 | 3 | 1.58 |
Ford Fusion SE (4-cyl.) | 23,625.00 | 0.57 | 76 | 4 | 1.55 |
Chevrolet Malibu LT (4-cyl.) | 24,115.00 | 0.57 | 74 | 3 | 1.48 |
Kia Optima SX (2.0T) | 29,050.00 | 0.72 | 84 | 4 | 1.43 |
Ford Fusion SEL (V6) | 28,400.00 | 0.67 | 80 | 4 | 1.42 |
Nissan Altima 3.5 SR (V6) | 30,335.00 | 0.69 | 93 | 4 | 1.42 |
Hyundai Sonata Limited (2.0T) | 28,090.00 | 0.66 | 89 | 3 | 1.39 |
Honda Accord EX-L (V6) | 28,695.00 | 0.67 | 90 | 3 | 1.36 |
Mazda6 s Grand Touring (V6) | 30,790.00 | 0.74 | 81 | 4 | 1.34 |
Ford Fusion SEL (V6, AWD) | 30,055.00 | 0.71 | 75 | 4 | 1.32 |
Subaru Legacy 3.6R Limited | 30,094.00 | 0.71 | 88 | 3 | 1.29 |
Chevrolet Malibu LTZ (V6) | 28,045.00 | 0.67 | 83 | 3 | 1.20 |
Chrysler 200 Limited (V6) | 27,825.00 | 0.70 | 52 | 5 | 1.20 |
Chevrolet Impala LT (3.6) | 28,995.00 | 0.67 | 63 | 3 | 1.05 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images