12
: MS Excel () () (), .
1
, MS Excel, : , . .
.
, :
, , . , , , , . , , . , .
[0; 5].
.
, 0,5 . .
.
:
1. 2 0 ( ) 0,5 5 ( 12).
2. :
2 =1/(1+A2) ( 1/(1+x)) 12;
2 ( ) =(3-2)/(A3-A2) 11;
D3 ( ) =(3-2)/(A3-A2) D12;
3 ( ) =(4-2)/(A4-A2) E11;
F2 ( ) =−1/(1+A2)^2 ( -1/(1+x)^2) F12.
.
3. , . .
1
1 :
= ( − ) / 50.
[10; 110] | ||
[1; 20] | ||
[0; 10] | ||
[0; 3] | ||
[4; 12] | ||
[0; 0,5] | ||
[0; p] | ||
[0; p] | ||
[1; 8] | ||
[2; 6] | ||
[1; 4] | ||
[0; 10] | ||
[0; 2] | ||
[1; 5] | ||
[10; 80] | ||
[1; 5] | ||
[0; 3] | ||
[0; 1] | ||
[2; 12] | ||
[1; 2] |
|
|
2
.
, , , . . ( ), ( ). .
. .
h, . . , , , . , , . , . .
, , .
, .
.
.
. , ,
.
1. , .
2. 4 0 . 5 =4+()/10, ( ()/10) 14.
3. 4 =SIN(A4) 14.
4. () .
4 =(5 -4)*5 ( ), D4 =(5-4)*4 ( ), 4 =(5-4)*(5+4)/2.
(.. 14, D14, 14 ).
, D . 15 =(C4:C13).
D15 =(D4:D13), 15 =(E4:E13). .
.
|
|
: |2−1,9835| = 0,0165.
: 0,0165 / 1,9835 = 0,0083.
. , . , , . , . () : , N () , I − , a = 2 − .