Question

In: Statistics and Probability

Mileage and Vehicle Weight  (n = 73 vehicles) Vehicle Weight City MPG Acura TL 3968 20 Audi...

Mileage and Vehicle Weight  (n = 73 vehicles)
Vehicle Weight City MPG
Acura TL 3968 20
Audi A5 3583 22
BMW 4 Series 428i 3470 22
BMW X1 sDrive28i 3527 23
Buice LaCrosse 3990 18
Buick Enclave 4724 17
Buick Regal 3692 21
Cadillac ATS 3315 22
Cadillac CTS 3616 20
Cadillac Escalade 5527 14
Chevrolet Camaro 1SS 3719 16
Chevrolet Cruze LS 3097 26
Chevrolet Impala LTZ 3800 19
Chevrolet Malibu 2LT 3532 25
Chevrolet Spark LS 2269 31
Chevrolet Suburban LTZ 5674 15
Chrysler 200 Touring LX 3402 20
Chrysler 300 S 4029 19
Dodge Charger SXT 3996 19
Dodge Dart Limited 3242 23
Fiat 500 Sport 2434 31
Ford Fiesta S 2575 29
Ford Focus  SE 2960 27
Ford Mustang GT 3618 15
Ford Taurus 4054 19
Honda Accord LX 3192 24
Honda CRV LX 3305 23
Hyundai Azera Limited 3605 19
Hyundai Genesis 5.0 4240 15
Hyundai Santa Fe GLS 3933 18
Infiniti Q60 3633 19
Infiniti QX50 3790 17
Jaguar F-Type 3477 20
Jeep Compass Limited 3258 21
Jeep Grand Cherokee Limited 4685 17
Kia Forte LX 2776 25
Kia Soul 2615 24
Kia Sportage LX 3186 21
Land Rover Range Rover Sport 5137 13
Lexus IS 250 3461 21
Lexus LS 460 4233 16
Lexus RX 350 4178 18
Lincoln MKT 4702 17
Lincoln MKZ 3713 22
Lincoln Navigator 5794 14
Mazda 2 2306 28
Mazda CX-5 Sport 3194 26
Mercedes-Benz C-250 3428 22
Mercedes-Benz CL600 4894 12
Mercedes-Benz ML350 4751 17
Mini-Cooper 2605 29
Mitsubishi Outlander Sport SE 3296 25
Nissan Armada SV 5267 13
Nissan Cube S 2789 25
Nissan Maxima SV 3570 19
Nissan Murano SV 4011 18
Nissan Versa S 2363 27
Porsche Cayenne 4398 15
Scion FR-S 2806 25
Scion iQ 2127 36
Scion XD 2665 27
Suburu Forester 2.5i Limited 3419 24
Suburu Legacy 2.5i Limited 3427 24
Toyota Camry XLE 3280 25
Toyota Land Cruiser 5765 13
Toyota RAV4 XLE 3465 24
Toyota Yaris 2295 30
Volkswagen Beetle 2.5L 3038 22
Volkswagen Jetta SE 3070 25
Volkswagen Toureg V6 Sport 4711 17
Volkswagen Passat SE 3230 24
Volvo S60 T5 3528 21
Volvo XC90 4667 16

a. Interpret the slope. Does the intercept have meaning, given the range of the data?

b. Based on the R2 and ANOVA table for your model, how would you assess the fit? Interpret the p-value for the Fstatistic. Would you say that your model’s fit is good enough to be of practical value?

c. Is an autocorrelation test appropriate for your data? If so, perform an eyeball inspection of residual plot against observation order or a runs test.

d. Use MegaStat or Minitab to generate 95 percent confidence and prediction intervals for various X-values.

e. Use MegaStat or Minitab to identify observations with high leverage.

Solutions

Expert Solution

Minitab output:

a. As weight is increased by 1 unit, expected City MPG is decreased by 0.00517 unit. Intercept has no real interpretation since when weight is zero the expected City MPG is 40.1 unit which is meaningless.

b. R-sq=80% i.e. 80% of total variation in City MPG is explained by this regression equation. Moreover from ANOVA table, we see that p-value<0.05, so the these two variables are linearly related significantly. Hence we can conclude that the fitting is good.

c.

From the above plot, we see the residuals bounce randomly around the residual = 0 line as we would hope so. In general, residuals exhibiting normal random noise around the residual = 0 line suggest that there is no serial correlation.

d.

e.

Unusual Observations:


Related Solutions

