Allows for an assessment of the existence and nature of any seasonality in the series. All the monthly values are plotted in chronological order with each month on the horizontal axis. The years represent the 10 separate years of data that in the time series. We can see that our data has seasonal spikes during the summer and winter months.
Allows for an assessment of whether the underlying nature of the time series varies across seasons. Our bookings series shows that January, February and August have the greatest deviations.
Determine the nature of any underlying autocorrelation and in assessing the possible needs in terms of data differencing for the creation of an ARIMA model. The lag refers to the number of periods behind the most recent period and the correlation coefficient is the vertical axis.
Determine the nature of any underlying autocorrelation and in assessing the possible needs in terms of data differencing for the creation of an ARIMA model. The lag refers to the number of periods behind the most recent period and the correlation coefficient is the vertical axis.
A visual examination of the original data, the trend in the data, the seasonality in the data, and information about the residuals once seasonality and trend have been take into account.
C:\Users\tlam\Desktop\Clients\2018Q2\UBS\Forecast\Stock Three Example.xlsx|||`Sheet1$`
False
1
Stock Three Example.xlsx
Table=`Sheet1$`
[Symbol] = "GOOG"
Simple
=
Symbol
True
fixed
2018-04-01 14:51:28
0
GOOG
2018-04-01 14:51:28
2018-04-01 14:51:28
[Symbol] = "GOOG"
Seasonal Plot
Bookings
False
False
False
False
True
False
False
False
True
2002
1
False
True
False
False
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
C:\ProgramData\Alteryx\Engine\Engine_23392_8b91438c0002474d8cf20aef75fd7316_\Engine_14496_87c3005aa29e4ad18b8a50b0c57c42c3_.yxdb
C:\ProgramData\Alteryx\Engine\Engine_23392_8b91438c0002474d8cf20aef75fd7316_\Engine_14496_a8d2bc26368949e58e85450e06a505a7_.yxdb
Single
Report
Seasonal Deviation Plot
Bookings
False
False
False
False
True
False
False
False
True
2002
1
False
False
True
False
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
C:\ProgramData\Alteryx\Engine\Engine_21540_8f25a7c01516482aafb71aed1bc5a24c_\Engine_14496_0e73bfc4dfec4d558f30a84e8055e937_.yxdb
Single
Report
C:\ProgramData\Alteryx\Engine\Engine_21540_8f25a7c01516482aafb71aed1bc5a24c_\Engine_14496_7e7f611b77bc430383accc558801f5e4_.yxdb
Single
Report
Autoregression Function Plot
Bookings
False
False
False
False
True
False
False
False
True
2002
1
False
False
False
True
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
C:\ProgramData\Alteryx\Engine\Engine_21540_8f25a7c01516482aafb71aed1bc5a24c_\Engine_14496_d01f0d7b3c524e18bf97218ca06d4ea2_.yxdb
C:\ProgramData\Alteryx\Engine\Engine_21540_8f25a7c01516482aafb71aed1bc5a24c_\Engine_14496_74b77ca9b512496282898fbd31c17b94_.yxdb
Partial Autoregression Function Plot
Bookings
False
False
False
False
True
False
False
False
True
2002
1
False
False
False
False
True
False
True
5.50
5.50
False
13.00
14.95
1x
10
C:\ProgramData\Alteryx\Engine\Engine_21540_8f25a7c01516482aafb71aed1bc5a24c_\Engine_14496_04d59f3f511a497daeb0454429f55c92_.yxdb
C:\ProgramData\Alteryx\Engine\Engine_21540_8f25a7c01516482aafb71aed1bc5a24c_\Engine_14496_faec4e74fb9f49b0a63a157f024a0513_.yxdb
Time Series Decomposition Plot
Open
False
False
True
False
False
False
False
False
True
2016
1
False
False
False
False
False
True
True
5.50
5.50
False
13.00
14.95
1x
10
C:\ProgramData\Alteryx\Engine\Engine_23392_8b91438c0002474d8cf20aef75fd7316_\Engine_14496_3e61fed5e52343bb9dd345e55496e56e_.yxdb
Single
Report
C:\ProgramData\Alteryx\Engine\Engine_23392_8b91438c0002474d8cf20aef75fd7316_\Engine_14496_2ced18a4873143b8bc7391037e9bb469_.yxdb
Single
Report
TS Decomposition Data
C:\ProgramData\Alteryx\Engine\Engine_22504_919330c9ba4a4abf8584c74dfdb48a8d_\Engine_16708_b3edf6f682794938a241e2d15596991b_.yxdb
Single
Profile
Close
False
False
False
False
True
False
False
False
2016
1
TS Decomp (34)
Time Series Plot
Open
False
False
True
False
False
False
False
False
True
2016
1
True
False
False
False
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
C:\ProgramData\Alteryx\Engine\Engine_22504_919330c9ba4a4abf8584c74dfdb48a8d_\Engine_16708_bef64cc2dc8946af962b148369f114e8_.yxdb
Single
Report
C:\ProgramData\Alteryx\Engine\Engine_22504_919330c9ba4a4abf8584c74dfdb48a8d_\Engine_16708_339e01c3143444e798bc49e3e8f15ed2_.yxdb
Single
Report
Horizontal
Stock Forecast Step1_ TS Plot
Tab
Questions
Tab (38)
Macro