. , . ( ). ( ) . . , . , .
( , ). , :
N ( - );
Vi , i = 1,..., N ( - );
S ( - );
P ( - );
C ( - );
Di , i = 1,..., N ( );
Zi , i = 1,..., N ( );
Ri ( );
VN , N - , ( );
DN , ( );
ZN , ( );
RN ( ).
, . , , :
VN = (V1: VN),
C = S / VN
Di = Vi / VN, i = 1,..., N
Zi = Vi * C, i = 1,..., N
Ri = Zi * (1 - P), i = 1,..., N
DN = (D1: DN),
ZN = (Z1: ZN),
RN = (R1: RN),
( ).
, , . , , . .
, . S P.
|
|
, 2, .
2
- | |||||
: | 32 000 . | : | 13% | ||
, . | |||||
23,3% | 7 467 . | 6 496 . | |||
12,7% | 4 053 . | 3 526 . | |||
17,3% | 5 547 . | 4 826 . | |||
13,3% | 4 267 . | 3 712 . | |||
33,3% | 10 667 . | 9 280 . | |||
100,0% | 32 000 . | 27 840 . | |||
1 : | 106,67 . |
(N=5). N ≥ 10.
.
. .
. . , - $ .
( S ). ( fx ), , .
, . , 3. Ctrl+~ (Ctrl+).
3 MS Excel
A | B | C | D | E | F | |
- | ||||||
: | : | 0,13 | ||||
, . | ||||||
=C4/$C$9 | =C4*$E$10 | =E4*(1-$F$2) | ||||
=C5/$C$9 | =C5*$E$10 | =E5*(1-$F$2) | ||||
=C6/$C$9 | =C6*$E$10 | =E6*(1-$F$2) | ||||
=C7/$C$9 | =C7*$E$10 | =E7*(1-$F$2) | ||||
=C8/$C$9 | =C8*$E$10 | =E8*(1-$F$2) | ||||
=(C4:C8) | =(D4:D8) | =(E4:E8) | =(F4:F8) | |||
1 : | =C2/C9 |
/ . .
|
|
: 1) B3:C8; 2) / ; 3) ( ), ( !); 4) , , , , , , . ( 1).
1 :
: 1) B3:B8, , Ctrl, F3:F8; 2) / ; 3) ( ), ; 4) ( ); 5) (, Delete). ( 2).
2 :
1. .. . .: , 2007. 765 .
2. .. . : .: , 2007. 640 .
3. .. IBM PC . .: -, 2002. 480 .: .
4. Microsoft Office Online [ ]. : http://office.microsoft.com/ru-ru/training.