Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been hired to conduct business research for the purpose of identifying ways to improve fuel efficiency without disturbing consumer preference.Use the data presented

You have been hired to conduct business research for the purpose of identifying ways to improve fuel efficiency without disturbing consumer preference.Use the data presented to create multiple regression model which explains the impact of the variables you selected on City and Highway fuel economy.

(1) Make a frequency distributions and/or histograms for City MPG and Hwy MPG. Describe the distributions.

(2) Discuss the descriptive statistics for all variables.Use tables to present measures of central tendencies and measures of dispersion for continuous variables.Use tables, graphs, and charts to present frequencies and descriptive for nominal data.Be sure to identify, report, and recommend a treatment for any outliers.

(3) Determine if there is a statistically significant difference in City MPG based on vehicle body style. Be sure to use Tukey's test to determine if all styles are different.Do the same for Hwy MPG.Are the results the same for City and Hwy?

(4) Create scatter plot for X = Weight and Y = City MPG. What does it suggest?Fit a simple regression on the scatter plot. Interpret the slope and fit.

(5) Estimate a multiple regression model using City MPG as the response variable (dependent variable) and several numerical or binary predictors of your choice.Caution: If you use binary predictors, be carefulto omit one of the binary predictors in each group (body style, drive type, transmission type)to avoid perfect multi collinearity.

(6) Did your multiple regression model offer a substantially better fit than the simple regression in step (4)?

image text in transcribed
Automobile Specifications (n = 73, m = 27) Note: See variable definitions below dy Style (omit one) NumGears Coupe? Hatchback? Sedan? SUV? FWD? RWD? AWD? Automatic? Manual? CVT? Doors Style Sedan 1500 A - 6 Acura TL 3968 M - 6 Coupe 3470 BMW 4 Series 428 Coupe A -8 Buice LaCrosse Sedan 3600 3990 A - 6 SUV 3600 Buick Rega Sedan 2000 8 Cadillac ATS Sedan 2500 3315 A - 6 Cadillac Escalade SUV 6200 5527 Coupe 3719 A - 6 3600 M-6 Sedan 13 Chevrolet Impala LTZ 3600 3800 A -6 Hatchback L4 16 Chevrolet Suburban LTZ SUV V8 5300 A - 6 Sedan V6 2400 3600 A - 8 V6 A -8 20 Dodge Dart Limited Fiat 500 Sport Hatchback L4 23 Sedan 24 Ford Mustang GT Coupe 25 Ford Taurus Sedan 26 Honda Accord LX |Sedan 27 SUV 28 Hyundai Azera Limited Sedan A - 6 Sedan V 8 4240 A - 8 30 Hyundai Santa Fe GLS SUV V6 3300 3933 V6 3633 A - 7 31 Infiniti Q60 Coupe V6 3700 A - 7 32 Infiniti QX50 33 Jaguar F-Type Coupe V6 3000 3477 A - 8 34 2400 A - 6 35 Jeep Grand Cherokee Limited SUV 36 Kia Forte LX Sedan 797 2776 A - 8 A - 6 oooooo oooooo oooooo oooooo oooooo oooooooooooo ooo o - - oooo oooooo ooo OOO . . 3186 38 Kia Sportage LX SUV 359 5137 A - 6 39 Land Rover Range Rover Sport SUV 5000 Sedan V6 2500 41 Lexus LS 460 Sedan V8 1600 4233 V6 1500 4178 A - 8 SUV 43 SUV V6 3700 4702 A -6 A - 6 44 Lincoln MKT Lincoln MKZ Sedan L4 2000 3713 V8 46 Mazda 2 Hatchback L4 1500 2306 47 SUV 2000 3194 A -6 Mazda CX-5 Sport sedan 1800 3428 4894 A - 7 48 Mercedes-Benz C-250 A - 5 49 Mercedes-Benz CL600 Coupe V12 50 Mercedes-benz ML35 SUV 2605 M - 6 Mini-Cooper Hatchback L4 1600 Mitsubishi Outlander Sport SE SUV L4 2400 3296 53 Nissan Armada SV SUV V8 5600 2789 M - 6 54 Nissan Cube S Hatchback L4 V6 SUV V6 3500 4011 CVT V6 3500 L4 M-5 57 Nissan Versa S Sedan 1600 2363 58 Porsche Cayenne SUV V6 3600 4398 M - 6 Coupe 2000 63 60 Scion ia Hatchback L4 1329 2127 CVT 1798 3419 65 62 Suburu Forester 2.5i Limited SU 2500 63 Suburu Legacy 2.5i Limited Sedan L4 2500 CVT 64 Toyota Camry XLE 2500 68 65 Toyota Land Cruiser V8 570 74.0 5765 A - 6 66 Toyota RAV4 XLE SUV 2500 67 150 68 Volkswagen Beetle 2.5 Coupe 500 3038 A -6 Volkswagen Jetta SE Sedan 1800 SUV V6 600 4711 74 70 Volkswagen Toureg V6 Sport Sedar 1800 3230 75 71 Volkswagen Passat SE 72 Volvo S60 T Sedan L5 2500 73 Volvo XC90 L6 4667 76 SUV 3200 70.2 3528 does not apply Inusua

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

Algebra 2

Authors: Edward B. Burger, Juli K. Dixon, Steven J. Leinwand, Timothy D. Kanold

1st Edition

0544385918, 978-0544385917

More Books

Students also viewed these Mathematics questions