coef | value |
---|---|
coef | 3, 0, 0, 0, 0, 0 |
ar_params | 1.831645480043797, -1.179667384141421, 0.3477840265302269 |
ar_params_sd | 0.07527420134556974, 0.13530358092847117, 0.07512437361242541 |
ma_params | |
ma_params_sd | |
seasonal_ar_params | |
seasonal_ar_params_sd | |
seasonal_ma_params | |
seasonal_ma_params_sd | |
mean_param | 1.0015614905052501 |
mean_param_sd | NaN |
period | 0 |
sigma2 | 629.5936409862431 |
loglikelihood | -724.0702297433396 |
iterations | 18 |
converged | true |
This query returns the output shown in the following table:
SELECT * FROM arimaresidual ORDER BY period;
arimapartionid | ts | value | residual |
---|---|---|---|
1 | 1962-01 | 578.3 | 0 |
1 | 1962-02 | 609.8 | 0 |
1 | 1962-03 | 628.4 | 0 |
1 | 1962-04 | 665.6 | 32.8313311116795 |
1 | 1962-05 | 713.8 | 23.880880606934 |
1 | 1962-06 | 707.2 | -33.5896560166473 |
1 | 1962-07 | 628.4 | -56.3783948486636 |
1 | 1962-08 | 588.1 | 23.1062275326814 |
1 | 1962-09 | 576.3 | -5.54076736453666 |
1 | 1962-10 | 566.5 | -13.8626369886166 |
... | ... | ... | ... |