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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!