EL
1
: 4109 ..
: ..
. 2013
:
. . Microsoft Excel.
.
EXCEL , . .
. . , .
. , , .
, . . .
/ . (), () ().
Delete .
. . . , : =(4+4)/2.
, , . , 4 =2+3, 4 2 3.
, /. . , (4:10) 4:10, .. 4+5+6+7+8+9+10.
. . , ( ). . , .
|
|
, , :
=(7>100; 7+7; 7+7+7).
7>100. (7+7), .
. , . . , . , . . .
, . , / / . , , . , ( ).
. . , .
.
, Microsoft Excel.
1. [a, b] c 0.1.
2. [a, b].
3. [a, b] c 0.1
4. [a, b] c 0.1:
.
1.
f(x)= ax+ b´sin(x) +exp(a/(x+b(lgx))). (1)
[6;8].
.
1) , [6, 8] c 0.1, x 6 8 (. .1).
.1.
(1) y(x) =(6* A2 +8* SIN (A2)+ EXP (6/(A2 +8* LN (A2)))) A2 x, a b 6 8 (. . 2).
.2.
, [6, 8] c 0.1.
3.
.3.
2) .
, = (2:22) Enter (. . 4).
, IN = (2:22) Enter (. . 4).
.4.
, [6.1, 8.1] c 0.1, +dx 6.1 8.1 (. .5).
|
|
.5.
(1) (+dx) =(6* B2 +8* SIN (B2)+ EXP (6/(B2 +8* LN (B2)))) +dx, a b 6 8 (. . 6).
.6.
, [6.1, 8.1] c 0.1.
(x+dx) y (x) 0,1. : =(D2-C2)/0,1. (. . 7).
.7.
8.
.8.
.10.
.10.
3) [6, 8] c 0.1:
.
[6, 8] c 0.1 . y (x) 0,1. dx. .
(. . 9).
.9.
: , . Microsoft Excel.