Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will apply the statistical concepts and techniques covered in this week's reading about multiple regression. Last week's discussion involved a car rental company that

You will apply the statistical concepts and techniques covered in this week's reading about multiple regression. Last week's discussion involved a car rental company that wanted to evaluate the premise that heavier cars are less fuel efficient than lighter cars. The company expected fuel efficiency (miles per gallon) and weight of the car (often measured in thousands of pounds) to be correlated. The company also expects cars with higher horsepower to be less fuel efficient than cars with lower horsepower. They would like you to consider this new variable in your analysis.

You will work with a cars data set that includes the three variables used in this discussion:

  • Miles per gallon (coded as mpg in the data set)
  • Weight of the car (coded as wt in the data set)
  • Horsepower (coded as hp in the data set)

Address the following items:

  1. Check to be sure your scatterplots of miles per gallon against horsepower and weight of the car were included in your attachment. Do the plots show any trend? If yes, is the trend what you expected? Why or why not? See Steps 2 and 3 in the Python script.
  2. What are the coefficients of correlation between miles per gallon and horsepower? Between miles per gallon and the weight of the car? What are the directions and strengths of these coefficients? Do the coefficients of correlation indicate a strong correlation, weak correlation, or no correlation between these variables? See Step 4 in the Python script.
  3. Write the multiple regression equation for miles per gallon as the response variable. Use weight and horsepower as predictor variables. See Step 5 in the Python script. How might the car rental company use this model?

This is my data:

Step 1.

Cars data frame (showing only the first five observations)

Unnamed: 0mpgcyldisphpdratwtqsecvsamgearcarb
22AMC Javelin15.28304.01503.153.43517.300032
21Dodge Challenger15.58318.01502.763.52016.870032
20Toyota Corona21.54120.1973.702.46520.011031
18Honda Civic30.4475.7524.931.61518.521142
25Fiat X1-927.3479.0664.081.93518.901141

Step 2.

image text in transcribedimage text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Nonlinear Systems And Their Remarkable Mathematical Structures Volume 3, Contributions From China

Authors: Norbert Euler, Da jun Zhang

1st Edition

1000423301, 9781000423303

More Books

Students also viewed these Mathematics questions