Problem: The Buyer\'s Guide section of the wevsite for Car and Driver magazine p

Question

Problem: The Buyer's Guide section of the wevsite for Car and Driver magazine provides reviews and road tests for cars, trucks, SUVs, and vans. The average ratings of overall quality, vehicle styling, braking, handling, fuel economy, interior comfort, acceleration, dependability, fit and finish, transmission, and ride are summarized for each vehicle using a scale ranging from 1(worst) to 10(best). A portion of the data for 14 Sports/GT cars is shown here (Car and Driver website, January 7, 2004.

Question:

A.)Develop an estimated regression equation using handling, dependability, and fit and finish to predict overall quality.

Sports/Gt Overall Handling Dependability Fit and Finish Acura 3.2/CL 7.8 7.83 8.17 7.67 Acura RSX 9.02 9.46 9.35 8.97 Audi TT 9 9.58 8.74 9.38 BMW 3-Series/M3 8.39 9.52 8.39 8.55 Chevrolet Corvette 8.82 9.64 8.54 7.87 Ford Mustang 8.34 8.85 8.7 7.34 Honda Civic Si 8.92 9.31 9.5 7.93 Infiniti G35 8.7 9.34 8.96 8.07 Mazda RX-8 8.58 9.79 8.96 8.12 Mini Cooper 8.76 10 8.69 8.33 Mitsubishi Eclipse 8.17 8.95 8.25 7.36 Nissan 350Z 8.07 9.35 7.56 8.21 Porsche 911 9.55 9.91 8.86 9.55 Toyota Celica 8.77 9.29 9.04 7.97

Explanation / Answer

Using MINITTAB find out the regression line

First Enter given data in C1 - C4

Choose Stat > Regression > Regression.

In Response, enter C1.

In Predictors, enter C2- C4.

Click OK.

Session window output

MTB > Regress 'Overall' 3 'Handling'-'Fit and Finish';
SUBC>   Constant;
SUBC>   Brief 1.

Regression Analysis: Overall versus Handling, Dependabilit, Fit and Fini

The regression equation is
Overall = - 0.06 + 0.276 Handling + 0.447 Dependability + 0.270 Fit and Finish

Predictor           Coef SE Coef      T       P
Constant          -0.055      1.128      -0.05    0.962
Handling           0.2760    0.1213 2.28    0.046
Dependability    0.4469    0.1111    4.02    0.002
Fit and Finish    0.27028 0.09527   2.84 0.018

S = 0.189516   R-Sq = 86.5%   R-Sq(adj) = 82.4%

Analysis of Variance

Source            DF       SS       MS           F      P
Regression       3    2.29579 0.76526 21.31 0.000
Residual Error 10 0.35916 0.03592
Total           13    2.65495

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.