Years Sales ŷ y-ȳ (y-ȳ)^2 y-ŷ (y-ŷ)^2
1 80 84 -28 784 -4 16
3 97 92 -11 121 5 25
4 92 96 -16 256 -4 16
4 102 96 -6 36 6 36
6 103 104 -5 25 -1 1
8 111 112 3 9 -1 1
10 119 120 11 121 -1 1
10 123 120 15 225 3 9
11 117 124 9 81 -7 49
13 136 132 28 784 4 16
0 2442 170
ȳ= 108 SST SSE
Ans. 19 a SSR= 2272
Ans. 19 b coefficient of determination = 0.930385 or 93%
It is a good fit though it is less than 95%
Ans. 19 c sample correlation coefficient= 0.964565
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.96456463255965
R Square 0.93038493038493
Adjusted R Square 0.92168304668305
Standard Error 4.60977222864644
Observations 10
ANOVA
df SS MS
Regression 1 2272 2272
Residual 8 170 21.25
Total 9 2442
Coefficients Standard Error t Stat
Intercept 80 3.07534493657 26.01334
Years 4 0.38684349203 10.3401
RESIDUAL OUTPUT
Observation Predicted Sales Residuals
1 84 -4
2 92 5
3 96 -4
4 96 6
5 104 -1
6 112 -1
7 120 -1
8 120 3
9 124 -7
10 132 4
F Significance F
106.9176 6.6090291E-06
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
5.12E-09 72.908241865 87.09175814 72.90824186 87.091758135
6.609E-06 3.10793730844 4.892062692 3.107937308 4.8920626916
Weight Price
17.8 2100
16.1 6250
14.9 8370
15.9 6200
17.2 4000
13.1 8600
16.2 6000
17.1 2580
17.6 3400
14.1 8000
Equation Price = -1439.006 * Weight +28574.103
R Sqare= 0.863722
It is reasonably fair fit
price of 15 pound wt. 6989.006
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.929366408
R Square 0.8637219202
Adjusted R Square 0.8466871603
Standard Error 942.26605446
Observations 10
ANOVA
df SS MS F
Regression 1 45017877.4609 45017877.5 50.7034981
Residual 8 7102922.5391 887865.317
Total 9 52120800
Coefficients Standard Error t Stat P-value
Intercept 28574.103036 3247.13262833 8.79979548 2.18574E-05
Weight -1439.0064397 202.089512328 -7.12063889 9.99374E-05
RESIDUAL OUTPUT
Observation Predicted Price Residuals
1 2959.7884085 -859.788408464
2 5406.099356 843.900643974
3 7132.9070837 1237.09291628
4 5693.900644 506.099356026
5 3823.1922723 176.807727691
6 9723.1186753 -1123.11867525
7 5262.1987121 737.801287948
8 3967.0929163 -1387.09291628
9 3247.5896964 152.410303588
10 8284.1122355 -284.112235511
Significance F
9.99374473E-05
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
21086.2017736 36062.0043 21086.20177 36062.0042982
-1905.0256905 -972.987189 -1905.02569 -972.98718902
