Question: Please provide the answers on excel Using the data set G, answer the questions given below. DATA SET G Mileage and Vehicle Weight Vehicle City
Please provide the answers on excel
| Using the data set G, answer the questions given below. |
| DATA SET G Mileage and Vehicle Weight | |||||
| Vehicle | City MPG | Weight | Vehicle | City MPG | Weight |
| Acura CL | 20 | 3,450 | Land Rover Freelander | 17 | 3,640 |
| Acura TSX | 23 | 3,320 | Lexus IS300 | 18 | 3,390 |
| BMW 3-Series | 19 | 3,390 | Lincoln Aviator | 13 | 5,000 |
| Buick Century | 20 | 3,350 | Mazda MPV | 18 | 3,925 |
| Buick Rendezvous | 18 | 4,230 | Mazda6 | 19 | 3,355 |
| Cadillac Seville | 18 | 4,050 | Mercedes-Benz S-Class | 17 | 4,195 |
| Chevrolet Corvette | 19 | 3,255 | Mercury Sable | 20 | 3,340 |
| Chevrolet Silverado 1500 | 14 | 4,935 | Mitsubishi Galant | 20 | 3,285 |
| Chevrolet TrailBlazer | 15 | 4,660 | Nissan 350Z | 20 | 3,345 |
| Chrysler Pacifica | 17 | 4,660 | Nissan Pathfinder | 15 | 4,270 |
| Dodge Caravan | 18 | 4,210 | Nissan Xterra | 16 | 4,315 |
| Dodge Ram 1500 | 13 | 5,300 | Pontiac Grand Am | 25 | 3,095 |
| Ford Expedition | 13 | 5,900 | Pontiac Vibe | 28 | 2,805 |
| Ford Focus | 26 | 2,760 | Saturn Ion | 24 | 2,855 |
| GMC Envoy | 15 | 4,660 | Subaru Baja | 21 | 3,575 |
| Honda Accord | 21 | 3,390 | Suzuki Vitara/XL-7 | 17 | 3,590 |
| Honda Odyssey | 18 | 4,315 | Toyota Celica | 23 | 2,570 |
| Hyundai Elantra | 24 | 2,880 | Toyota Matrix | 26 | 2,985 |
| Infiniti FX | 16 | 4,295 | Toyota Sienna | 19 | 4,120 |
| Isuzu Ascender | 15 | 4,965 | Volkswagen Jetta | 34 | 3,045 |
| Jaguar XJ8 | 18 | 3,805 | Volvo C70 | 20 | 3,690 |
| Kia Rio | 25 | 2,295 |
| Choose the dependent variable (the response variable to be "explained") and the independent variable (the predictor or explanatory variable). |
| Dependent Variable | (Click to select)City MPGWeight |
| Independent Variable | (Click to select)City MPGWeight |
| Obtain the regression equation. (Negative amount should be indicated by a minus sign. Round your answers to 4 decimal places.) |
| Y = X + |
| Calculate R2. (Round your answer to 4 decimal places.) |
| R2 |
| Zero is contained in the 95% confidence interval. |
| (Click to select)NoYes |
| The slope is different from zero. |
| (Click to select)NoYes |
| Calculate the degrees of freedom and t-critical. (Round your answers to 2 decimal places.) |
| DF | |
| t |
| Small p-values tell us the null hypothesis is false. |
| (Click to select)YesNo |
| The sample supports the hypothesis about the sign of the slope. |
| (Click to select)YesNo |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
