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. In Minitab, 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. Bikes: Brand and Model Type Weight Price Klein Rêve 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   Please paste the Minitab output.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question
  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.
    1. In Minitab, Develop an estimated regression equation that can be used to predict Price by using Type and Weight.
    2. At the 0.05 level of significance, test for autocorrelation in the data.

Bikes:

Brand and Model Type Weight Price
Klein Rêve 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

 

Please paste the Minitab output.

Note: 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
1
2
3
4
di
du
di
dy
di
du
di
du
di
dy
15
20
1.36
.82
.69
.90
1.08
.95
1.54
1.75
1.97
.56
2.21
1.68
1.66
1.20
1.41
1.10
1.54
1.00
1.83
.79
1.99
25
1.29
1.45
1.21
1.55
1.12
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
1.44
1.50
40
1.54
1.39
1.60
1.66
1.29
1.34
1.42
1.72
1.23
1.79
50
1.59
1.46
1.63
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.
Transcribed Image Text:Note: 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 1 2 3 4 di du di dy di du di du di dy 15 20 1.36 .82 .69 .90 1.08 .95 1.54 1.75 1.97 .56 2.21 1.68 1.66 1.20 1.41 1.10 1.54 1.00 1.83 .79 1.99 25 1.29 1.45 1.21 1.55 1.12 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 1.44 1.50 40 1.54 1.39 1.60 1.66 1.29 1.34 1.42 1.72 1.23 1.79 50 1.59 1.46 1.63 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman