0% found this document useful (0 votes)
36 views5 pages

Economics - Final Quiz Solution

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
36 views5 pages

Economics - Final Quiz Solution

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.926546407453
R Square 0.858488245165
Adjusted R Square 0.836717205959
Standard Error 3.004428833689
Observations 16

ANOVA
df SS MS F
Regression 2 711.883670983 355.94183549144 39.43258000066
Residual 13 117.345704017 9.0265926167013
Total 15 829.229375

Coefficients Standard Error t Stat P-value


Intercept 29.39989266394 2.9674791346 9.9073628930086 0.000000200420
X1 0.968876319125 0.28251665932 3.4294484490063 0.0044815106308
X2 2.154360448344 0.55993513318 3.8475179010839 0.0020169984873

RESIDUAL OUTPUT

Observation Predicted Y Residuals Standard Residuals


1 45.30556763177 0.19443236823 0.069515331496
2 46.49105176099 -4.99105176099 -1.784448859164
3 46.27444395089 -2.77444395089 -0.991945902401
4 47.24332027002 0.25667972998 0.0917706073339
5 48.42880439924 1.07119560076 0.3829841603061
6 51.5520411667 1.9479588333 0.6964529891161
7 54.67527793417 0.82472206583 0.2948625700489
8 56.82963838252 2.67036161748 0.9547333848787
9 57.79851470164 -0.29851470164 -0.106727849018
10 60.92175146911 0.57824853089 0.2067409797918
11 54.39485954631 0.20514045369 0.0733437892623
12 53.54335987485 5.25664012515 1.8794045671266
13 60.87725814183 0.62274185817 0.2226486623617
14 65.51879173102 -6.41879173102 -2.294908193731
15 58.12898386362 -0.52898386362 -0.189127401829
16 67.31633517533 1.38366482467 0.4947011644199
Significance F
0.000003021004

Lower 95% Upper 95% Lower 95.0% Upper 95.0%


22.9890437528407 35.8107415750488 22.9890437528407 35.810741575049
0.358536183400391 1.57921645484902 0.3585361834004 1.579216454849
0.944694136976356 3.36402675971209 0.9446941369764 3.3640267597121

PROBABILITY OUTPUT

Percentile Y
3.125 41.5
9.375 43.5
15.625 45.5
21.875 47.5
28.125 49.5
34.375 53.5
40.625 54.6
46.875 55.5
53.125 57.5
59.375 57.6
65.625 58.8
71.875 59.1
78.125 59.5
84.375 61.5
90.625 61.5
96.875 68.7
X1 Residual Plot
4
X2 Residual Plot

Residuals
0
4 6 8 10 12
X1 Line
14 16
18
Fit
20
Plot
-4 4 80
60
X2 Line Fit Plot

Residuals
-8 0
40 Y
3 X1 4 5 80
6 7 8 9 10
Predicted Y

Y
-4 20 60
-8 0 40
4 6 8 10
20 X212 14 16 18 20

Y
0 X1
3 4 5 6 7 8 9 1
Normal
X2 Probab
80
60
40

Y
20
0
0 20 40 60
Sample Perc
lot
it Plot
X2 Line Fit Plot
Y
8 9 10
Predicted Y
Y
4 16 18 20 Predicted Y

5 6 7 8 9 10
Normal
X2 Probability Plot
80
60
40
20
0
0 20 40 60 80 100 120
Sample Percentile
Years Y X1 X2
1 45.5 7.3 4.1
2 41.5 6.3 5.1
3 43.5 8.3 4.1
4 47.5 9.3 4.1
5 49.5 8.3 5.1
6 53.5 9.3 6.1
7 55.5 10.3 7.1
8 59.5 10.3 8.1
9 57.5 11.3 8.1
10 61.5 12.3 9.1
11 54.6 10.9 6.7
12 58.8 11.8 5.9
13 61.5 14.7 8
14 59.1 16.6 9.3
15 57.6 17.2 5.6
16 68.7 18.9 9.1

You might also like