In this module, we will walk you through time series smoothing in Excel using NumXL functions and tools. For sample data, we’ll use the S&P 500 weekly closing prices between January 2009 and July 2012.
In this module, we will continue along this path and find the optimal values for the model’s parameters – a process referred to as “calibration”. Once calibrated, you can examine the residuals for the model’s assumptions and compare this model with other models.
In this tutorial, we use the NumXL function toolbar in Excel to compute a data set's probabilistic distribution characteristics (descriptive statistics): mean, standard deviation, skew, and kurtosis (or excess-kurtosis).
NumXL is a suite of time series Add-ins for Microsoft Excel. Once loaded, NumXL integrates scores of time series functions, along with a rich set of user interfaces and tools to assist in your data analysis.