Dependent variable = Y = Shipping Cost in
dollars
Explanatory Variable = X = Weight of package in
pounds
|
Obs |
Yi |
Xi |
X2 |
Y2 |
X x Y |
||
|
1 |
11 |
8 |
64.0 |
121.00 |
88.00 |
||
|
2 |
8 |
6 |
36.0 |
64.00 |
48.00 |
||
|
3 |
11 |
5 |
25.0 |
121.00 |
55.00 |
||
|
4 |
11 |
7 |
49.0 |
121.00 |
77.00 |
||
|
5 |
17 |
12 |
144.0 |
289.00 |
204.00 |
||
|
6 |
11 |
9 |
81.0 |
121.00 |
99.00 |
||
|
7 |
27 |
17 |
289.0 |
729.00 |
459.00 |
||
|
8 |
16 |
13 |
169.0 |
256.00 |
208.00 |
||
|
9 |
9 |
8 |
64.0 |
81.00 |
72.00 |
||
|
10 |
25 |
18 |
324.0 |
625.00 |
450.00 |
||
|
11 |
21 |
17 |
289.0 |
441.00 |
357.00 |
||
|
12 |
24 |
17 |
289.0 |
576.00 |
408.00 |
||
|
13 |
16 |
10 |
100.0 |
256.00 |
160.00 |
||
|
14 |
16 |
20 |
400.0 |
256.00 |
320.00 |
||
|
15 |
21 |
9 |
81.0 |
441.00 |
189.00 |
||
|
16 |
10 |
5 |
25.0 |
100.00 |
50.00 |
||
|
17 |
21 |
13 |
169.0 |
441.00 |
273.00 |
||
|
18 |
16 |
6 |
36.0 |
256.00 |
96.00 |
||
|
19 |
11 |
6 |
36.0 |
121.00 |
66.00 |
||
|
20 |
20 |
12 |
144.0 |
400.00 |
240.00 |
Sums
322
218
2814.0
5816.00 3919.00
Count
20
20
1. Compute the Sums of
Squares:
SSxx =
SSyy =
631.8
SSxy =
409.2
2. Compute the estimated regression
coefficients, bo and
b1
b1 =
bo =
3. Test the hypothesis: Ho:
b1 = 0 against H1: b1 ≠ 0 using
the F test.
ANOVA
|
df |
SS |
MS |
F |
|
|
Regression |
||||
|
Residual |
||||
|
Total |
|
|||
4. What conclusion do you draw from this
test? Can you reject Ho?
If so, at what
significance (alpha) level?
5. In one sentence, interpret the slope
coefficient, b1, which you calculated
above.
6. Report R2, the coefficient
of determination for this model. Interpret this value.
7. Report Se, the standard
error of estimate for this model.
8. Report the estimated simple
correlation coefficient. Interpret this value.
9. Calculate the predicted value of Y,
Yhat, when X = 4.
10. Calculate a 95% confidence interval
estimate for an individual value of Y when X = 4.





