25 . 25, , ( );
3:6, , 26 ;
27 :
( + * - )/( * ).
27 : =(B4+C13*D4 - B20)/(B20*D4);
27 28 29;
27:29, - - - . - 3. ;
42. .
D | E | F | G | ||||
, % | , | ||||||
, % | |||||||
, % | () | ||||||
, % | () | ||||||
40,188 | 48,225 | 57,870 | 69,444 | 83,333 | |||
85,047 | 87,056 | 89,468 | 92,361 | 95,833 | |||
100,000 | 100,000 | 100,000 | 100,000 | 100,000 |
, , ( 27:27);
, . :
29,7660% | ||
21,1537% | ||
19,1464% |
|
|
, , .
(2) . 43;
(. . 3.4);
(. . 3.5);
43.
, % | , | ||
(. . 3.6);
;
. .
.
: [6], c. 284-290.
11.
.
2.
.
- , , . . , , 19 23 2008 .
, , .
-, , , , , . .
Excel .
3.
. .
: Microsoft Excel (OpenOffice.org Calc). . . 44.
44.
A | B | C | D | E | F | G | |
19.03.08 | 26.03.08 | 02.04.08 | 09.04.08 | 16.04.08 | 23.04.08 | ||
24,25 | 25,65 | 26,33 | 25,87 | 25,33 | 24,85 |
3.2.
, .
3.2.1. 1
Excel . . : . .
OpenOffice.org Calc . ( ), .
|
|
3.2.2. 2
Excel . B4:G4. . . 2:G2. .
OpenOffice.org Calc , B4:G4. , ( ), .
3
Excel . . X . Y . .
OpenOffice.org Calc ( ) : , 4 , .
3.2.4. 4
Excel . . 1 19 23 .
OpenOffice.org Calc , , Y , .
3.3.
1:
. . , ;
. (v) . ;
, , , (. 1).
OpenOffice.org Calc:
. . .
. . .
3.4. ().
1 . ;
6 . B6:G6, , ;
. 1
B2:G2, , , . , 7 ;
8 (. 1) =0,0451*7 + 25,222. 8 25,222. !!!
1: A7:G8. , . 7. . B8:G8 ( 8 8:G8);
OpenOffice.org Calc: 7:G8. , . $A$8, $$7. . B8:G8 ( 8 8:G8).
|
|
B7:G8, . .
, 30.04.08 (. 45).
45.
A | B | C | D | E | F | G | |
19.03.05 | 26.03.05 | 02.04.05 | 09.04.05 | 16.04.05 | 23.04.05 | ||
24,25 | 25,65 | 26,33 | 25,87 | 25,33 | 24,85 | ||
25,222 | 25,2671 | 25,3122 | 25,3573 | 25,4024 | 25,4475 | 25,4926 |
3.5.1. (. 46).
3.5.2. .
46.
10.03.08 | 17.03.08 | 24.03.08 | 31.03.08 | 07.04.08 | 14.04.08 | |
12,83 | 12,95 | 13,29 | 13,26 | 13,77 | 13,78 |
3.5.3. 21.04.08 ( ).
3.5.4. . , .