t | yt | St | T + E = = yt St | T | T + S | E = = yt (T + S) | E^2 |
846,88 | 133,07 | 979,95 | 925,60 | 792,53 | 54,35 | 2953,67 | |
1076,22 | 177,96 | 898,26 | 978,12 | 1156,08 | 79,86 | 6377,07 | |
1133,13 | 187,08 | 946,05 | 1027,48 | 1214,56 | 81,43 | 6630,68 | |
790,92 | 231,97 | 1022,89 | 1073,69 | 841,72 | 50,80 | 2580,59 | |
1014,24 | 133,07 | 1147,32 | 1116,75 | 983,68 | 30,56 | 934,02 | |
1416,31 | 177,96 | 1238,35 | 1156,65 | 1334,61 | 81,70 | 6674,08 | |
1543,72 | 187,08 | 1356,64 | 1193,41 | 1380,49 | 163,23 | 2 6644,08 | |
1065,47 | 231,97 | 1297,44 | 1227,01 | 995,04 | 70,43 | 4959,98 | |
1110,89 | 133,07 | 1243,97 | 1257,46 | 1124,39 | 13,50 | 182,36 | |
1438,42 | 177,96 | 1260,46 | 1284,76 | 1462,72 | 24,30 | 590,65 | |
1405,85 | 187,08 | 1218,76 | 1308,91 | 1495,99 | 90,14 | 8125,34 | |
1061,41 | 231,97 | 1293,38 | 1329,91 | 1097,94 | 36,53 | 1334,16 | |
1175,26 | 133,07 | 1308,33 | 1347,75 | 1214,68 | 39,42 | 1553,92 | |
1485,96 | 177,96 | 1307,99 | 1362,44 | 1540,40 | 54,44 | 2963,89 | |
1410,58 | 187,08 | 1223,5 | 1373,98 | 1561,06 | 150,48 | 2 2644,68 | |
1371,04 | 231,97 | 1603,01 | 1382,37 | 1150,40 | 220,64 | 4 8682,23 |
4. . ( + ) .
. , , .
, .
MS Excel . , t = 1, 2,..., n, ( + ). .
, MS Excel ͻ (. . 7.3). 20, ͻ. + , . , , . MS Excel 20:24, F2, CTRL + SHIFT + ENTER (. 7.3).
|
|
. 7.3.
. . ˻. ͻ.
. 7.4.
. 7.4.
7.5
0,6661 | |
0,6762 | |
0,464 | |
0,68 | |
0,6961 |
, b , , m1 , , m2 , . t . , :
. (7.2)
t = 1, , 16, (. 5 . 7.4). . 7.5.
. 7.5. (, )
5. , . . ( + S) . 7.5.
6. E = Y (T + S). .
:
, (7.3)
.
0,696. , 69,6 % 4 .
. , .
Ft Y = T + S + E : Ft = Tt + Si.
, .
, :
;
;
;
.
:
S1 = 133,07 (I );
S2 = 177,96 (II );
S3 = 187,08 (III );
S4 = 231,97 (IV ).
:
;
;
;
.
F = 1254,54 + 1567,65 + 1575,7 + 1152,43 = 5550,32.
7.3.
|
|
ʻ 10 . 7.5.
7.5