Developer(s) Spider Financial Corp Development status Active Operating system | Initial release April 15, 2009 Written in C, C++ | |
Stable release 1.64.42788.1 / December 25, 2016; 2 months ago (2016-12-25) |
Numerical Analysis for Excel (NumXL) is an econometrics and time series analysis add-in for Microsoft Excel. Developed by Spider Financial, NumXL provides a wide variety of statistical and time series analysis techniques, including linear and nonlinear time series modeling, statistical tests and others.
Contents
- User interface
- Function categories
- Descriptive statistics
- Statistical testing
- Transform
- Smoothing
- Spectral analysis
- Date and calendar
- ARMA modeling
- ARCH GARCH analysis
- Factor analysis
- Advanced combo models
- Utilities
- Compatibility with Microsoft Excel
- References
Although NumXL is intended as an analytical add-in for Excel, it extends Excel’s user-interface (UI) and offers many wizards, menus and toolbars to automate the mundane phases of time series analysis. The features include summary statistics, test of hypothesis, correlogram analysis, modeling, calibration, residuals diagnosis, back-testing and forecast.
NumXL users have varied backgrounds in finance, economics, engineering and science. NumXL is used in academic and research institutions and industrial enterprises.
User interface
NumXL comes with an elaborate user-interface of menus, toolbars, and interactive wizards, to improve the general usability of the software. The UI components automate some steps in time series analysis and modeling.
Using the UI components and the wizards, a user can specify the time series of interest, fine-tune the desired analysis options and designate the location on a worksheet for the output. NumXL generates the corresponding analysis blocks (with underlying formulas) in the designated location
Function categories
NumXL functions are organized into eleven (11) categories:
Descriptive statistics
Statistical testing
Transform
Smoothing
Spectral analysis
Date and calendar
ARMA modeling
ARCH-GARCH analysis
Factor analysis
Advanced (combo) models
Utilities
Compatibility with Microsoft Excel
NumXL's statistical analysis software is compatible with all Excel versions from version 97 to version 2013 (Office 365), and with Windows versions 9x to Windows 8 (32- and 64-bits).