2. 1 , (X) (Y).
, 3:21 Excel. (. . 1).
y= b∙mx,
H5:I9 : =(C6:C21;B6:B21;1;1) (. .3).
( H5:I9, . 3):
H5, I5 m=1.0001 b=4553.49;
H7 R2 =0.8501;
H8 F=79.42.
, :
Y = 4553.49∙1.0001 x
.3
: R2=0.8501 0,75 1, 79,41 (4.6), , .
H20 , 4000 . ( 22) =I5*H5^B22.
H12 H14 :
=(C6:C21;B6:B21;B22:B24;1)
H15 R:
=(C6:C21;B6:B21).
c , .
7
MS Excel
, .
, .
, D, F(x), .
, , .
: () L x1, x2, xn
(1)
|
|
(2)
,
(3)
(5) (6) aij cj bi - .
(2) (3) .
, (5). ., () F(X) , G .
:
..
, .