Prognozowanie 20 02 i 06 03 2013


Overview

20.02 i 06.03 - miary dopasowa
17.04 - średnie ruchome
15.05. model Wintersa
15.05. model Wintersa
15.05 model Wintersa
Arkusz3


Sheet 1: 20.02 i 06.03 - miary dopasowa









Miara dopasowania prognoz



Data [kwartały] PKB [mln złotych] Prognoza PKB [mln złotych] Błąd prognozy Absolutny błąd prognozy Kwadratowy błąd prognozy Błąd procentowy Absolutny błąd procentowy Błąd skumulowany cząstkowy Błąd skumulowany punktowy

5%

2002.1 187,570.0










2002.2 197,917.5










2002.3 200,185.1










2002.4 222,186.9










2003.1 193,721.5 187,570.0 6,151.50 6151.50 37840952.25 3.28% 3.28% 1 6,151.50 3.28%

2003.2 206,999.9 201,241.2 5,758.65 5758.65 33162089.55 2.86% 2.86% 1 11,910.15 6.14%

2003.3 208,078.5 207,950.4 128.13 128.13 16416.94 0.06% 0.06% 1 12,038.28 6.20%

2003.4 233,320.5 233,865.2 -544.72 544.72 296716.30 -0.23% 0.23% 1 11,493.57 5.97%

2004.1 213,035.6 202,496.4 10,539.24 10539.24 111075577.11 5.20% 5.20% 0 22,032.81 11.17%

2004.2 224,806.1 221,755.8 3,050.29 3050.29 9304241.08 1.38% 1.38% 1 25,083.09 12.55%

2004.3 228,044.8 228,548.8 -504.00 504.00 254016.51 -0.22% 0.22% 1 24,579.09 12.33%

2004.4 258,651.1 259,800.2 -1,149.12 1149.12 1320484.40 -0.44% 0.44% 1 23,429.97 11.89%

2005.1 229,395.8 232,734.4 -3,338.64 3338.64 11146543.65 -1.43% 1.43% 1 20,091.32 10.45%

2005.2 238,094.5 245,639.1 -7,544.62 7544.62 56921359.88 -3.07% 3.07% 1 12,546.70 7.38%

2005.3 241,759.8 245,455.8 -3,695.97 3695.97 13660159.96 -1.51% 1.51% 1 8,850.73 5.88%

2005.4 274,052.2 273,936.2 116.00 116.00 13455.23 0.04% 0.04% 1 8,966.73 5.92%

2006.1 242,784.9 241,667.2 1,117.71 1117.71 1249276.18 0.46% 0.46% 1 10,084.44 6.38%

2006.2 255,497.1 252,550.7 2,946.39 2946.39 8681231.57 1.17% 1.17% 1 13,030.83 7.55%

2006.3 261,510.9 257,414.6 4,096.29 4096.29 16779585.30 1.59% 1.59% 1 17,127.12 9.14%

2006.4 300,238.5 293,873.8 6,364.68 6364.68 40509211.11 2.17% 2.17% 1 23,491.81 11.30%

2007.1 270,132.1 264,335.2 5,796.90 5796.90 33604021.26 2.19% 2.19% 1 29,288.70 13.50%

2007.2 282,921.9 282,672.3 249.60 249.60 62299.24 0.09% 0.09% 1 29,538.30 13.59%

2007.3 291,058.5 291,356.7 -298.20 298.20 88924.00 -0.10% 0.10% 1 29,240.10 13.48%

2007.4 332,624.2 334,759.1 -2,134.94 2134.94 4557987.19 -0.64% 0.64% 1 27,105.16 12.85%

2008.1 299,128.7 299,592.8 -464.11 464.11 215393.76 -0.15% 0.15% 1 26,641.05 12.69%

2008.2 310,865.5 314,831.9 -3,966.43 3966.43 15732598.25 -1.26% 1.26% 1 22,674.62 11.43%

2008.3 314,721.8 321,474.1 -6,752.26 6752.26 45593078.10 -2.10% 2.10% 1 15,922.35 9.33%

