proiect statistica (1)
-
Upload
lenuta-duplava -
Category
Documents
-
view
41 -
download
2
description
Transcript of proiect statistica (1)
Banii in cir Depozitex y
2012 ianuarie 10.2802 11447.1februarie 10.4766 11477.3martie 10.6736 11661.7apr 10.9607 11858.4mai 10.8588 12054.5iun 11.2439 12140.6iul 11.7609 12429.5aug 12.4174 13070.9sept 12784.9 13319.4oct 12537.4 13580.8noiem 12670.7 14058.8dec 13240.8 14307.2
2013 ianuarie 12772.2 14940.7februarie 12902.8 15006.3martie 12892.8 15003.8apr 13293 15303.3mai 13523 15387.4iun 13997.7 15671iul 14867.3 16147.9aug 15626 16630.7sept 16155.8 16697.9oct 16899 17227.6noiem 16937.9 17605.4dec 17550.5 17997.4
2014 ianuarie 16900.7 18170.5februarie 16715.9 18081martie 16656.2 17886.5apr 17027.5 17853.7mai 17301.1 17834.7iun 17610.6 17700.6iul 18137.3 17585.4
349089.8 470138
9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 1900010000
11000
12000
13000
14000
15000
16000
17000
18000
19000
f(x) = 0.308835871443549 x + 11687.9534200473R² = 0.841170411821184
Corelatia dintre banii in circulatie si depozite
Column ELinear (Column E)
Bani in circulatie
Depo
zite
Y X
11.4471 10280.2
11.4773 10476.6
11.6617 10673.6
11.8584 10960.7Mai 2012 12.0545 10858.8
12.1406 11243.9Iulie 2012
12.4295 11760.9
13.0709 12417.4
13.3194 12784.9
13.5808 12537.4
14.0588 12670.7
14.3072 13240.8
Ianuarie 2012
Februarie 2012
Martie 2012
Aprilie 2012
Iunie 2012
August 2012
Septembrie 2012
Octombrie 2012
Noiembrie 2012
Decembrie 2012
14.9407 12772.2Feb 2013 15.0063 12902.8
15.0038 12892.8
15303.3 13293Mai 2013 15387.4 13523
15671 13997.7Iulie 2013
16147.9 14867.3
16630.7 15626Sept 2013
16697.9 16155.8Oct 2013 17227.6 16899Noie 2013
17605.4 16937.9
17997.4 17550.5
18170.5 16900.7Feb 2014 18081 16715.9
17886.5 16656.2
17853.7 17027.5Mai 2014 17834.7 17301.1
17700.6 17610.6Iulie 2014
17585.4 18137.3TOTAL 470138 437673.2
-5.456472â=
Ianuarie 2013
Martie 2013
Aprilie 2013
Iunie 3013
August 2013
Decembrie 2013
Ianuarie 2014
Martie 2014
Aprilie 2014
Iunie 2014
34567
25
9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 1900010000
11000
12000
13000
14000
15000
16000
17000
18000
19000
f(x) = 0.308835871443549 x + 11687.9534200473R² = 0.841170411821184
Corelatia dintre banii in circulatie si depozite
Column ELinear (Column E)
Bani in circulatie
Depo
zite
105682.512 117.6784774
109759.1476 120.2430812
113925.737 124.4723211
120136.9445 129.9763649
117913.5374 130.8974046126425.2872 136.5076923
138318.7688 146.1821066
154191.8228 162.3065937
163453.668 170.2871971
157186.3988 170.2679219
160546.6385 178.1348372
175318.7846 189.4387738
2ˆ yy 2yyi 2xxi
163129.0928 190.8256085
166482.2478 193.6232876166224.2918 193.4409926
176703.849 203426.7669
182871.529 208083.8102195935.6053 219357.9567
221036.6093 240075.6737
244171.876 259871.3182
261009.8736 269767.9328
285576.201 291129.2124286892.4564 298198.5047
308020.0503 315863.3687
285633.6605 307094.1694
279421.3128 302240.1879277428.9984 297921.1213
289935.7563 304003.8768
299328.0612 308559.9282310133.2324 311718.1864
328961.6513 318951.6754
6371755.602 4458617.972
SUMMARY OUTPUT
Regression StatisticsMultiple R 0.9746012146R Square 0.9498475275Adjusted R Squar 0.9480563677Standard Error 0.5334159589Observations 30
ANOVAdf SS MS F Significance F
Regression 1 150.887 150.887 530.297 9.7496471E-20Residual 28 7.967 0.285Total 29 158.854
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%Intercept 2.1286 0.5710 3.727846 0.000867364563 0.9590 3.2983x 0.9265 0.0402 23.02819 9.750E-20 0.8441 1.0089
RESIDUAL OUTPUT
Observation Predicted y Residuals1 11.653 -0.2062 11.835 -0.3583 12.018 -0.3564 12.284 -0.4255 12.189 -0.1356 12.546 -0.4057 13.025 -0.5958 13.633 -0.5629 13.974 -0.654
10 13.744 -0.16411 13.868 0.19112 14.396 -0.08913 13.962 0.97914 14.083 0.92315 14.074 0.93016 14.444 0.85917 14.657 0.73018 15.097 0.57419 15.903 0.24520 16.606 0.02521 17.097 -0.39922 17.785 -0.55823 17.821 -0.21624 18.389 -0.392
25 17.787 0.38426 17.616 0.46527 17.560 0.32628 17.904 -0.05129 18.158 -0.32330 18.445 -0.744
Lower 80,0% Upper 80,0%1.3792 2.87810.8737 0.9793 10 11 12 13 14 15 16 17 18
10
11
12
13
14
15
16
17
18
19
f(x) = 0.926486558741572 x + 2.1286075913484R² = 0.949847527454942
x Line Fit Plot
yLinear (y)Predicted y
x
y
10 11 12 13 14 15 16 17 1810
11
12
13
14
15
16
17
18
19
f(x) = 0.926486558741572 x + 2.1286075913484R² = 0.949847527454942
x Line Fit Plot
yLinear (y)Predicted y
x
y
Banii in cir Depozitex y x^2 x*y y^2 (Y-ymed)^2
2012 ianuarie 10.2802 11.4471 105.6825 117.6785 11.65 131.04 februarie 10.4766 11.4773 109.7591 120.2431 11.84 131.73 martie 10.6736 11.6617 113.9257 124.4723 12.02 136.00 apr 10.9607 11.8584 120.1369 129.9764 12.28 140.62 mai 10.8588 12.0545 117.9135 130.8974 12.19 145.31 iun 11.2439 12.1406 126.4253 136.5077 12.55 147.39 iul 11.7609 12.4295 138.3188 146.1821 13.02 154.49 aug 12.4174 13.0709 154.1918 162.3066 13.63 170.85 sept 12.7849 13.3194 163.4537 170.2872 13.97 177.41 oct 12.5374 13.5808 157.1864 170.2679 13.74 184.44 noiem 12.6707 14.0588 160.5466 178.1348 13.87 197.65 dec 13.2408 14.3072 175.3188 189.4388 14.40 204.70
2013 ianuarie 12.7722 14.9407 163.1291 190.8256 13.96 223.22 februarie 12.9028 15.0063 166.4822 193.6233 14.08 225.19 martie 12.8928 15.0038 166.2243 193.441 14.07 225.11 apr 13.293 15.3033 176.7038 203.4268 14.44 234.19 mai 13.523 15.3874 182.8715 208.0838 14.66 236.77 iun 13.9977 15.671 195.9356 219.358 15.10 245.58 iul 14.8673 16.1479 221.0366 240.0757 15.90 260.75 aug 15.626 16.6307 244.1719 259.8713 16.61 276.58 sept 16.1558 16.6979 261.0099 269.7679 17.10 278.82 oct 16.899 17.2276 285.5762 291.1292 17.79 296.79 noiem 16.9379 17.6054 286.8925 298.1985 17.82 309.95 dec 17.5505 17.9974 308.0201 315.8634 18.39 323.91
2014 ianuarie 16.9007 18.1705 285.6337 307.0942 17.79 330.17 februarie 16.7159 18.081 279.4213 302.2402 17.62 326.92 martie 16.6562 17.8865 277.429 297.9211 17.56 319.93 apr 17.0275 17.8537 289.9358 304.0039 17.90 318.75 mai 17.3011 17.8347 299.3281 308.5599 18.16 318.08 iun 17.6106 17.7006 310.1332 311.7182 18.44 313.31
419.5359 452.5526 6042.794 6491.595 452.55 6,985.65 x y x^2 x*y y^2 (Y-ymed)^2
a= 2.128608b= 0.926487ymed= 15.08509r= 0.974601
23.4358t tab= 1.311t calc r =
(Y-ymed)^2
(Y-ymed)^2
10 11 12 13 14 15 16 17 1811
12
13
14
15
16
17
18
19
f(x) = 0.926486558741572 x + 2.1286075913484R² = 0.949847527454942
Column DLinear (Column D)
10 11 12 13 14 15 16 17 1811
12
13
14
15
16
17
18
19
f(x) = 0.926486558741572 x + 2.1286075913484R² = 0.949847527454942
Column DLinear (Column D)