Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started