2008.4 350,716.3 363,134.5 -12,418.17 12418.17 154211065.70 -3.42% 3.42% 1 3,504.18 5.91%

2009.1 312,888.4 318,245.4 -5,357.00 5357.00 28697428.45 -1.68% 1.68% 1 -1,852.82 4.23%

2009.2 325,235.8 325,494.9 -259.12 259.12 67145.65 -0.08% 0.08% 1 -2,111.94 4.15%

2009.3 332,291.4 327,289.4 5,002.03 5002.03 25020296.29 1.53% 1.53% 1 2,890.08 5.68%

2009.4 373,240.9 368,774.2 4,466.67 4466.67 19951139.58 1.21% 1.21% 1 7,356.75 6.89%

2010.1 323,950.8 330,860.4 -6,909.63 6909.63 47743020.50 -2.09% 2.09% 1 447.12 4.80%

2010.2 343,180.3 340,691.5 2,488.81 2488.81 6194189.20 0.73% 0.73% 1 2,935.93 5.53%

2010.3
346,710.2
















l. dopuszczalnych 29 MAE 3786.99








l. prognoz 30 MAPE 1.41%








współczynnik trafności prognoz 96.67%



























suma 8,272,948.3 8,270,012.4 2,935.9 113,609.8 723,969,904.2 5.53% 42.40%




średnia 275,764.9 275,667.1 97.9 3,787.0 24,132,330.1 0.18% 1.41%




wariancja 2407784808.6 2588131170.0 24954571.7








odchylenie 49069.2 50873.7 4995.5
































Kompozycja Thaila

średnia wariancja odchylenie MSE RMSE Współczynnik zmienności prognoz Współczynnik trafności prognoz Pearson Pierwsza Druga
PKB 275,764.9 2407784808.6 49069.2 24964479.5 4996.45 1.81% 96.67% 0.9957 0.1304
Prognoza PKB 275,667.1 2588131170.0 50873.7 0.8692
Błąd prognozy 97.9 24954571.7 4995.5 0.0003969

Sheet 2: 17.04 - średnie ruchome



k = 4 , j = 1


k = 4 , j = 1

k = 4 , j = 1

Data [kwartały] PKB [mln złotych] metoda średniej ruchomej Błąd prognozy Kwadratowy błąd prognozy
metoda wag Błąd prognozy Kwadratowy błąd prognozy metoda wag liniowych Błąd prognozy Kwadratowy błąd prognozy

2002.1 187,570.0


waga 1 0.1

0.10

2002.2 197,917.5


waga 2 0.1

0.20

2002.3 200,185.1


waga 3 0.3

0.30

2002.4 222,186.9


waga 4 0.5

0.40

2003.1 193,721.5 201,964.9 -8,243.4 67,953,231.4
209,697.7 -15,976.2 255,239,925.0 207,270.8 -13,549.3 183,583,259.5
2003.2 206,999.9 203,502.8 3,497.2 12,230,058.1
203,327.1 3,672.8 13,489,606.8 203,973.4 3,026.5 9,159,460.1
2003.3 208,078.5 205,773.4 2,305.2 5,313,716.5
203,853.6 4,224.9 17,849,780.0 205,372.3 2,706.2 7,323,518.4
2003.4 233,320.5 207,746.7 25,573.8 654,019,246.4
207,730.1 25,590.4 654,870,619.4 206,294.4 27,026.1 730,412,243.3
2004.1 213,035.6 210,530.1 2,505.5 6,277,530.3
219,155.9 -6,120.3 37,458,561.7 216,523.9 -3,488.3 12,168,097.4
2004.2 224,806.1 215,358.6 9,447.5 89,254,783.9
218,021.8 6,784.3 46,026,862.2 217,526.1 7,280.0 52,998,691.2
2004.3 228,044.8 219,810.2 8,234.6 67,809,048.9
220,453.6 7,591.2 57,625,862.0 221,305.1 6,739.7 45,423,960.5
2004.4 258,651.1 224,801.8 33,849.4 1,145,778,495.4
226,099.8 32,551.3 1,059,584,527.6 224,598.9 34,052.2 1,159,550,962.8
2005.1 229,395.8 231,134.4 -1,738.6 3,022,730.0
241,523.2 -12,127.4 147,072,860.6 238,138.7 -8,742.9 76,437,601.0
2005.2 238,094.5 235,224.5 2,870.1 8,237,187.0
237,578.3 516.2 266,441.8 237,443.2 651.3 424,165.6
2005.3 241,759.8 238,546.6 3,213.3 10,324,975.6
236,535.6 5,224.2 27,292,474.6 238,591.2 3,168.6 10,039,772.5
2005.4 274,052.2 241,975.3 32,076.9 1,028,927,513.6
241,112.9 32,939.3 1,084,994,849.3 239,876.5 34,175.7 1,167,975,736.4
2006.1 242,784.9 245,825.6 -3,040.7 9,245,704.5
256,303.1 -13,518.2 182,740,920.1 252,707.3 -9,922.4 98,454,021.8
2006.2 255,497.1 249,172.9 6,324.3 39,996,138.1
251,593.5 3,903.6 15,237,780.7 251,491.0 4,006.1 16,048,596.8
2006.3 261,510.9 253,523.5 7,987.4 63,798,558.8
252,165.2 9,345.7 87,341,734.7 254,020.7 7,490.2 56,102,646.6
2006.4 300,238.5 258,461.3 41,777.2 1,745,336,528.7
259,088.3 41,150.2 1,693,339,783.0 257,215.7 43,022.8 1,850,962,180.3
2007.1 270,132.1 265,007.9 5,124.3 26,257,938.1
278,400.7 -8,268.6 68,370,076.7 273,926.6 -3,794.5 14,398,078.5
2007.2 282,921.9 271,844.7 11,077.3 122,705,467.6
276,838.4 6,083.5 37,008,972.3 275,976.3 6,945.6 48,241,637.2
2007.3 291,058.5 278,700.9 12,357.7 152,711,513.5
278,675.5 12,383.0 153,338,193.7 280,407.2 10,651.3 113,450,617.7
2007.4 332,624.2 286,087.8 46,536.5 2,165,641,178.6
287,442.9 45,181.3 2,041,351,676.9 285,350.2 47,274.0 2,234,827,294.1
2008.1 299,147.7 294,184.2 4,963.5 24,636,580.4
308,935.1 -9,787.4 95,792,220.0 303,964.8 -4,817.1 23,204,645.1
2008.2 310,884.3 301,438.1 9,446.2 89,231,166.8
306,759.2 4,125.1 17,016,862.5 305,950.2 4,934.1 24,345,046.8
2008.3 314,741.7 308,428.7 6,313.0 39,854,284.7
307,554.7 7,187.0 51,652,537.8 309,728.7 5,013.0 25,129,968.5
2008.4 350,734.6 314,349.5 36,385.1 1,323,877,321.3
313,813.3 36,921.3 1,363,180,178.4 312,253.9 38,480.7 1,480,761,963.6
2009.1 313,058.1 318,877.1 -5,819.0 33,860,470.1
330,793.0 -17,734.9 314,527,032.7 326,808.0 -13,749.9 189,059,200.0
2009.2 325,485.6 322,354.7 3,130.9 9,802,691.4
324,312.0 1,173.6 1,377,266.5 324,480.4 1,005.2 1,010,447.1
2009.3 332,478.9 326,005.0 6,473.9 41,911,381.2
323,207.9 9,271.0 85,952,182.7 325,732.8 6,746.1 45,510,404.9
2009.4 373,482.5 330,439.3 43,043.2 1,852,717,066.2
330,264.4 43,218.1 1,867,804,167.6 328,322.3 45,160.2 2,039,441,857.6
2010.1 323,206.6 336,126.3 -12,919.7 166,918,002.1
350,339.3 -27,132.7 736,182,866.6 345,539.6 -22,333.0 498,762,889.0
2010.2 344,700.0 338,663.4 6,036.6 36,440,539.6
339,444.5 5,255.5 27,620,280.3 340,371.7 4,328.3 18,733,921.2
2010.3 350,607.2 343,467.0 7,140.2 50,982,456.0
339,908.1 10,699.1 114,470,312.8 342,786.4 7,820.8 61,165,381.9
2010.4 398,071.5 347,999.1 50,072.4 2,507,247,745.4
348,382.5 49,689.0 2,468,995,727.2 345,642.5 52,429.1 2,748,805,283.9
2011.1 348,537.6 354,146.3 -5,608.7 31,457,796.1
371,008.6 -22,471.0 504,944,492.7 365,671.4 -17,133.8 293,567,787.8
2011.2 368,884.7 360,479.1 8,405.6 70,654,531.6
363,221.0 5,663.7 32,077,837.5 363,427.9 5,456.8 29,776,338.8
2011.3 375,355.6 366,525.3 8,830.3 77,975,081.1
363,871.5 11,484.1 131,884,552.8 366,790.2 8,565.4 73,366,419.8
2011.4 430,467.4 372,712.4 57,755.1 3,335,645,800.5
373,004.1 57,463.3 3,302,028,548.4 370,322.3 60,145.1 3,617,430,648.2
2012.1 370,721.0 380,811.3 -10,090.3 101,814,658.6
399,582.6 -28,861.6 832,992,531.8 393,424.3 -22,703.3 515,441,647.2
2012.2 388,258.0 386,357.2 1,900.8 3,613,135.7
388,924.8 -666.8 444,555.6 389,388.2 -1,130.2 1,277,374.6
2012.3 392,078.0 391,200.5 877.5 770,006.3
385,927.6 6,150.4 37,827,420.2 390,148.5 1,929.5 3,722,815.9
2012.4 444,826.0 395,381.1 49,444.9 2,444,798,136.0
392,635.2 52,190.8 2,723,875,429.4 390,499.5 54,326.5 2,951,364,256.1
2013.1
398,970.8 -398,970.8 159,177,659,355.6
415,934.3 -415,934.3 173,001,341,916.5 410,277.5 -410,277.5 168,327,627,006.3















