0% found this document useful (0 votes)
53 views9 pages

Casharka 5

The document reports the results of a regression analysis with consumption as the dependent variable and income as the independent variable using data from 15 years. It finds that income has a significant positive relationship with consumption, with income explaining 97.7% of the variation in consumption. The regression equation is Consumption = -5.66 + 0.92*Income.

Uploaded by

Daadir Abdi
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)
53 views9 pages

Casharka 5

The document reports the results of a regression analysis with consumption as the dependent variable and income as the independent variable using data from 15 years. It finds that income has a significant positive relationship with consumption, with income explaining 97.7% of the variation in consumption. The regression equation is Consumption = -5.66 + 0.92*Income.

Uploaded by

Daadir Abdi
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

Regression Analysis

r² 0.977 n 15
r 0.989 k 1
Std. Error 3.514 Dep. Var. consumption

ANOVA table
Source SS df MS F p-value
Regression 6,901.2138 1 6,901.2138 558.91 4.56E-12
Residual 160.5196 13 12.3477
Total 7,061.7333 14

Regression output confidence interval


variables coefficients std. error t (df=13) p-value 95% lower 95% upper
Intercept -5.6642 5.9964 -0.945 .3621 -18.6187 7.2903
Income 0.9191 0.0389 23.641 4.56E-12 0.8351 1.0031

Regression Analysis

r² 0.977
r 0.989
Std. Error 3.514
n 15
k 1
Dep. Var. consumption

ANOVA table
Source SS df MS F p-value
Regression 6,901.2138 1 6,901.2138 558.91 4.56E-12
Residual 160.5196 13 12.3477
Total 7,061.7333 14

Regression output confidence interval


variables coefficients std. error t (df=13) p-value 95% lower 95% upper
Intercept -5.6642 5.9964 -0.945 .3621 -18.6187 7.2903
Income 0.9191 0.0389 23.641 4.56E-12 0.8351 1.0031

Regression Analysis

r² 0.977
r 0.989
Std. Error 3.514
n 15
k 1
Dep. Var. consumption

ANOVA table
Source SS df MS F p-value
Regression 6,901.2138 1 6,901.2138 558.91 4.56E-12
Residual 160.5196 13 12.3477
Total 7,061.7333 14

Regression output confidence interval


variables coefficients std. error t (df=13) p-value 95% lower 95% upper
Intercept -5.6642 5.9964 -0.945 .3621 -18.6187 7.2903
Income 0.9191 0.0389 23.641 4.56E-12 0.8351 1.0031

Regression Analysis

r² 0.977
r 0.989
Std. Error 3.514
n 15
k 1
Dep. Var. consumption

ANOVA table
Source SS df MS F p-value
Regression 6,901.2138 1 6,901.2138 558.91 4.56E-12
Residual 160.5196 13 12.3477
Total 7,061.7333 14

Regression output confidence interval


variables coefficients std. error t (df=13) p-value 95% lower 95% upper
Intercept -5.6642 5.9964 -0.945 .3621 -18.6187 7.2903
Income 0.9191 0.0389 23.641 4.56E-12 0.8351 1.0031
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.988569
R Square 0.977269
Adjusted R 0.975521
Standard E 3.513923
Observatio 15

ANOVA
df SS MS F Significance F
Regression 1 6901.214 6901.214 558.9087 4.56E-12
Residual 13 160.5196 12.34766
Total 14 7061.733

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -5.664167 5.996423 -0.944591 0.362094 -18.61865 7.290318 -18.61865 7.290318
Income 0.919092 0.038877 23.64125 4.56E-12 0.835104 1.003079 0.835104 1.003079
The data below reports the food consumption and disbosible income for developme

consumption Income
102 114 -38.467 1479.71 -32.467 1054.106
106 118 -34.467 1187.974 -28.467 810.3701
108 126 -26.467 700.5021 -26.467 700.5021
110 130 -22.467 504.7661 -24.467 598.6341
122 136 -16.467 271.1621 -12.467 155.4261
124 140 -12.467 155.4261 -10.467 109.5581
y 152.4667 128 148 -4.467 19.95409 -6.467 41.82209
x 134.4667 130 156 3.533 12.48209 -4.467 19.95409
142 160 7.533 56.74609 7.533 56.74609
148 164 11.533 133.0101 13.533 183.1421
150 170 17.533 307.4061 15.533 241.2741
154 178 25.533 651.9341 19.533 381.5381
160 180 27.533 758.0661 25.533 651.9341
165 182 29.533 872.1981 30.533 932.2641
168 185 32.533 1058.396 33.533 1124.462
Total 2017 2287 -0.005 8169.733 -0.005 7061.733

BETA 1 -5.6624
BETA 2 0.919092
sible income for development economicd for 15 years from 2001 to 2015

1248.908089 99.106 2.894 8.37524


981.172089 102.782 3.218 10.3555
700.502089 110.134 -2.134 4.55396
549.700089 113.81 -3.81 14.5161
205.294089 119.324 2.676 7.16098
130.492089 123 1 1
28.888089 130.352 -2.352 5.5319
-15.781911 137.704 -7.704 59.3516
56.746089 141.38 0.62 0.3844
156.076089 145.056 2.944 8.66714
272.340089 150.57 -0.57 0.3249
498.736089 157.922 -3.922 15.3821
703.000089 159.76 0.24 0.0576
901.731089 161.598 3.402 11.5736
1090.929089 164.355 3.645 13.286
7508.733335 2016.85 0.147 160.521
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.987325
R Square 0.97481
Adjusted R 0.972711
Standard E 3.528854
Observatio 14

ANOVA
df SS MS F Significance F
Regression 1 5782.923 5782.923 464.3871 5.826E-11
Residual 12 149.4337 12.45281
Total 13 5932.357

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -8.676007 6.815645 -1.272955 0.227143 -23.52602 6.174007 -23.52602 6.174007
114 0.937167 0.043489 21.54964 5.826E-11 0.842413 1.031921 0.842413 1.031921
consumption Income
102 114
106 118
108 126
110 130
122 136
124 140
128 148
130 156
142 160
148 164
150 170
154 178
160 180
165 182
168 185

You might also like