1
(4 )
MS Excel. / , , .
. (.. , ), x t .
.1.
.1.
y ( ) | 2,01 | 2,12 | 2,77 | 3,62 | 3,80 | - | - | - |
yt=at+b, yt=b*exp(at). a b , y yt, .. , U=Σ(yi ati b) 2 →min i =1, 2, 3,, n.
Ø .1.
. 1.
2:9 t, 2:9 .1. a b D2, 2 . F2 :
=(B2:B9;E2+D2*A2:A9) (1)
(), .
Ø / . .
Ø .
F2, , , D2:2.
Ø , Excel (.2.).
Ø
Microsoft Excel 12.0 | ||||
: _1.xlsx]1 | ||||
: 01.02.2017 14:50:32 | ||||
() | ||||
$F$2 | : | 2,869047619 | ||
$D$2 | a: | 6,011904191 | ||
$E$2 | b: | 7,071428467 | ||
|
|
. 2.
Ø b () (). () . (< >;< t >), () . (< >;< t >).
:
< t > . < t > , , , < >;
< > - .
:
=(B2:B9;A2:A9) (2)
=(B2:B9;A2:A9) (3)
D4 4 D2 2.
Ø b , . :
- 2:9, , . , ;
- , . . ( .3.)
.3.
.4.
Ø yt t 2. 2 :
=D2*A2+E2 (4)
2.
Ø yt t 4 (). - (ti;< y >;< t >). ti - t, yti. 4 :
=(A4;B2:B9;A2:A9) (5)
(5) 5:9 yt.
4:12 4:12.
Ø (). (< y >;< t >;< t >;[<>]).
< t > - t, () yt.
10 :
=(B2:B6;A2:A6;A7) (6)
(6) 8:9 .
Ø b (). , b. (< >;< t >;[<>];[<>]), <> - .
|
|
D6:6 : =(B2:B9;A2:A9) (7)
, D2:2, D4:4, D6:6 , .
Ø . yt=b*exp(a*t).
b, m yt=b*m^t (< >;< t >;[<>];[<>]), <> - , , , .
ü D8:8 :
=(B2:B9;A2:A9) (8)
9 : LN(D8) (9)
ü . G2 :
=(B2:B9;A2:A9;A2) (10)
G3:G12.
ü yt () , .
F4 :
=E8*EXP(E9*A4) (11)
(11) F5:F12 . B4:B12, 4:12, F4:F12, G4:G12.
ü 2:9, , , ( ). .5.
.5.
ü . 0,0212 (R2 > R2).
.6.