MSE 504334625.532068

MSE 574132013.143377
MSE 577688739.481788



RMSE 22457.3957869578

RMSE 23961.052004104
RMSE 24035.1563232234



V 5.63%

V 5.76%
V 5.86%

Sheet 3: 15.05. model Wintersa


pkb [mln zł] mt dt pt PROGNOZA błąd prognozy błąd kwadratowy
zoptymalizowane (obliczone przy pomocy solver) alfa 0.300000
2007.10 270,132.10

-24,052.08



beta 0.400000
2007.20 282,921.90

-11,262.28



gamma 0.800000
2007.30 291,058.50

-3,125.67




j 1.000000
2007.40 332,624.20

38,440.03







2008.10 299,147.70 294,184.18 0.00 -839.59




nasze założenie alfa 0.3
2008.20 310,884.30 302,572.90 3,355.49 4,396.67 282,921.90 27,962.40 781,895,813.76

beta 0.4
2008.30 314,741.70 309,510.08 4,788.17 3,560.16 302,802.71 11,938.99 142,539,529.98

gamma 0.8
2008.40 350,734.60 313,697.15 4,547.73 37,317.97 352,738.27 -2,003.67 4,014,704.05




2009.10 313,058.10 316,940.72 4,026.07 -3,274.01 317,405.28 -4,347.18 18,897,949.36




2009.20 325,485.60 321,003.43 4,040.72 4,465.07 325,363.45 122.15 14,919.87




2009.30 332,478.90 326,206.53 4,505.67 5,729.93 328,604.31 3,874.59 15,012,437.05




2009.40 373,482.50 332,347.90 5,159.95 40,371.27 368,030.17 5,452.33 29,727,912.36




2010.10 323,206.60 334,199.68 3,836.68 -9,449.27 334,233.84 -11,027.24 121,599,996.93




2010.20 344,700.00 338,695.93 4,100.51 5,696.27 342,501.44 2,198.56 4,833,678.97




2010.30 350,607.20 343,420.69 4,350.21 6,895.19 348,526.38 2,080.82 4,329,825.39




