Hi- please assist me with this question. I am not very strong in this subject an
ID: 3259219 • Letter: H
Question
Hi- please assist me with this question. I am not very strong in this subject and cannot make it to meet with the professor because I work during the day.
Please use Excel Megastat to solve the problem. Your calculated values must come from the excel output. Copy and paste relevant excel output on this assignment or attach excel output to it – do not include the data, fit all excel output on one page.
Be sure to write in all required information below each question, you will not receive credit if you only turn it the output.
Show all the steps.
Treadmills Case:
Consumer Reports provided extensive testing and ratings for 24 treadmills. An overall score, based primarily on ease of use, ergonomics, exercise range, and quality, was developed for each treadmill tested. In general, a higher overall score indicates better performance. The following data (Excel file available in Connect “Lab assignment 5” folder) contains data on the price, overall score, and quality rating for the 24 treadmills (Consumer Reports, February 2006).
Use the “good” quality rating as the base when creating the dummy variables for quality.
Brand & Model
Price ($)
Score (points)
Quality
Landice L7
2900
86
Excellent
NordicTrack S3000
3500
85
Very good
SportsArt 3110
2900
82
Excellent
Precor
3500
81
Excellent
True Z4 HRC
2300
81
Excellent
Vision Fitness T9500
2000
81
Excellent
Precor M 9.31
3000
79
Excellent
Vision Fitness T9200
1300
78
Very good
Star Trac TR901
3200
72
Very good
Trimline T350HR
1600
72
Very good
Schwinn 820p
1300
69
Very good
Bowflex 7-Series
1500
83
Excellent
NordicTrack S1900
2600
83
Very good
Horizon Fitness PST8
1600
82
Very good
Horizon Fitness 5.2T
1800
80
Very good
Evo by Smooth Fitness FX30
1700
75
Very good
ProForm 1000S
1600
75
Very good
Horizon Fitness CST4.5
1000
74
Very good
Keys Fitness 320t
1200
73
Very good
Smooth Fitness 7.1HR Pro
1600
73
Very good
NordicTrack C2300
1000
70
Good
Spirit Inspire
1400
70
Very good
ProForm 750
1000
67
Good
Image 19.0 R
600
66
Good
A. Using Excel Megastat output, report multiple regression equation for predicting the price of treadmills when knowing their overall score and quality rating.
B. Interpret the meaning of each of the regression coefficient starting with b0 as an estimate of 0, and continuing with b1, b2…. For each “bn” report a value and which “X” is it a coefficient for.
Partial regression coefficient for the y-intercept, b0 = _______
Interpretation of b0 -
Does the interpretation of the y-intercept make sense? Why yes/no?
Partial regression coefficient for X1 (score in points), b1 = ________
Interpretation of b1 –
…Continue in the same fashion until you have interpreted all partial regression coefficients.
C. Test the significance of the overall regression model at = .01. Use the 7-step hypothesis test and either of the two approaches (critical or p-value).
D. Report the value of the adjusted multiple coefficient of determination and interpret its meaning.
E. Test the partial regression coefficient for the variable “score”. Is the coefficient significant at = 0.1? (p-value approach hypothesis test)
F. Test the partial regression coefficient for the first dummy variable (2). Is the coefficient significant at = 0.1? (p-value approach hypothesis test)
G. Report a 95% interval for the mean value of all treadmills that are in “good” condition and have a score of 79. Interpret the meaning of the interval in the context of the problem.
H. Report a 95% interval for the price of an individual treadmill in “good” condition with a score of 79. Interpret the meaning of the interval in the context of the problem.
I. Analyze the correlation matrix, do you see any multicollinearity in the model? Comment on which variables appear to be problematic?
Brand & Model
Price ($)
Score (points)
Quality
Landice L7
2900
86
Excellent
NordicTrack S3000
3500
85
Very good
SportsArt 3110
2900
82
Excellent
Precor
3500
81
Excellent
True Z4 HRC
2300
81
Excellent
Vision Fitness T9500
2000
81
Excellent
Precor M 9.31
3000
79
Excellent
Vision Fitness T9200
1300
78
Very good
Star Trac TR901
3200
72
Very good
Trimline T350HR
1600
72
Very good
Schwinn 820p
1300
69
Very good
Bowflex 7-Series
1500
83
Excellent
NordicTrack S1900
2600
83
Very good
Horizon Fitness PST8
1600
82
Very good
Horizon Fitness 5.2T
1800
80
Very good
Evo by Smooth Fitness FX30
1700
75
Very good
ProForm 1000S
1600
75
Very good
Horizon Fitness CST4.5
1000
74
Very good
Keys Fitness 320t
1200
73
Very good
Smooth Fitness 7.1HR Pro
1600
73
Very good
NordicTrack C2300
1000
70
Good
Spirit Inspire
1400
70
Very good
ProForm 750
1000
67
Good
Image 19.0 R
600
66
Good
Explanation / Answer
regression score si
Sample Mean 1920.8 76.54 Sample Standard deviation 855.2 5.92 Count 24 24 Median 1600 76.5Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.