1. Excel . N = 5. : 0 1 2 3 4 5 2:G2, : 1 0% 20% 30% 40% 50% 3:G3.
A | B | C | D | F | G | ||
0% | 10% | 20% | 30% | 40% | 50% |
. 4:G4 , 5 , 6 . , 7 , 8 . , 9 . 2:G2 7:G7, 3:G3 8:G8.
(3.2). 9 : = 5, 9 :
=B9+($B$5+$$6*(7-1))*B8+$$6. D9:G9.
.
A | B | C | D | F | G | ||
. | |||||||
0% | 10% | 20% | 30% | 40% | 50% | ||
<> | <> | " | " | " | " |
2. . 5 P0 = 1000, 6 ( A = 40).
.
A | B | C | D | F | G | ||
. | |||||||
. | 0% | 10% | 20% | 30% | 40% | 50% | |
1. Excel . , 0 1 2 3 4 5 0% 10% 20% 30% 40% 50%. 8:13 ( . . 3.1.7 " "). 40 : 9:13, 40, Ctrl + Enter. 8 : =5, 8 : =$B8*(1+($$7:$7)--($$8:$8)). (. 1, ), .
A | B | C | D | F | G | H | ||
0% | 10% | 20% | 30% | 40% | 50% | |||
0% | " | " | " | " | " | |||
10% | " | " | " | " | " | |||
20% | " | " | " | " | ||||
30% | " | " | " | |||||
40% | " | " | ||||||
50% | " | |||||||
. |
|
|
2. . 5 P0 = 1000.
A | B | C | D | F | G | H | ||
0% | 10% | 20% | 30% | 40% | 50% | |||
0% | ||||||||
10% | ||||||||
20% | ||||||||
30% | ||||||||
40% | ||||||||
50% | ||||||||
. |
3. , , N : 1) P0, N A1,..., AN, 2) pi% i- .
:
1. .
2. .
. . (c. 2 ):
Excel , :
(3.3)