9
( )
:
: MS Excel . .
, , [1] , . , , ( ) .
. f :
9.1 | ||||
x | x1 | x2 | ... | xn |
f(x) | y1 | y2 | ... | yn |
y = f (x), . y = f (x, a0, a1,..., ak) , yi f (xi,a0, a1,..., ak) (. . 9.1).
. 9.1 |
: a0, a1, a2,...,ak, .
(9.1) |
:
(9.2) |
ai y = f (x,ao, a1, , ak) , :
(9.3) |
(9.3), ao, a1,..., ak y = f (x, ao, a1,..., ak).
( )
y = ax+b. S:
(9.4) |
(9.4) a b, , :
(9.5) |
y x, a b .
, . , x y. . :
r a :
Dy, Dx - x y.
-1 ≤ r ≤ 1. r , . , x, y . r = 0, , x, y , , .
, , . :
t , a n-2. t , .
|
|
MS Excel
():
(_y; _x; ; )
_y - y.
_x - x, , , {1;2;3;...} , _y.
- , , , b 0. , b . , b 0 a , y = ax.
- , , . , () . , () a b.
().
(_y; _x; __x; )
_y - y, y = ax + b.
_x - x.
__x - , y. __x , , .
- , , , b 0. , b . , b 0, , y = ax. , (), () - .
(), :
(1;2)
1 - y.
2 - y.
1 2 .
9.1. G(L) [2]. . . x1=0; x2=0,75; x3=1,75; x4=2,8; x5=4,5 . .
L | 0,5 | 1,5 | 2,5 | 3,5 | |||||
G | 2,39 | 2,81 | 3,25 | 3,75 | 4,11 | 4,45 | 4,85 | 5,25 |
MS Excel . , . 9.2.
. 9.2 |
, b E3:F3, (). , . 9.3 .
. 9.3 |
E3. F3 E3:F3, F2, CTRL+SHIFT+ENTER.
|
|
H3 : H3 = (A2:A10;B2:B10), . 9.4.
. 9.4 |
. 9.5, , , . |
x1=0; x2=0,75; x3=1,75; x4=2,8; x5=4,5 C2:C6. D2:D5 D2 Y=x*a+b, (. 9.5). .
. 9.5
. , . (. 9.5), (. 9.5) : , X: C2:C6, Y: D2:D6.
. 9.5
. 9.5
(. 9.5) , : (. . 9.6).
. 9.5
. 9.6 ( , , ..), (. 9.7). | |
. 9.7 |
, , . 9.8.
. 9.8 |
y = ao + a1x + a2x2.
:
(9.2):
(9.6) |
ao, a1, a2 (9.6).
y = ao + a1 x + a2 x2 + a3 x3.
S:
ao, a1, a2, a3 :
(9.7) |
ao, a1, a2, a3 .
k - y = ao+a1x+...+ak xk, ai :
(9.8) |
y = a xb
y = a xb y: Ln y = Ln a + b Ln x
Y = ln y; X = ln x. Y = A + b X. A b. a = eA. y = axb.
y = aebx
y = aebx: Ln y = Ln a + bx Ln e;
Y = Ln y, A = Ln a. Y = bx+A. A b. a = eA.
, y = f (x, a, b) Y = Ax+B.
Y = f (x,a,b) | |
y =axb ecx
y = axb ecx, :
Ln(y) = Ln(a)+b Ln(x)+cx Ln(e) | (9.9) |
Y=Ln(y), A=Ln(a). (9.9) :
Y = A+b Ln(x)+cx | (9.10) |
(9.10) S . (9.1):
(9.11) |
A, b c , S . S (2). (9.11) (9.2), A, b c.
|
|
(9.12) |
(9.12), A, b, c. a=eA.