Таблица 3
Расчет коэффициента автокорреляции третьего порядка Yt
| Y_(t-3)
| Yt-Yср
| Y(t-3)-Y(t-3)ср
| (Yt-Yср)*(Y(t-3)-Y(t-3)ср)
| (Yt-Yср)^2
| (Y(t-3)-Y(t-3)ср)^2
| 375,000
|
|
|
|
|
|
| 594,000
|
|
|
|
|
|
| 854,000
|
|
|
|
|
|
| 1110,000
| 375,000
| 406,846
| -298,692
| -121521,817
| 165523,793
| 89217,095
| 342,000
| 594,000
| -361,154
| -79,692
| 28781,183
| 130432,101
| 6350,864
| 296,000
| 854,000
| -407,154
| 180,308
| -73412,970
| 165774,254
| 32510,864
| 977,000
| 1110,000
| 273,846
| 436,308
| 119481,183
| 74991,716
| 190364,402
| 1111,000
| 342,000
| 407,846
| -331,692
| -135279,432
| 166338,485
| 110019,787
| 375,000
| 296,000
| -328,154
| -377,692
| 123941,183
| 107684,947
| 142651,479
| 406,000
| 977,000
| -297,154
| 303,308
| -90129,047
| 88300,408
| 91995,556
| 977,000
| 1111,000
| 273,846
| 437,308
| 119755,030
| 74991,716
| 191238,018
| 890,000
| 375,000
| 186,846
| -298,692
| -55809,509
| 34911,485
| 89217,095
| 451,000
| 406,000
| -252,154
| -267,692
| 67499,645
| 63581,562
| 71659,172
| 472,000
| 977,000
| -231,154
| 303,308
| -70110,740
| 53432,101
| 91995,556
| 822,000
| 890,000
| 118,846
| 216,308
| 25707,337
| 14124,408
| 46789,018
| 912,000
| 451,000
| 208,846
| -222,692
| -46508,432
| 43616,716
| 49591,864
| 9141,000
| 8758,000
| 0,000
| 0,000
| -107606,385
| 1183703,692
| 1203600,769
| 703,154
| 673,692
|
|
|
|
|
| Таблица 4
Расчет коэффициента автокорреляции четвертого порядка Yt
| Y_(t-4)
| Yt-Yср
| Y(t-4)-Y(t-4)ср
| (Yt-Yср)*(Y(t-4)-Y(t-4)ср)
| (Yt-Yср)^2
| (Y(t-4)-Y(t-4)ср)^2
| 375,000
|
|
|
|
|
|
| 594,000
|
|
|
|
|
|
| 854,000
|
|
|
|
|
|
| 1110,000
|
|
|
|
|
|
| 342,000
| 375,000
| -327,250
| -317,250
| 103820,063
| 107092,563
| 100647,563
| 296,000
| 594,000
| -373,250
| 594,000
| -221710,500
| 139315,563
| 352836,000
| 977,000
| 854,000
| 307,750
| 854,000
| 262818,500
| 94710,063
| 729316,000
| 1111,000
| 1110,000
| 441,750
| 1110,000
| 490342,500
| 195143,063
| 1232100,000
| 375,000
| 342,000
| -294,250
| 342,000
| -100633,500
| 86583,063
| 116964,000
| 406,000
| 296,000
| -263,250
| 296,000
| -77922,000
| 69300,563
| 87616,000
| 977,000
| 977,000
| 307,750
| 977,000
| 300671,750
| 94710,063
| 954529,000
| 890,000
| 1111,000
| 220,750
| 1111,000
| 245253,250
| 48730,563
| 1234321,000
| 451,000
| 375,000
| -218,250
| 375,000
| -81843,750
| 47633,063
| 140625,000
| 472,000
| 406,000
| -197,250
| 406,000
| -80083,500
| 38907,563
| 164836,000
| 822,000
| 977,000
| 152,750
| 977,000
| 149236,750
| 23332,563
| 954529,000
| 912,000
| 890,000
| 242,750
| 890,000
| 216047,500
| 58927,563
| 792100,000
| 8031,000
| 8307,000
| 0,000
| 7614,750
| 1205997,063
| 1004386,250
| 6860419,563
| 669,250
| 692,250
| 0,000
| 634,563
| 100499,755
| 83698,854
| 571701,630
| |