|
IPS 4/e |
Exercises
10.13-10.15: Leaning Tower of Pisa |
|
|
|
|
|
|
|
|
|
|
|
ENTER THE DATA: |
|
|
|
Year |
Lean |
|
SUMMARY OUTPUT |
|
|
75 |
642 |
|
|
76 |
644 |
|
Regression
Statistics |
|
|
77 |
656 |
|
Multiple R |
0.993972 |
|
|
78 |
667 |
|
R Square |
0.98798 |
|
|
79 |
673 |
|
Adjusted R Square |
0.986887 |
|
|
80 |
688 |
|
Standard Error |
4.180971 |
|
|
81 |
696 |
|
Observations |
13 |
|
|
82 |
698 |
|
|
83 |
713 |
|
ANOVA |
|
|
84 |
717 |
|
|
df |
SS |
MS |
F |
Significance F |
|
|
85 |
725 |
|
Regression |
1 |
15804.48 |
15804.48 |
904.1198 |
6.5E-12 |
|
|
86 |
742 |
|
Residual |
11 |
192.2857 |
17.48052 |
|
|
87 |
757 |
|
Total |
12 |
15996.77 |
|
|
|
|
|
|
Highlight the data, including the
headings. |
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 99.0% |
Upper 99.0% |
|
Tools--Data
Analysis--Regression--OK |
|
Intercept |
-61.1209 |
25.12982 |
-2.43221 |
0.033279 |
-116.431 |
-5.81049 |
-139.169 |
16.92769 |
|
(Input Y range: C5:C18 |
Input X range: B5:B18 |
Include headings.) |
Year |
9.318681 |
0.309914 |
30.06858 |
6.5E-12 |
8.636564 |
10.0008 |
8.356145 |
10.28122 |
|
Check the Labels box. Leave Constant is zero clear. Check confidence
level at 99% |
|
|
Output range: Specify cell at upper left of where output should be printed. |
|
|
|
Check the boxes for
Residuals, Residual Plots, and Line Fit Plots. |
|
|
RESIDUAL OUTPUT |
|
|
Here is a portion of the output: |
|
|
Observation |
Predicted Lean |
Residuals |
|
1 |
637.7802 |
4.21978 |
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 99.0% |
Upper 99.0% |
2 |
647.0989 |
-3.0989 |
|
Intercept |
-61.1209 |
25.12982 |
-2.43221 |
0.033279 |
-139.1694531 |
16.92769484 |
3 |
656.4176 |
-0.41758 |
|
Year |
9.318681 |
0.309914 |
30.06858 |
6.5E-12 |
8.35614507 |
10.28121757 |
4 |
665.7363 |
1.263736 |
|
5 |
675.0549 |
-2.05495 |
|
10.13 (b) |
From the Coefficients column,
predicted lean = -61.1209 + 9.318681 year. |
6 |
684.3736 |
3.626374 |
|
7 |
693.6923 |
2.307692 |
|
10.13 (c ) |
From the last two numbers we get the
99% confidence interval for the slope. |
8 |
703.011 |
-5.01099 |
|
9 |
712.3297 |
0.67033 |
|
10.13 (a) |
The scatterplot with the
least-squares regression line is also produced. |
10 |
721.6484 |
-4.64835 |
|
11 |
730.967 |
-5.96703 |
|
12 |
740.2857 |
1.714286 |
|
13 |
749.6044 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
