.


:




:

































 

 

 

 





1

: 5 .

 

: MS Excel:

1) : , , ;

2) , : , () ;

3) .

:

1. MS Excel 1.

 

1 , MS Excel

         
, .          
, . . 1075,1 1073,8 1059,1 1036,9 1096,7
, . 153592,5 183462,6 386283,6   651513,8

 

2. . 2.

2

         
, .          
         
, ,          
         
,          
         
- .          
,          
         
         
         
         
         
,          
         
,          
         

 

3. , :

 

 

: i i - ; .

.

3

:
0,84% 1,47% 1,40% 1,61% 1,46%
, , 20,10% 17,65% 18,46% 22,42% 23,71%
3,41% 3,06% 2,91% 3,24% 3,02%
, 0,79% 0,82% 0,73% 0,81% 0,80%
1,48% 1,32% 1,29% 1,73% 1,97%
- . 1,86% 1,62% 1,45% 1,58% 1,50%
, 17,54% 21,16% 20,55% 15,82% 16,26%
8,98% 11,48% 11,84% 7,68% 9,87%
3,54% 3,61% 3,67% 4,04% 3,47%
5,23% 4,23% 4,42% 5,52% 5,55%
6,95% 6,85% 6,61% 6,75% 6,41%
9,14% 7,88% 9,35% 9,71% 7,56%
, 3,83% 3,53% 3,52% 3,91% 3,51%
4,46% 5,46% 4,46% 4,47% 3,54%
, 9,59% 7,57% 7,08% 8,11% 8,75%
2,27% 2,29% 2,26% 2,60% 2,62%

 

4. . :

   

: i i i - ; .

4

         
, . .          
15,7 16,1 15,9 16,2 20,7
, , 151,8 151,7 150,9 150,5 165,7
104,2 102,5 100,3 94,9 96,1
, 104,2 102,5 100,3 94,9 96,1
48,6 47,9 46,5 44,5 35,5
- . 32,4 32,2 31,2   28,4
,     10,6 10,9 17,6
63,2 63,5 61,6 60,7 61,2
41,4 42,9 42,9 42,8 42,5
  70,7 66,8 65,5  
72,1 76,8 77,8   66,9
145,5 143,6 149,9 145,3 145,4
, 72,7 72,1 69,2   69,8
  66,1 58,1 56,7 59,7
, 116,8 113,9 112,8 112,8 157,3
46,6 46,5 47,5 47,9 52,9
:
1,46% 1,50% 1,50% 1,56% 1,89%
, , 14,12% 14,13% 14,25% 14,51% 15,11%
9,69% 9,55% 9,47% 9,15% 8,76%
, 9,69% 9,55% 9,47% 9,15% 8,76%
4,52% 4,46% 4,39% 4,29% 3,24%
- . 3,01% 3,00% 2,95% 2,89% 2,59%
, 0,93% 0,93% 1,00% 1,05% 1,60%
5,88% 5,91% 5,82% 5,85% 5,58%
3,85% 4,00% 4,05% 4,13% 3,88%
6,70% 6,58% 6,31% 6,32% 5,38%
6,71% 7,15% 7,35% 7,43% 6,10%
13,53% 13,37% 14,15% 14,01% 13,26%
, 6,76% 6,71% 6,53% 6,37% 6,36%
6,05% 6,16% 5,49% 5,47% 5,44%
, 10,86% 10,61% 10,65% 10,88% 14,34%
4,33% 4,33% 4,48% 4,62% 4,82%

 

5

         
, .          
        36402,6
, , 15437,8 12239,9   59982,6 77126,1
6267,6 7256,3 10971,9 14728,7  
, 685,5 778,1 1301,4 2200,3 2587,1
2316,3 2629,7 5710,7 8898,4 9396,7
- . 1962,2   4541,5 8335,8 9339,4
, 9253,7 11232,4 24939,7 36258,4 42758,4
18552,9 21775,3 45434,4 64034,3 77590,2
3355,4 3544,6 7817,3 9194,3 11533,7
7557,8   20551,7 33019,6 40307,6
  8280,6   23699,9 29417,2
