1. PC World rated four component characteristics for 10 ultraportable laptop com
ID: 3359603 • Letter: 1
Question
1. PC World rated four component characteristics for 10 ultraportable laptop computers: features; performance; design; and price. Each characteristic was rated using a 0–100 point scale. An overall rating, referred to as the PCW World Rating, was then developed for each laptop. The following table shows the performance rating, features rating, and the PCW World Rating for the 10 laptop computers.
Model
Performance
Features
PCW Rating
Thinkpad X200
77
87
83
VGN-Z598U
97
85
82
U6V
83
80
81
Elitebook 2530P
77
75
78
X360
64
80
78
Thinkpad X300
56
76
78
Ideapad U110
55
81
77
Micro Express JFT2500
76
73
75
Toughbook W7
46
79
73
HP Voodoo Envy133
54
68
72
a) Interpret the slope coefficients for each of the independent variables.
b) Conduct Hypothesis tests on Regression and Individual coefficients at 0.05 level of significance.
c) What are the values of Coefficient of Multiple Determination and Adjusted Coefficient of Multiple Determination?
d) Comment on Goodness of Fit between the dependent variable and the two independent variables. What is the expected PCW Rating when Performance Rating is 65 and Features Rating is 82?
Model
Performance
Features
PCW Rating
Thinkpad X200
77
87
83
VGN-Z598U
97
85
82
U6V
83
80
81
Elitebook 2530P
77
75
78
X360
64
80
78
Thinkpad X300
56
76
78
Ideapad U110
55
81
77
Micro Express JFT2500
76
73
75
Toughbook W7
46
79
73
HP Voodoo Envy133
54
68
72
a) Interpret the slope coefficients for each of the independent variables.
b) Conduct Hypothesis tests on Regression and Individual coefficients at 0.05 level of significance.
c) What are the values of Coefficient of Multiple Determination and Adjusted Coefficient of Multiple Determination?
d) Comment on Goodness of Fit between the dependent variable and the two independent variables. What is the expected PCW Rating when Performance Rating is 65 and Features Rating is 82?
I have to do this in Excel so please show all the steps done to get the answer and if any formulas could be used. Thanks so much.Explanation / Answer
(a) using ms-excel the regression equation is given as
y=39.9819+0.1133*x1+0.3820*x2
if performance is fixed the PCW rating will increase by 0.3820 with unit change in feature
if feature is fixed the PCW rating will increase by 0.1133 with unit change in performance
(b)t=coefficient/SE(coefficient)
p-value of performance and feature is more than alpha=0.05 so they are different from zero at 5% level of sigificance
(d)p-value of F-test of the model is 0.0017 which is less than alpha=0.05, so model is signifiant at 5% level of significance also R2=0.8369, it means 83.69% of variation is explained by the model
for x1=Performance Rating is 65 and x2=Features Rating is 82,
PCW rating =39.9819+0.1133*65+0.3820*82=78.67
following information has been generated using ms-excel
Coefficients Standard Error t Stat P-value Intercept 39.98196819 7.855064392 5.089961 0.001415 Performance 0.113382175 0.038458631 2.948159 0.021463 Feature 0.382032562 0.109333005 3.494211 0.010071Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.