Question: Hello I need a help with below question: Please solve this in minitab and provide the step by step guide with explanation. Consumer Reports tested
Hello I need a help with below question: Please solve this in minitab and provide the step by step guide with explanation.
- 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.
- Develop an estimated regression equation that can be used to predict Price by using Type and Weight.
- At the 0.05 level of significance, test for autocorrelation in the data.
Here is data attached.
| Brand and Model | Type | Weight | Price |
| Klein Rve 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 | 500 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
