Microsoft Excel
2
1.
.
1. - .
2. .
.
- :
N = 13%
, 20000 . S = 400 .
Y
. 1. -
Microsoft Excel , .
.
, , ( ) ( ).
:
= (_;__;__).
__, _ , __ _ .
, , , , .
. , , .
.
MS Excel
1. 1 (. 3).
2. 3:4 , , (. 3).
3. 7:7, .
:
4. 8:12 ( )(. 3).
5. 8 , . , , Ok.
. 2.
6. , . 3.
7. Ok 8 , :
=(B8<=20000;(8-$B$4)*$B$3;B8*$B$3)
. 3.
8. 9:12 , 8, ( ) +, 12.
|
|
9. 3:4 () . 7:12.
2.
.
- g=f(x, y, z).
.
. 4. -