Data preparation – Missing Values
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
March 29, 2012
Menu
On this page, find free resources on using NumXL functions and wizards in Microsoft Excel for data analysis and forecasting.
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
It has come to our attention that some users who directly download from our site have warning message saying that the program is corrupted. To avoid this, we recommend our users to download the program and save onto their local disk (or desktop), not a network drive, before launching it.
© 2024 Spider Financial Corp | | Terms & Conditions | Disclaimer | Privacy Policy | Trademarks & Copyrights
