NumXL

NumXL is a powerful piece of software that is designed to boost Microsoft Excel's capabilities at handling complex time series analysis. In other words, it automates the most common steps, therefore simplifying your efforts.

Assuming Microsoft Office is already installed on your system, the addin undergoes a typical installation procedure. As is the case with most modern addins, after its installation, NumXL is integrated with Excel's ribbon toolbar.

You now have at your disposal a wide array of econometric and time series analysis functions. You can start examining the data series summary and statistics with the help of the correlogram wizard.

The addin also comes with various features for measuring prediction power and helps you construct histograms and empirical cumulative distributions.

If methods like Pearson, Spearman and Kendall sound familiar, then you might be pleased to hear that NumXL comes with support for them and also for Hurst and Gini exponent analysis. In terms of statistical testing, the addin does not disappoint either, as it packs an efficient API for calculating the P-Value.

What is more, NumXL comes with support for the following forms of trend: linear, polynomial, logarithmic, power and exponential.

It also supports calendar adjustment and date rolling features. Being a very important procedure, the adding also comes with support for spectral analysis. More exactly, it comes with support for Hodrick-Prescott, Baxter-King and convolution parameters.

The addin can also make it easy for you to handle ARMA analysis tasks thanks to an intuitive wizard. Simply edit the formulas in the output cells and benefit from immediate results. Worth mentioning is the fact that NumXL also comes with support for ARIMA, ARCH, GARCH and GLM models.

Taking all things into consideration, NumXL is an efficient software solution that integrates with Excel and transforms it into a powerful econometric tool. Besides this, the addin comes with intuitive wizards for most of its complex functions, making it a bit curious.