, .
, 2. .
. , . , 40):
1. . ( ), , ( 2, ).
2. X. X ( ), ( ) , ( 2, )
3. Y. Y( ), ( ) , Y ( D2, )
4. 
. ( ), ( ) , ( 2, ).
. 40.
, .
41. .
.41 
. ,
. - . 42.
. 42.
, 42, , .
3 :
1. :
;
;
.
2. :
) , , . .
|
|
|
) , , :
;
;
;
.
) . .
0
,
| , % | , . . | |
| 20,3 | 9,55 | |
| B | 17,1 | 13,58 |
| C | 14,2 | 22,33 |
| D | 11,0 | 27,50 |
1
| , . . | ||
| 2,0 | ||
| 1,4 | ||
| 1,7 | ||
| 1,5 | ||
| 1,0 | ||
| 1,8 |
2
| , . . | , . .-. | |
| 1 | 65,0 | 66,0 |
| 2 | 78,0 | 44,0 |
| 3 | 41,0 | 91,0 |
| 4 | 54,0 | 78,0 |
| 5 | 66,0 | 57,4 |
| 6 | 80,0 | 42,0 |
3
| , . | ||
4
| , . | ||
5
| , . . | , . . | |
| 1 | 65,0 | 54,6 |
| 2 | 78,0 | 73,6 |
| 3 | 41,0 | 42,0 |
| 4 | 54,0 | 46,0 |
| 5 | 66,0 | 62,0 |
6
| , . | , . | |
| 1 | ||
| 2 | ||
| 3 | ||
| 4 |
7
| 4,6 | ||
| 5,0 | ||
| - | 4,2 |
8
-
| , | , . | |
| 1 | 1,0 | |
| 2 | 1,0 | |
| 3 | 3,0 | |
| 4 | 6,5 | |
| 5 | 9,2 |
9
(. .)
|
|
|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 |
A
B
| , . . | ||
C
| , . | , . | |
| -- | ||
D
| , . | ||
| 19,5 | ||
| 21,3 | ||
| 25,4 | ||
| - | 15,2 |
E
F
| , . . | ||
1. .
2. .
3. .
4. .
1. , .. MS Excel VBA [] / .. . .: , 1999. 336 .
2. , .. : - []: . . / .. . .: , 2002. 304 .
3. , .. Excel [] / .. . .: , 2004. 400 .
4. , . Microsoft Excel [] / . ; . . 6- . .: , 2004. 1024 .
5. , .. - Excel [] / .. . 3- ., . . .: , 1999. 328 .
, 1 03.09.05. , 3 01.12.05.
..
: .. , .. , ..
..
..
06457 19.12.01 . 06.02.06.
6084/16. . . .. 2,81. .-. . 2,23.
100 . 24
65-175 05.11.99 .
. .
346500, . , ., . , 147
