X13ASCOMP - X-13ARIMA-SEATS Output Time Series

Returns the value of an X-13ARIMA-SEATS model output component (e.g. adjusted, trend, seasonal or irregular).

Syntax

X13ASCOMP(model, component, dt)
model
is a unique identifier that designates an X-13ARIMA-SEATS model (created using the NumXL X13ARIMA Wizard).
component
is an identifier of the output component (0= seasonal adjusted (default),1= trend, 2=seasonal, 3=irregular).
Value Description
0 Final seasonal adjusted component (default)
1 Final trend component
2 Final seasonal component
3 Final irregular component
dt
is the date of the desired observation. If omitted, the entire time series of the component is returned.

  Status

The X13ASCOMP(.) function is available starting with version 1.67 MARTHA.

Remarks

  1. The time series is homogeneous or equally spaced.
  2. If the date value is later than the input data set size and forecast horizon, X13ASCOMP returns "#N/A!"
  3. If the date value is earlier than the input series start date, X13ASCOMP returns "#VALUE!"
  4. If the component argument value is not supported, X13ASCOMP returns "#VALUE!"

Files Examples

References

Comments

Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful