Question
The file contains complete data for 392 cars that were sold in the U.S. between 1970 and 1982. The objective of the analysis is to
The file contains complete data for 392 cars that were sold in the U.S. between 1970 and 1982.
The objective of the analysis is to predict their fuel economy from various physical attributes. Description as below,
MPG : Miles per gallon
GallonsPer100Miles : Gallons per 100 Miles = 100/MPG
Cylinder : number of cylinders
Weight1000lb: Weight of car in 1000s of pounds
Displacement100ci: Engine displacement in 100s of cubic inches
Horsepower100: 100s of horsepower
- Are these measurement or categorical variables?
- Make a histogram for Gallons per 100 miles. (Choose 10-20 same size bins.)
- Plot the following scatterplots (Remember to correctly label axes, scale, title):
- GallonsPer100Miles vs Displacement100ci
- GallonsPer100Miles vs Weight1000lb
- GallonsPer100Miles vs Horsepower100
- Find the following correlations:
- GallonsPer100Miles vs Displacement100ci 0.866
- GallonsPer100Miles vs Weight1000lb
- GallonsPer100Miles vs Horsepower100
- Which variable has the strongest linear relationship with GallonsPer100Miles? Is the correlation positive or negative? What does it signify?
- Regression
Aim : To predict fuel economy(or Gallons per 100 Miles) from the variable in previous part.
-
- Get the regression equation in excel. Plot the regression line on the scatterplot.
- What is the slope and intercept?
- Interpret the intercept and slope.
- Predict fuel economy for a car of weight 2500lbs.
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