1.Consumer Reports tested 19 different brands and models of road, fitness, and comfort bikes. Road bikes are designed for long road trips; fitness bikes are designed for regular workouts or daily commuters; and comfort bikes are designed for leisure rides on typically flat roads. The data file Bikes show the type, weight (lb.), and price ($) for the 20 bicycles tested.

a.Develop an estimated regression equation that can be used to predict Price by using Type & Weight.

a.At the 0.05 level of significance, test for autocorrelation in the data.

Brand and Model Type Weight Price Klein RA ave v Road 20 1800 Giant OCR Composite 3 Road 22 1800 Giant OCR 1 Road 22 1000 Specialized Roubaix Road 21 1300 Trek Pilot 2.1 Road 21 1320 Cannondale Synapse 4 Road 21 1050 LeMond Poprad Road 22 1350 Raleigh Cadent 1.0 Road 24 650 Giant FCR3 Fitness 23 630 Schwinn Super Sport GS Fitness 23 700 Fuji Absolute 2.0 Fitness 24 700 Jamis Coda Comp Fitness 26 830 Cannondale Road Warrior 400 Fitness 25 700 Schwinn Sierra GS Comfort 31 340 Mongoose Switchback SX Comfort 32 280 Giant Sedona DX Comfort 32 360 Jamis Explorer 4.0 Comfort 35 600 Diamondback Wildwood Deluxe Comfort 34 350 Specialized Crossroads Sport Comfort 31 330 Jamis Coda Comp Comfort 33 500Note: Entries in the table are the critical values for a one-tailed Durbin-Watson test for autocorrelation. For a two-tailed test, the level of significance is doubled. Significance Points of d, and du: a = .05 Number of Independent Variables 2 3 4 5 du du du du du 15 1.08 1.36 .95 1.54 .82 1.75 .69 1.97 .56 2.21 20 1.20 1.41 1.10 1.54 1.00 1.68 ,90 1.83 .79 1.99 25 1.29 1.45 1.21 1.55 1.12 1.66 1.04 1.77 .95 1.89 30 1.35 1.49 1.28 1.57 1.21 1.65 1.14 1.74 1.07 1.83 40 1.44 1.54 1.39 1.60 1.34 1.66 1.29 1.72 1.23 1.79 50 1.50 1.59 1.46 1.63 1.42 1.67 1.38 1.72 1.34 1.77 70 1.58 1.64 1.55 1.67 1.52 1.70 1.49 1.74 1.46 1.77 100 1.65 1.69 1.63 1.72 1.61 1.74 1.59 1.76 1.57 1.78 *Interpolate linearly for intermediate n values