7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
ARIMA Example Model Table arimamodel
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;

ARIMA Example Residual Table arimaresidual
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
... ... ... ...