NumXL

NumXL

Developer(s)	Spider Financial Corp
Initial release	April 15, 2009
Stable release	1.51 / September 23, 2011; 59 days ago (2011-09-23)
Development status	Active
Written in	C/C++
Operating system	Windows
Type	econometrics software
License	proprietary
Website	www.spiderfinancial.com

NumXL (Numerical Analysis for Excel) is an econometrics/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.

Although NumXL is intended as an analytical Add-in for Excel, it extends the Excel’s user-interface, and offers numerous wizards, menu and toolbar to automate the mundane phases of time series analysis: summary statistics, test of hypothesis, correlogram analysis, modeling , calibration, residuals diagnosis, back-testing and forecast.

NumXL users come from various backgrounds of finance, economics, engineering and science. NumXL is used in academic and research institutions as well as industrial enterprises.

NumXL User's Interface

NumXL comes with an elaborate user-interface (i.e. menu and toolbar), and interactive wizards to improve the general usability of the software. The NumXL UI components automate the common process/steps of a time series analysis and modeling.

Using the UI components and the wizards, the user specifies the time series of interest, fine-tune the desired analysis options and specify the location on his/her worksheet for the output. NumXL generates the corresponding analysis blocks (with underlying formulas) in the designated location

Function Categories

NumXL Functions are organized into four categories:

Statistical Testing

• Hypothesis Test for population mean, for standard deviation, for skewness and for excess kurtosis.
• Normality test using Jarque–Bera test, Shapiro–Wilk_test, and Chi-square test methods.
• White-noise test - Serial correlation tests (Portmanteau Test, Ljung-Box test and modified Q-test).
• Autoregressive Conditional Heteroskedasticity (ARCH) effect test.

Linear Time Series

• Basic Operators - DIFF, LAG, WMA, Add, Subtract, scale, and time-reverse operators.
• Autocorrelation function(ACF) and Partial autocorrelation function (PACF).
• Cross-correlation functions - XCF and EWXCF
• Autoregressive Moving Average (ARMA) model
• AirLine Model
• Generalized Linear Model (GLM)
• Goodness of fit - LLF, AICc and model's diagnosis.
• Forecast and back-testing

ARCH/GARCH Analysis

• Basic Operators - EWMA/EWV
• GARCH Model.
• Exponential GARCH (E-GARCH) Model.
• GARCH in the mean (GARCH-M) Model.
• Support for Gaussian, Student's t and GED distributed innovations/shocks.
• Goodness of fit - LLF, AICc and model's diagnosis

Advanced (Combo) Models

• Model Definition Function.
• Mixed Model - likelihood function.
• Goodness of fit - LLF, AICc, and model's diagnosis.

Utilities

• Interpolation Functions - Flat forward/backward, linear, and cubic spline interpolation.
• Time series Functions - Remove missing values from a time series.
• Statistical Functions - Calculate the excess kurtosis of a GED and Student's t-dist.

Compatibility with Microsoft Excel

NumXL's statistical analysis software is compatible with all Excel versions from version 97 to version 2010, and is compatible with the Windows 9x till Windows 7 (32 and 64-bit) systems.

Release history

Version[1]	Release name	Year	Release Date	Notes
NumXL	Alpha	2009	April 15, 2009
NumXL	Beta		June 30, 2009
NumXL	RC		July 24, 2009	Release Candidate.
NumXL 1.0	1.0		October 1, 2009	Official release of NumXL version 1.0.
NumXL 1.0	SP1	2010	January 5, 2010
NumXL 1.0	SP2		January 26, 2010
NumXL 1.0	SP3		September 2, 2010
NumXL 1.5	1.5	2011	June 13, 2011	Official release of NumXL 1.5.
NumXL 1.51	ORB	2011	September 23, 2011	Maintenance release.

See also

• EViews -- A statistical package for Windows
• gretl -- an open source alternative to EViews
• Rcmdr -- an open source R-based alternative to SPSS
• OxMetrics -- an alternative econometrics package
• RATS
• Comparison of statistical packages
• AREMOS

External links

• NumXL Home page
• NumXL Release notes

Reference List

1. ^ SpiderXL Team. "NumXL Release Notes" (HTML). http://www.spiderfinancial.com/products/numxl/release-notes.