Using Microsoft Excel

1 -The Tire Rack, Americas leading online distributor of tires and wheels, conducts extensive testing to provide customers with products that are right for their vehicle, driving style, and driving conditions. In addition, the Tire Rack maintains an independent consumer survey to help drivers help each other by sharing their long-term tire experiences. The following data show survey ratings for 18 maximum performance summer tires. The variable Steering rates the tires steering responsiveness, Tread Wear rates quickness of wear based on the drivers expectations, and Buy Again rates the drivers overall tire satisfaction and desire to purchase the same tire again.1.Develop an estimated regression equation that can be used to predict the Buy Again rating given based on the Steering rating. At the .05 level of significance, test for a significant relationship.Interpret the coefficients (Say what they mean in terms of change in y corresponding to a change in x) 2.Did the estimated regression equation developed in part (a) provide a good fit to the data? Explain.3.Develop an estimated regression equation that can be used to predict the Buy Again rating given the Steering rating and the Tread Wear rating.4.Is the addition of the Tread Wear independent variable significant? Use 0.05 level of significance.

Tire	Steering	Tread Wear	Buy Again
Goodyear Assurance TripleTred	8.9	8.5	8.1
Michelin HydroEdge	8.9	9	8.3
Michelin Harmony	8.3	8.8	8.2
Dunlop SP 60	8.2	8.5	7.9
Goodyear Assurance ComforTred	7.9	7.7	7.1
Yokohama Y372	8.4	8.2	8.9
Yokohama Aegis LS4	7.9	7	7.1
Kumho Power Star 758	7.9	7.9	8.3
Goodyear Assurance	7.6	5.8	4.5
Hankook H406	7.8	6.8	6.2
Michelin Energy LX4	7.4	5.7	4.8
Michelin MX4	7	6.5	5.3
Michelin Symmetry	6.9	5.7	4.2
Kumho 722	7.2	6.6	5
Dunlop SP 40 A/S	6.2	4.2	3.4
Bridgestone Insignia SE200	5.7	5.5	3.6
Goodyear Integrity	5.7	5.4	2.9
Dunlop SP20 FE	5.7	5	3.3