13594,3 14987,9 28127,1   48728,9
, 5852,6 6677,1 11955,7 15509,5 18090,2
7572,3 8626,1 16336,2 18380,2 22668,3
, 44491,7 54648,4 121246,3   196169,1
1946,4 2491,7 5777,2 8288,9 12032,2
2010-2014 .
5,12% 5,13% 5,13% 5,39% 5,59%
, , 10,05% 6,67% 11,25% 11,20% 11,84%
4,08% 3,96% 2,84% 2,75% 2,67%
, 0,45% 0,42% 0,34% 0,41% 0,40%
1,51% 1,43% 1,48% 1,66% 1,44%
- . 1,28% 1,24% 1,18% 1,56% 1,43%
, 6,02% 6,12% 6,46% 6,77% 6,56%
12,08% 11,87% 11,76% 11,96% 11,91%
2,18% 1,93% 2,02% 1,72% 1,77%
4,92% 5,23% 5,32% 6,17% 6,19%
4,48% 4,51% 4,74% 4,43% 4,52%
8,85% 8,17% 7,28% 7,88% 7,48%
, 3,81% 3,64% 3,10% 2,90% 2,78%
4,93% 4,70% 4,23% 3,43% 3,48%
, 28,97% 29,79% 31,39% 30,60% 30,11%
1,27% 1,36% 1,50% 1,55% 1,85%

 

5. .

 

 

1 , 2010 .

 

2 , 2014 .

, 2010 2014 .


3 , 2010 .

4 ,
2014 .

, 2010 2014.

5 , 2010 .

 


6 , 2014 .

6. . , :

 
: i - ; .
,  
: i - ; i - , .
         

.

6 -

         
, .          
  208,24% 177,15% 98,34% 111,26%
, .          
  365,33% 169,49% 112,85% 101,13%
  175,44% 95,68% 114,76% 90,89%
, ,
, .          
  182,80% 185,36% 119,40% 117,67%
  87,79% 104,63% 121,42% 105,76%
, .          
  187,05% 168,51% 109,28% 103,89%
  89,82% 95,12% 111,13% 93,38%
,
, .          
  218,76% 157,01% 109,04% 109,25%
  105,06% 88,63% 110,88% 98,19%
, .          
  185,07% 172,52% 132,09% 126,73%
  88,88% 97,39% 134,32% 113,90%
- .
, .          
  182,31% 157,95% 107,24% 105,86%
  87,55% 89,16% 109,05% 95,14%
,
, .          
  251,13% 172,05% 75,71% 114,36%
  120,60% 97,12% 76,99% 102,78%
, .          
  266,10% 182,64% 63,83% 142,97%
  127,79% 103,10% 64,91% 128,50%
, .          
  212,23% 180,33% 108,15% 95,52%
  101,92% 101,79% 109,98% 85,85%
, .          
  168,47% 185,08% 122,83% 112,00%
  80,90% 104,48% 124,90% 100,67%
, .          
  205,50% 170,92% 100,34% 105,64%
  98,69% 96,49% 102,04% 94,95%
, .          
  179,62% 210,18% 102,12% 86,65%
  86,26% 118,65% 103,84% 77,88%
,
, .          
  192,07% 176,32% 109,39% 99,70%
  92,24% 99,53% 111,24% 89,61%
, .          
  254,62% 144,67% 98,68% 88,09%
  122,27% 81,66% 100,34% 79,17%
,
, .          
  164,46% 165,74% 112,63% 119,95%
  78,98% 93,56% 114,54% 107,81%
, .          
  209,41% 175,10% 113,30% 112,10%
  100,56% 98,85% 115,21% 100,75%

 

7.

1 , 2011 .


2 , 2014 .

8) , . :

     
     