In determining automobile mileage​ ratings, it was found that the mpg in the city for a...
In determining automobile mileage​ ratings, it was found that the mpg in the city for a certain model is normally​ distributed, with a mean of 28 mpg and a standard deviation of 1.5 mpg. Suppose that the car manufacturer samples four cars from its assembly line and tests them for mileage ratings. a. What is the distribution of the mean mpg for the​ sample? b. What is the probability that the mean mpg of the sample will be greater than...
We are interested in predicting the fuel efficiency (gasoline mileage in mpg) using the weight of...
We are interested in predicting the fuel efficiency (gasoline mileage in mpg) using the weight of a vehicle in pounds. A random sample of 12 vehicles is taken. The Excel output is given below. Use the output and the fact that R2 = 0.640 to answer the following questions. Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 48.409 5.978 8.098 0.000 35.089 61.728 Weight -0.006 0.002 -4.214 0.002 -0.010 -0.002 Interpret the slope in context. Find and...
How does gas mileage depend on the weight, size of the vehicle, engine size, and seating capacity of the vehicle?
 I will be comparing a 2018 Chevy Equinox vs. 2018 Ford Escape. My research question is as followed; "How does gas mileage depend on the weight, size of the vehicle, engine size, and seating capacity of the vehicle?" Submit a Research Proposal for instructor approval that includes your main variables, any control variables, how they are labeled, what your value ranges are, your specific data source, and your tentative research question.
Vehicle type/class    Year Make Model Price MPG (city) MPG (highway Number of Airbags Convertible 2019...
Vehicle type/class    Year Make Model Price MPG (city) MPG (highway Number of Airbags Convertible 2019 Porsche 718 Boxtster 53,208 19 22 5 Convertible 2019 Mazda MX-5 Miata 23,436 24 29 5 Convertible 2020 Audi S5 55,459 20 26 5 Sedan 2020 Hyundi Accent 15,015 25 29 6 Sedan 2020 Kia Rio 15,300 26 30 6 Sedan 2020 Toyota Yaris 16,100 30 35 6 Truck 2020 Ford F150 31,591 18 22 10 Truck 2020 Toyota Tacoma 27,361 16 20 8...
Upload Cars04-1 Cars04-1 data and use engine size to predict the car’s city gas mileage(City MPG)....
Upload Cars04-1 Cars04-1 data and use engine size to predict the car’s city gas mileage(City MPG). Answer the questions. I) For each additional 2.0 liter in engine size how much the MPG will change? (11.11 points) a. It will decrease by 0.21 mpg. b. It will decrease by 8.21 mpg. c. It will be 25.49 mpg. d. For car with zero horse power we expect 33.7 mpg. e. Not applicable. II) After performing the regression analysis you are asked to...
Given the following data where city MPG is the response variable and weight is the explanatory...
Given the following data where city MPG is the response variable and weight is the explanatory variable, explain why a regression line would be appropriate to analyze the relationship between these variables: Model City MPG Weight Mazda MX-5 Miata 25 2365 Mercedes/Benz SLK 22 3020 Mitsubishi Eclipse 23 3235 Pontiac Firebird 18 3545 Porsche Boxster 19 2905 Saturn SC 27 2420 Construct the regression line for this data. Interpret the meaning of the y-intercept and the slope within this scenario....
City A is located 40° N, 10° W. City B is located 40° N, 20° E....
City A is located 40° N, 10° W. City B is located 40° N, 20° E. Assume the Earth is a perfect sphere with a radius of 6371km. Calculate the short distance between city A and city B along the 40° N parallel. Calculate the shortest distance (on curved Earth surface) between city A and the equator. π = 3.141
The weight of a 0.6 kg object at the surface of Planet V is 20 N....
The weight of a 0.6 kg object at the surface of Planet V is 20 N. The radius of the planet is 4 X 106 m. Find the gravitational acceleration at a distance of 2.0 X 106 m from the surface of this planet. 9 m/s2 13 m/s2 14.8 m/s2 11 m/s2
A sample of 20 cars, including measurements of fuel consumption (city mi/gal and highway mi/gal), weight...
A sample of 20 cars, including measurements of fuel consumption (city mi/gal and highway mi/gal), weight (pounds), number of cylinders, engine displacement (in liters), amount of greenhouse gases emitted (in tons/year), and amount of tailpipe emissions of NOx (in lb/yr). CAR CITY HWY WEIGHT CYLINDERS DISPLACEMENT MAN/AUTO GHG NOX Chev. Camaro 19 30 3545 6 3.8 M 12 34.4 Chev. Cavalier 23 31 2795 4 2.2 A 10 25.1 Dodge Neon 23 32 2600 4 2 A 10 25.1 Ford...
A sample of 20 cars, including measurements of fuel consumption (city mi/gal and highway mi/gal), weight...
A sample of 20 cars, including measurements of fuel consumption (city mi/gal and highway mi/gal), weight (pounds), number of cylinders, engine displacement (in liters), amount of greenhouse gases emitted (in tons/year), and amount of tailpipe emissions of NOx (in lb/yr). CAR CITY HWY WEIGHT CYLINDERS DISPLACEMENT MAN/AUTO GHG NOX Chev. Camaro 19 30 3545 6 3.8 M 12 34.4 Chev. Cavalier 23 31 2795 4 2.2 A 10 25.1 Dodge Neon 23 32 2600 4 2 A 10 25.1 Ford...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT