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.