7 -

         
0,84% 1,47% 1,40% 1,61% 1,46%
  0,63% -0,06% 0,21% -0,15%
  175,44% 95,68% 114,76% 90,89%
, ,
, . 20,10% 17,65% 18,46% 22,42% 23,71%
  -2,46% 0,82% 3,95% 1,29%
  87,79% 104,63% 121,42% 105,76%
, . 3,41% 3,06% 2,91% 3,24% 3,02%
  -0,35% -0,15% 0,32% -0,21%
  89,82% 95,12% 111,13% 93,37%
,
, . 0,79% 0,82% 0,73% 0,81% 0,80%
  0,04% -0,09% 0,08% -0,01%
  105,06% 88,63% 110,88% 98,18%
, . 1,48% 1,32% 1,29% 1,73% 1,97%
  -0,17% -0,03% 0,44% 0,24%
  88,88% 97,39% 134,32% 113,90%
- .
, . 1,86% 1,62% 1,45% 1,58% 1,50%
  -0,23% -0,18% 0,13% -0,08%
  87,55% 89,16% 109,05% 95,14%
,
, . 17,54% 21,16% 20,55% 15,82% 16,26%
  3,61% -0,61% -4,73% 0,44%
  120,60% 97,12% 76,99% 102,78%
, . 8,98% 11,48% 11,84% 7,68% 9,87%
  2,50% 0,36% -4,15% 2,19%
  127,79% 103,10% 64,91% 128,50%
, . 3,54% 3,61% 3,67% 4,04% 3,47%
  0,07% 0,06% 0,37% -0,57%
  101,92% 101,79% 109,98% 85,85%
, . 5,23% 4,23% 4,42% 5,52% 5,55%
  -1,00% 0,19% 1,10% 0,04%
  80,90% 104,48% 124,90% 100,67%
, . 6,95% 6,85% 6,61% 6,75% 6,41%
  -0,09% -0,24% 0,13% -0,34%
  98,69% 96,49% 102,04% 94,95%
, . 9,14% 7,88% 9,35% 9,71% 7,56%
  -1,26% 1,47% 0,36% -2,15%
  86,26% 118,65% 103,84% 77,88%
,
, . 3,83% 3,53% 3,52% 3,91% 3,51%
  -0,30% -0,02% 0,40% -0,41%
  92,24% 99,53% 111,24% 89,61%
, . 4,46% 5,46% 4,46% 4,47% 3,54%
  0,99% -1,00% 0,02% -0,93%
  122,27% 81,66% 100,34% 79,17%
,
, . 9,59% 7,57% 7,08% 8,11% 8,75%
  -2,02% -0,49% 1,03% 0,63%
  78,98% 93,56% 114,54% 107,81%
, . 2,27% 2,29% 2,26% 2,60% 2,62%
  0,01% -0,03% 0,34% 0,02%
  100,56% 98,85% 115,21% 100,75%

8 2010 - 2014 .

         
1,46% 1,50% 1,50% 1,56% 1,89%
  0,04% 0,00% 0,06% 0,33%
  102,67% 100,13% 104,07% 120,81%
, ,
, . 14,12% 14,13% 14,25% 14,51% 15,11%
  0,01% 0,12% 0,27% 0,59%
  100,06% 100,85% 101,87% 104,10%
, . 9,69% 9,55% 9,47% 9,15% 8,76%
  -0,15% -0,08% -0,32% -0,39%
  98,49% 99,21% 96,64% 95,74%
,
, . 9,69% 9,55% 9,47% 9,15% 8,76%
  -0,15% -0,08% -0,32% -0,39%
  98,49% 99,21% 96,64% 95,74%
, . 4,52% 4,46% 4,39% 4,29% 3,24%
  -0,06% -0,07% -0,10% -1,05%
  98,68% 98,42% 97,75% 75,43%
- .
, . 3,01% 3,00% 2,95% 2,89% 2,59%
  -0,01% -0,05% -0,05% -0,30%
  99,50% 98,24% 98,21% 89,51%
,
, . 0,93% 0,93% 1,00% 1,05% 1,60%
  0,00% 0,07% 0,05% 0,55%
  100,12% 107,47% 105,03% 152,66%
, . 5,88% 5,91% 5,82% 5,85% 5,58%
  0,04% -0,10% 0,04% -0,27%
  100,60% 98,35% 100,65% 95,33%
, . 3,85% 4,00% 4,05% 4,13% 3,88%
  0,14% 0,06% 0,08% -0,25%
  103,75% 101,39% 101,90% 93,89%
, . 6,70% 6,58% 6,31% 6,32% 5,38%
  -0,11% -0,28% 0,01% -0,94%
  98,31% 95,80% 100,15% 85,17%
, . 6,71% 7,15% 7,35% 7,43% 6,10%
  0,45% 0,19% 0,08% -1,33%
  106,65% 102,71% 101,09% 82,15%
, . 13,53% 13,37% 14,15% 14,01% 13,26%
  -0,16% 0,78% -0,14% -0,75%
  98,81% 105,84% 99,01% 94,61%
,
, . 6,76% 6,71% 6,53% 6,37% 6,36%
  -0,05% -0,18% -0,17% 0,00%
  99,29% 97,31% 97,42% 99,99%
, . 6,05% 6,16% 5,49% 5,47% 5,44%
  0,11% -0,67% -0,02% -0,02%
  101,82% 89,12% 99,68% 99,55%
,
, . 10,86% 10,61% 10,65% 10,88% 14,34%
  -0,26% 0,04% 0,23% 3,46%
  97,64% 100,41% 102,14% 131,85%
, . 4,33% 4,33% 4,48% 4,62% 4,82%
  0,00% 0,15% 0,13% 0,20%
  99,91% 103,57% 103,00% 104,42%

10 2010 - 2014 .

         
5,12% 5,13% 5,13% 5,39% 5,59%
  0,01% 0,00% 0,26% 0,20%
  100,26% 100,06% 104,98% 103,68%
, ,
, . 10,05% 6,67% 11,25% 11,20% 11,84%
  -3,38% 4,58% -0,05% 0,64%
  66,38% 168,60% 99,58% 105,68%
, . 4,08% 3,96% 2,84% 2,75% 2,67%
  -0,13% -1,11% -0,09% -0,09%
  96,93% 71,81% 96,84% 96,91%
,
, . 0,45% 0,42% 0,34% 0,41% 0,40%
  -0,02% -0,09% 0,07% -0,01%
  95,03% 79,44% 121,97% 96,64%
, . 1,51% 1,43% 1,48% 1,66% 1,44%
  -0,07% 0,04% 0,18% -0,22%
  95,05% 103,14% 112,41% 86,79%
- .
, . 1,28% 1,24% 1,18% 1,56% 1,43%
  -0,03% -0,07% 0,38% -0,12%
  97,41% 94,48% 132,41% 92,09%
,
, . 6,02% 6,12% 6,46% 6,77% 6,56%
  0,10% 0,33% 0,31% -0,21%
  101,62% 105,45% 104,88% 96,92%
, . 12,08% 11,87% 11,76% 11,96% 11,91%
  -0,21% -0,11% 0,20% -0,05%
  98,26% 99,10% 101,67% 99,59%
, . 2,18% 1,93% 2,02% 1,72% 1,77%
  -0,25% 0,09% -0,31% 0,05%
  88,44% 104,74% 84,85% 103,10%
, . 4,92% 5,23% 5,32% 6,17% 6,19%
  0,31% 0,09% 0,85% 0,02%
  106,33% 101,69% 115,90% 100,33%




:


: 2015-11-23; !; : 1436 |


:

:

, , .
==> ...

1990 - | 1625 -


© 2015-2024 lektsii.org - -

: 0.031 .