2010.40 398,071.50 350,749.70 5,541.73 45,931.69 388,142.18 9,929.32 98,591,436.94




2011.10 348,537.60 356,800.06 5,745.18 -8,499.82 346,842.16 1,695.44 2,874,509.00




2011.20 368,884.70 362,738.20 5,822.36 6,056.45 368,241.51 643.19 413,693.38




2011.30 375,355.60 368,530.52 5,810.35 6,839.10 375,455.76 -100.16 10,031.29




2011.40 430,467.40 377,399.32 7,033.73 51,640.81 420,272.56 10,194.84 103,934,799.49




2012.10 370,117.70 382,688.39 6,335.86 -11,756.51 375,933.22 -5,815.52 33,820,282.39




2012.20 389,122.40 387,236.76 5,620.87 2,719.80 395,080.70 -5,958.30 35,501,396.17




2012.30 393,792.40 391,086.33 4,912.35 3,532.68 399,696.73 -5,904.33 34,861,135.62




2012.40 442,231.40 394,376.25 4,263.38 48,612.28 447,639.48 -5,408.08 29,247,352.89









386,883.12 MSE 81,228,966.94




Winters Addytywny AA

RMS 9,012.71





Sheet 4: 15.05. model Wintersa


pkb [mln zł] mt dt pt PROGNOZA błąd prognozy błąd kwadratowy
zoptymalizowane (obliczone przy pomocy solver) alfa 0.386131
2007.10 270,132.10

0.9182



beta 0.301791
2007.20 282,921.90

0.9617



gamma 0.529663
2007.30 291,058.50

0.9894




j 1.000000
2007.40 332,624.20

1.1307







2008.10 299,147.70 294,184.18 1.00 0.9705




nasze założenie alfa 0.2
2008.20 310,884.30 305,411.13 1.01 0.9915 282,921.90 27,962.40 781,895,813.76

beta 0.3
2008.30 314,741.70 312,478.36 1.02 0.9988 305,646.29 9,095.41 82,726,480.26

gamma 0.4
2008.40 350,734.60 314,481.33 1.01 1.1225 358,617.25 -7,882.65 62,136,239.65




2009.10 313,058.10 320,007.07 1.01 0.9746 308,990.72 4,067.38 16,543,597.12




2009.20 325,485.60 325,947.61 1.02 0.9952 321,717.50 3,768.10 14,198,578.59




2009.30 332,478.90 331,692.50 1.02 1.0007 330,570.61 1,908.29 3,641,553.29




2009.40 373,482.50 335,355.84 1.01 1.1178 378,304.37 -4,821.87 23,250,472.86




2010.10 323,206.60 336,907.60 1.01 0.9665 331,593.82 -8,387.22 70,345,408.22




2010.20 344,700.00 342,940.24 1.01 1.0005 339,176.80 5,523.20 30,505,740.16




2010.30 350,607.20 348,639.33 1.01 1.0033 347,804.62 2,802.58 7,854,444.16




2010.40 398,071.50 354,608.36 1.02 1.1203 395,342.04 2,729.46 7,449,929.27




2011.10 348,537.60 360,241.92 1.02 0.9670 347,957.19 580.41 336,877.25




2011.20 368,884.70 366,922.87 1.02 1.0031 365,976.57 2,908.13 8,457,193.47




2011.30 375,355.60 373,386.22 1.02 1.0044 374,168.97 1,186.63 1,408,091.38




2011.40 430,467.40 381,410.85 1.02 1.1247 425,326.31 5,141.09 26,430,815.16




2012.10 370,117.70 386,176.66 1.02 0.9625 375,546.18 -5,428.48 29,468,341.05




2012.20 389,122.40 390,758.75 1.02 0.9992 393,734.82 -4,612.42 21,274,463.77




2012.30 393,792.40 394,886.77 1.01 1.0006 398,377.76 -4,585.36 21,025,509.26




2012.40 442,231.40 397,556.00 1.01 1.1182 450,230.71 -7,999.31 63,988,880.58









397,557.97 MSE 70,718,801.63




Winters Multiplikatywny MA

RMS 8,409.45





Sheet 5: 15.05 model Wintersa


