Mileage and Vehicle Weight (n = 73 vehicles) SUMMARY OUTPUT Vehicle Weight City MPG Regression Statistics Acura TL 3968 20 Multiple R 0.894329 Audi A5 3583 22 R Square 0.799824 BMW 4 Series 428i 3470 22 Adjusted R Square 0.797005 BMW X1 sDrive28i 3527 23 Standard Error 2.238113 Buice LaCrosse 3990 18 Observations 73 Buick Enclave 4724 17 Buick Regal 3692 21 ANOVA Cadillac ATS 3315 22 df SS MS F Significance F Cadillac CTS 3616 20 Regression 1 1421.035 1421.035 283.688 1.67E-26 Cadillac Escalade 5527 14 Residual 71 355.6495 5.009148 Chevrolet Camaro 1SS 3719 16 Total 72 1776.685 Chevrolet Cruze LS 3097 26 Chevrolet Impala LTZ 3800 19 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Chevrolet Malibu 2LT 3532 25 Intercept 40.08315 1.152588 34.77665 2.49E-46 37.78496 42.38135 37.78496 42.38135 Chevrolet Spark LS 2269 31 Weight -0.00517 0.000307 -16.843 1.67E-26 -0.00578 -0.00456 -0.00578 -0.00456 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 (b) Obtain the regression equation. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) Y = Not attemptedX + Not attempted (c) Calculate R2. (Round your answer to 4 decimal places.) R2 Not attempted (e) Calculate the degrees of freedom and t-critical for a two-tailed t test for zero slope at α = .05. (Round your answers to 2 decimal places.) Degrees of freedom Not attempted t - critical ± Not attempted
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.
Mileage and Vehicle Weight (n = 73 vehicles) | SUMMARY OUTPUT | |||||||||||||||||||||
Vehicle | Weight | City MPG | Regression Statistics | |||||||||||||||||||
Acura TL | 3968 | 20 |
|
Multiple R | 0.894329 | |||||||||||||||||
Audi A5 | 3583 | 22 | R Square | 0.799824 | ||||||||||||||||||
BMW 4 Series 428i | 3470 | 22 | Adjusted R Square | 0.797005 | ||||||||||||||||||
BMW X1 sDrive28i | 3527 | 23 | Standard Error | 2.238113 | ||||||||||||||||||
Buice LaCrosse | 3990 | 18 | Observations | 73 | ||||||||||||||||||
Buick Enclave | 4724 | 17 | ||||||||||||||||||||
Buick Regal | 3692 | 21 | ANOVA | |||||||||||||||||||
Cadillac ATS | 3315 | 22 | df | SS | MS | F | Significance F | |||||||||||||||
Cadillac CTS | 3616 | 20 | Regression | 1 | 1421.035 | 1421.035 | 283.688 | 1.67E-26 | ||||||||||||||
Cadillac Escalade | 5527 | 14 | Residual | 71 | 355.6495 | 5.009148 | ||||||||||||||||
Chevrolet Camaro 1SS | 3719 | 16 |
|
Total | 72 | 1776.685 | ||||||||||||||||
Chevrolet Cruze LS | 3097 | 26 | ||||||||||||||||||||
Chevrolet Impala LTZ | 3800 | 19 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||||||||||
Chevrolet Malibu 2LT | 3532 | 25 | Intercept | 40.08315 | 1.152588 | 34.77665 | 2.49E-46 | 37.78496 | 42.38135 | 37.78496 | 42.38135 | |||||||||||
Chevrolet Spark LS | 2269 | 31 | Weight | -0.00517 | 0.000307 | -16.843 | 1.67E-26 | -0.00578 | -0.00456 | -0.00578 | -0.00456 | |||||||||||
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 |
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 |
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 | ||||||||||||||||||||
(b) Obtain the regression equation. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.)
Y = Not attemptedX + Not attempted
(c) Calculate R2. (Round your answer to 4 decimal places.)
R2 Not attempted
(e) Calculate the degrees of freedom and t-critical for a two-tailed t test for zero slope at α = .05. (Round your answers to 2 decimal places.)
Degrees of freedom | Not attempted |
t - critical | ± Not attempted |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps