, - .
-, - , , , , , , , .
, , , f (x)=a*e bt, , b , .
, ( ) (, ).
Excel , , . () :
;
;
;
;
;
;
( );
;
.
, , , . . , , , , . . . . , , fx:
, - ;
<>;
fx, , . ;
, , , ;
, ;
|
|
<F4>.
Y1=osx Y2 =Sin2x. Y= Y1+Y2; [0; 2p] p/100,31 Y, Y1 Y2 .
Excel 2 ( 2).
:
1. (. 1).
2. , , p/10 2p.
:
= = p/10 ( ). = fx , , .
1 2 , , . , .. . ( ) , =()/10. <Enter>. 0,3141592.
3. , 5 [0; 2p] =[0; 6,28].
:
5 0, 6 . = ( - 5) + (, p/10).
5:25 .
. 1. Excel
5:D25 , , , , 2, .
4. 5 (OS(5);2).
:
fx. , , . . (OS(5);2) , COS(A5) 1- , 2- . 2 . 2 . COS(A5) () ( ). COS. COS. 5, . 5 .
5. 5 6:25.
:
5 ( ) , 25. .
6. 5 =OKP (SIN(2*A5);2) 6:25.
:
4 5.
7. D5 =(5+5;2) D6:D25.
|
|
:
D5 =(5+5;2). <Enter>. 5.
c. 4. , .. . (, ).
Excel , . Excel , Excel 97 . Excel . , ().
Excel, .
= f () . 2 : , a Y .
. 1. . 4.
:
. [ 1 4]: . . ( . 4), <>. [2 4]: .
. , A5:D25. - =2!$$5:$D$25. . . , =2!$$5:$$25, <>. [ 3 4]: .
.
: , X, Y.
, <>. [4 4]: . .
.
2. , .
:
. . , . . , : , , , (, , ..). .
, , . , .
3. .
1. .
1.
Y1 | Y2; | Y | |||
Y= l x | Y=sinx | Y= l x*sinx | [0;2p] | p/15 | |
Y= x2 | Y= 4x | Y= x2+4x | [-5;+5] | ||
Y= x2 | Y= sinx | Y= x2 +sinx | [-p;+p] | p/8 | |
Y= lnx | Y= log10x | Y= lnx+log10x | [l;15] | ||
Y=2x | Y=(1/2)x | Y=2x*(1/2)x | [- 4;+4] | ||
Y= | Y= | Y= + | [0,4;2] | 0,2 | |
Y= | Y= | Y= | [4;36] | ||
Y= x2 | Y= x3 | Y= x2+x3 | [-6;6] | ||
Y=x2 | Y=sinx | Y= x2 *sinx | [-p;+p] | p/12 | |
Y= 2x | Y=x1/3 | Y= 2x-x1/3 | [0;3] | 0.3 | |
Y=x2 | Y=lnx | Y= x2*lnx | [1;5] | 0.5 | |
Y= sin3x | Y= x | Y= sin3x+x | [-p;+2p] | p/4 | |
Y= cos2x | Y= x2 | Y= cos2x+x2 | [-2p;+p] | p/6 | |
Y= lnx | Y= x2 | Y= lnx+ x2 | [1;5] | 0,1 | |
Y= ln5x | Y= 2x | Y= 2x*Ln5x | [1;7] | 0,5 |
|
|