pkb [mln zł] mt dt pt PROGNOZA błąd prognozy błąd kwadratowy
zoptymalizowane (obliczone przy pomocy solver) alfa 0.377308
2007.10 270,132.10

0.9182



beta 0.337978
2007.20 282,921.90

0.9617



gamma 0.525024
2007.30 291,058.50

0.9894




j 1.000000
2007.40 332,624.20

1.1307







2008.10 299,147.70 294,184.18 0.00 0.9700




nasze założenie alfa 0.2
2008.20 310,884.30 305,154.59 3,707.76 0.9917 282,921.90 27,962.40 781,895,813.76

beta 0.3
2008.30 314,741.70 312,355.98 4,888.53 0.9990 305,580.72 9,160.98 83,923,469.27

gamma 0.4
2008.40 350,734.60 314,587.18 3,990.41 1.1224 358,697.75 -7,963.15 63,411,780.54




2009.10 313,058.10 320,145.08 4,520.19 0.9741 309,028.20 4,029.90 16,240,074.26




2009.20 325,485.60 326,005.81 4,973.26 0.9952 321,962.28 3,523.32 12,413,794.91




2009.30 332,478.90 331,675.13 5,208.51 1.0008 330,636.00 1,842.90 3,396,276.87




2009.40 373,482.50 335,326.31 4,682.17 1.1179 378,115.17 -4,632.67 21,461,635.84




2010.10 323,206.60 336,906.27 3,633.69 0.9664 331,215.93 -8,009.33 64,149,413.74




2010.20 344,700.00 342,735.84 4,375.85 1.0007 338,908.03 5,791.97 33,546,938.52




2010.30 350,607.20 348,327.47 4,786.76 1.0038 347,382.43 3,224.77 10,399,117.00




2010.40 398,071.50 354,239.58 5,167.10 1.1210 394,737.33 3,334.17 11,116,656.73




2011.10 348,537.60 359,882.42 5,327.89 0.9675 347,319.16 1,218.44 1,484,603.51




2011.20 368,884.70 366,494.79 5,762.01 1.0038 365,477.87 3,406.83 11,606,459.49




2011.30 375,355.60 372,888.93 5,975.66 1.0053 373,673.85 1,681.75 2,828,281.30




2011.40 430,467.40 380,809.64 6,633.05 1.1259 424,688.81 5,778.59 33,392,066.97




2012.10 370,117.70 385,600.60 6,010.46 0.9635 374,841.10 -4,723.40 22,310,536.76




2012.20 389,122.40 390,120.39 5,506.65 1.0004 393,088.09 -3,965.69 15,726,660.76




2012.30 393,792.40 394,154.27 5,008.88 1.0020 397,716.39 -3,923.99 15,397,710.89




2012.40 442,231.40 396,753.23 4,194.38 1.1200 449,422.74 -7,191.34 51,715,400.39









386,301.11 MSE 69,800,927.31




Metoda mieszana


RMS 8,354.69





Sheet 6: Arkusz3


pkb [mln zł] mt dt pt PROGNOZA błąd prognozy błąd kwadratowy
zoptymalizowane (obliczone przy pomocy solver) alfa 0.471901
2007.10 270,132.10

-24,052.0750



beta 0.271367
2007.20 282,921.90

-11,262.2750



gamma 0.262031
2007.30 291,058.50

-3,125.6750




j 1.000000
2007.40 332,624.20

38,440.0250







2008.10 299,147.70 294,184.18 0.0000 -16,449.0883




nasze założenie alfa 0.2
2008.20 310,884.30 307,379.66 0.2835 -7,392.8854 -3,313,183,079.50 3,313,493,963.80 10,979,242,248,126,500,000.00

beta 0.3
2008.30 314,741.70 312,328.97 0.4823 -1,674.4419 -960,769,803.53 961,084,545.23 923,683,503,077,143,000.00

gamma 0.4
2008.40 350,734.60 312,313.00 0.6228 38,435.1984 12,005,952,058.94 -12,005,601,324.34 144,134,463,158,919,000,000.00




2009.10 313,058.10 320,427.28 0.7322 -14,069.8711 -5,137,274,283.19 5,137,587,341.29 26,394,803,689,403,000,000.00




2009.20 325,485.60 326,303.40 0.8099 -5,670.0101 -2,368,887,570.92 2,369,213,056.52 5,613,170,507,199,030,000.00




2009.30 332,478.90 330,008.22 0.8645 -588.2928 -546,377,447.52 546,709,926.42 298,891,743,648,220,000.00




2009.40 373,482.50 332,386.63 0.9033 39,132.3776 12,683,964,815.54 -12,683,591,333.04 160,873,489,103,524,000,000.00




2010.10 323,206.60 334,694.63 0.9314 -13,393.3477 -4,676,649,708.46 4,676,972,915.06 21,874,075,648,190,600,000.00




2010.20 344,700.00 342,092.35 0.9560 -3,501.0059 -1,897,727,186.01 1,898,071,886.01 3,602,676,884,478,110,000.00




2010.30 350,607.20 346,388.64 0.9714 671.2528 -201,251,013.55 201,601,620.75 40,643,213,489,185,600.00




2010.40 398,071.50 352,311.74 0.9838 40,868.9584 13,555,048,913.58 -13,554,650,842.08 183,728,559,450,651,000,000.00




2011.10 348,537.60 356,851.57 0.9917 -12,062.3936 -4,718,646,760.82 4,718,995,298.42 22,268,916,626,503,500,000.00




2011.20 368,884.70 364,182.67 0.9995 -1,351.5558 -1,249,342,912.06 1,249,711,796.76 1,561,779,574,973,570,000.00




2011.30 375,355.60 369,138.95 1.0033 2,124.3190 244,459,310.22 -244,083,954.62 59,576,976,902,504,700.00




2011.40 430,467.40 378,794.33 1.0095 43,699.9695 15,086,365,339.33 -15,085,934,871.93 227,585,430,960,233,000,000.00




2012.10 370,117.70 380,392.61 1.0081 -11,594.0176 -4,569,178,519.56 4,569,548,637.26 20,880,774,748,305,400,000.00




2012.20 389,122.40 385,150.54 1.0093 43.3442 -514,123,193.45 514,512,315.85 264,722,923,158,228,000.00




2012.30 393,792.40 388,226.71 1.0089 3,026.0657 818,184,767.64 -817,790,975.24 668,782,079,188,035,000.00




2012.40 442,231.40 393,090.05 1.0099 45,125.7801 16,965,539,346.84 -16,965,097,115.44 287,814,520,136,381,000,000.00









-4,557,504,648.97 MSE 62,198,233,509,797,300,000.00




Metoda mieszana


RMS 7,886,585,668.70





Wyszukiwarka

Podobne podstrony:
034 200 kantat J S Bacha Kantata BWV 20 O Ewigkeit, du Donnerwort BWV 20 (02 06 2013)
wykład 01 - 20[1][1].02.06, Medycyna, Genetyka, Wykłady - genetyka
06 03 2013 2
06 03 2013 1
wykład 1 (06 03 2013) elektroterapia wprowadzenie
wykład 14 (06 03 2013) nadciśnienie
z 1Cc ćwiczenie 27 02 i 06 03 2015 USTALENIE LICZBY EKSPERYMENTÓW
Materia éy z zaj¦Ö¦ç dotycz¦ůce przedmiotu analiza w Ťrodowisku pracy 20 02 2016 r , 06 03 2016
19.20.02.2011r.i 20.03 i 16.04- prawo finansowe, Administracja WSEI Lublin, Makarzec
06 OZE 2013 12 20 en
Teoria podatku TEORIA PODATKU, WYKŁAD 4 (02.06.2013)
MPLP 368;369 08.03.;20.03.2013
Mechanika Gruntów (Geotechnika) wykład 1 02 03 2013
20 03 2013 Kontrola i ocena
ZJAZD NR 2 01 02 03 2013(1)
Przewodnik adresow internetowych UE 20.02.2013 Sz.D.
MPLP68;369 03 ;20 03 2013 b

więcej podobnych podstron