. .
.2.
x | ||||||||||
( ) |
Ø .7. Y t 7:16 7:16 . 7:16, D7:D16, E7:E16 Yi , .
.7.
Ø :
7 =($B7-($B$3+$C$3*$A7+$D$3*$A7^2))^2 (12)
D7=($B7-($B$4+$C$4*$A7+$D$4*$A7^2+$E$4*$A7^3))^2 (13)
E7=($B7-($B$5+$C$5*$A7+$D$5*$A7^2+$E$5*$A7^3+$F$5*$A7^4))^2 (14)
Ø C 8:16, D8:D16, E8:E16 . .
Ø 17 2- , :
17 = (7:16) (15)
D17:17, 3- 4- . 17:17 .
Ø , b, c / . / 17, , B3:D3. , , b, B3:D3.
Ø , , , b, c, d 4:4 3- , 4- 5:F5 , b, c, d, e.
Ø , Excel, , 2- . Y(t), t Y 7:16, 7:16. . , ; , . R^2.
Ø 3-, 4- .
|
|
.8.
Excel. / , .
/ , (), () () b . , . . yt t () ().
, LN. . yt () , .
0,0212 (R2 > R2).
. . , b, c / . Excel 2-, 3-, 4- . 2-, 3-, 4- , , .