Time series and stationarity
Today we launch the second tutorial in our ongoing series about data preparation in time series analysis. Our focus this time around is one of
April 4, 2012
On this page, find free resources on using NumXL functions and wizards in Microsoft Excel for data analysis and forecasting.
Today we launch the second tutorial in our ongoing series about data preparation in time series analysis. Our focus this time around is one of
This issue is the first in a series of articles that explore the data preparation aspect of time series analysis. Data preparation is often overlooked
This week, we focus our attention on your burning questions about goodness-of-fit functions, like What are the different functions for the goodness of fit? How
This issue is brimming with info about a key tool in our time series arsenal toolbox: correlogram analysis. We take you first through the auto-correlation and the partial auto-correlation functions definition.Next, we derive and highlight the common patterns in the ACFi and PACFi plots generated by AR, MAi and ARMAi type of processes. Finally, we draw a number of observations and drive quick intuitions to further help us identifying the candidate model(s) and its order using only ACF/PACF plots set.
In our continuous effort to make NumXL easy to use, we have created a tutorial video for our latest Tips and Hints Issue: ARCH Test Explained
In this week’s issue of Tips & Tricks, we use the NumXL package to explain a common – and commonly misunderstood – diagnostic in econometric and time series analysis: the Auto Regressive Conditional Heteroskedacity test, or ARCH test for short.
In this week’s issue of Tips & Tricks, we use the NumXL package to demystify the normality test, a common diagnostic tool in econometric and
In this week’s issue of Tips & Tricks, we consider the process of model comparison, as well as the selection of the best model. Using
In this week’s “Tips and Tricks” newsletter, we present the analysis, modeling, and forecast for international airline passenger data. We make use of a familiar
This week, the “Tips & Tricks” newsletter tackles the issue of the volatility forecast using GARCH Modeling techniques. Starting with S&P 500 ETF monthly prices, the
© 2025 Spider Financial Corp | Terms & Conditions | Disclaimer | Privacy Policy | Trademarks & Copyrights
