˳ , , XY- .
,
.
.
.
.
, .
, . , .
, X . , X .
˳ . .
. , , :
,
.
, ˳ , ,
, , , . , ᒺ, , , . , , , ᒺ, .
, , . ' , .
˳ , , , , , , . . ' , , , .
. , , .
|
|
Excel ( ), (. 18.11): 1) ˳ (Linear) , . г =+, , b . ˳ , .
2) (Logarithmic) , , , . =* lnx+, b , In .
3) (Polynomial) , . . ̳ ( ) . . . . y=a+ciXi+C2X2++Cigx18, , CjCjg . ̳ (.). 18.
4) (Power) , , , . . , . = * n, n .
5) (Exponential) , . , , . = ebx, b .
6) ˳ (Moving average) . ( (Period). , . , 2, , . = (Aj+Aj_i++Aj_n+i) /n.
䳿:
, ;
(Add Trendline) ij (Chart). () (. 18.11);
|
|
. 18.11
. 18.12 ij
(Polynomial) ̳ (Order) ;
(Moving Average) (Period) , .
, (Based On Series). ' , . (Moving Average) , X . , X .
R . R 0 1. , . R2 Excel . .
R- , (Selected Trendline) (Format). (Options) (R*2) (Display R-squared value on chart) (. 18.13). ³, R- .
Excell X
Excel?
Excel . - , .
Excel?
, , . , . : , , , .
Excel?
:
, ;
;
(, , , , , );
( , , " - " );
, ( " ").
, Excel , .
Excel: , , () .
Excel
Excel Excel. Excel , 1.
Excel :
;
;
;
;
.
Excel . MS Excel, (). .
|
|
Excel , . , . : X, V, fx, - , .
Excel . (, , , ). , . ( ) Ins, Caps Lock, Num Lock, Scroll Lock.
. ( Excel) , . , , , . ( ) .
. . .
: , , , , , , , , , .
, . . 1 , . Z, AZ, BZ ..
, , Excel 256 16 .
, . (, 6 D8).
, , .
() () , , 10. .
- , . . - .
- , .
, , . , .
, . , , .
|
|
: , .
:
, F 9, F9;
, 1 - B1:E1;
, C - C1:C21;
, - A3:G10
Excel
.
Excel " ". : , , , . , . xls.
Excel
Excel, / . Excel " " .
Excel
Excel / , . Excel / .