NumXL

NumXL is simplifying the time series data analysis by offering an intuitive, but yet powerful, rich-set of functions directly into your Microsoft Excel spreadsheet. With NumXL, the days of programming common mundane calculations such as auto-correlation factors, estimating ARIMAⁱ/GARCHⁱ model's parameters, analyzing residuals distributions, and forecasting is officially over. NumXL wraps those calculations, and avails them as a simple extension to Excel. As a result, Excel can do the work for you, while you focus your efforts on the devising the proper model, back-testing, examining scenarios and, yet, presenting your conclusions/recommendations in a tractable report.

1. An Extension of Excel

NumXLis a true extension of Excel that can be used just like any of the native functions in Excel (i.e. SUM, AVERAGE, STDEVⁱ, etc.). You can use NumXL functions via Excel menus, by either manually typing it in your workbooks, via menu, and by using Excel function wizard.

2. An intuitive Approach

With NumXL, the users develop their econometric models in Excel in the same way they always did, but now, they use NumXL to test for normal distribution, serial correlation or dataset stability, and calibrate ARMAⁱ/GARCH model using the data in Excel and forecast values for new points.

3. You're in control

NumXL gives you complete control over the location and format of computed values. Just like a native Excel function, NumXL places the calculated results into the selected cell and nowhere else. Once you've created a NumXL formula, you can use it just like any other Excel formula by copying or linking to other cells.

4. Maximize the productivity

NumXL is the perfect tool to automate your analysis process. Once a spreadsheet is created with NumXL functions for one data set, running the same analysis for different data (or same but new observations) is as simple as copy & paste.

For further information, please refer to online tutorials and case studies.