NumXL

Last updated
NumXL
NumXLlogo.png
Developer(s) Spider Financial Corp
Initial releaseApril 15, 2009;10 years ago (2009-04-15)
Stable release
1.65.43756.1 / December 25, 2016;2 years ago (2016-12-25)
Written in C, C++ [ citation needed ]
Operating system Windows
Type Econometrics software
License Trialware
Website numxl.com

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

NumXL is intended as an analytical add-in for Excel, but also extends Excel’s user-interface (UI) and offers many wizards, menus and toolbars to automate certain 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

DistributionNameLink function
Normal Identity
Poisson Log
Binomial Logit
Binomial Probit
BinomialComplementary log-log

Advanced (combo) models

Utilities

Compatibility with Microsoft Excel

NumXL's statistical analysis software is compatible with all Excel versions from version 2007 to version 2019 (Office 365), and with Windows versions 7 to Windows 10 (32- and 64-bits).

Release history

Version [1] ReleaseYearRelease DateNotes
NumXL 1.01.02009October 1, 2009Official release
NumXL 1.51.52011June 13, 2011New version
NumXL 1.51ORBSeptember 23, 2011New version
NumXL 1.52ORB2012January 26, 2012New version
NumXL 1.53.41023.1SACApril 25, 2012New version
NumXL 1.54.41030.2REDMay 2, 2012New version
NumXL 1.55.41040.2LYNXMay 11, 2012New version
NumXL 1.56.41060.2ZEBRAMay 31, 2012New version
NumXL 1.57.41168.2SINGASeptember 17, 2012New version
NumXL 1.58.41197.1BAJAOctober 16, 2012New version
NumXL 1.59.41245.1TUCSONDecember 3, 2012New version
NumXL 1.60.41413.1APACHE2013May 20, 2013New version
NumXL 1.61.41445.1BOLASJune 20, 2013New version
NumXL 1.62.41788.1DEWDROPNov 24, 2013New version
NumXL 1.63.41810.1SHAMROCK2014June 6, 2014New version
NumXL 1.64.42727.1TURRET2016December 25, 2016New version
NumXL 1.65.42877.1HAMMOCK2017May 19, 2017New version

See also

Related Research Articles

Time series Sequence of data over time

A time series is a series of data points indexed in time order. Most commonly, a time series is a sequence taken at successive equally spaced points in time. Thus it is a sequence of discrete-time data. Examples of time series are heights of ocean tides, counts of sunspots, and the daily closing value of the Dow Jones Industrial Average.

The Akaike information criterion (AIC) is an estimator of out-of-sample prediction error and thereby relative quality of statistical models for a given set of data. Given a collection of models for the data, AIC estimates the quality of each model, relative to each of the other models. Thus, AIC provides a means for model selection.

In the statistical analysis of time series, autoregressive–moving-average (ARMA) models provide a parsimonious description of a (weakly) stationary stochastic process in terms of two polynomials, one for the autoregression (AR) and the second for the moving average (MA). The general ARMA model was described in the 1951 thesis of Peter Whittle, Hypothesis testing in time series analysis, and it was popularized in the 1970 book by George E. P. Box and Gwilym Jenkins.

General linear model statistical linear model

The general linear model or multivariate regression model is a statistical linear model. It may be written as

X-12-ARIMA was the U.S. Census Bureau's software package for seasonal adjustment.

In statistics and econometrics, and in particular in time series analysis, an autoregressive integrated moving average (ARIMA) model is a generalization of an autoregressive moving average (ARMA) model. Both of these models are fitted to time series data either to better understand the data or to predict future points in the series (forecasting). ARIMA models are applied in some cases where data show evidence of non-stationarity, where an initial differencing step can be applied one or more times to eliminate the non-stationarity.

Exponential smoothing is a rule of thumb technique for smoothing time series data using the exponential window function. Whereas in the simple moving average the past observations are weighted equally, exponential functions are used to assign exponentially decreasing weights over time. It is an easily learned and easily applied procedure for making some determination based on prior assumptions by the user, such as seasonality. Exponential smoothing is often used for analysis of time-series data.

In time series analysis, the Box–Jenkins method, named after the statisticians George Box and Gwilym Jenkins, applies autoregressive moving average (ARMA) or autoregressive integrated moving average (ARIMA) models to find the best fit of a time-series model to past values of a time series.

A portmanteau test is a type of statistical hypothesis test in which the null hypothesis is well specified, but the alternative hypothesis is more loosely specified. Tests constructed in this context can have the property of being at least moderately powerful against a wide range of departures from the null hypothesis. Thus, in applied statistics, a portmanteau test provides a reasonable way of proceeding as a general check of a model's match to a dataset where there are many different ways in which the model may depart from the underlying data generating process. Use of such tests avoids having to be very specific about the particular type of departure being tested.

In statistics and econometrics, an augmented Dickey–Fuller test (ADF) tests the null hypothesis that a unit root is present in a time series sample. The alternative hypothesis is different depending on which version of the test is used, but is usually stationarity or trend-stationarity. It is an augmented version of the Dickey–Fuller test for a larger and more complicated set of time series models.

Genstat

Genstat is a statistical software package with data analysis capabilities, particularly in the field of agriculture.

In statistics, the Durbin–Watson statistic is a test statistic used to detect the presence of autocorrelation at lag 1 in the residuals from a regression analysis. It is named after James Durbin and Geoffrey Watson. The small sample distribution of this ratio was derived by John von Neumann. Durbin and Watson applied this statistic to the residuals from least squares regressions, and developed bounds tests for the null hypothesis that the errors are serially uncorrelated against the alternative that they follow a first order autoregressive process. Later, John Denis Sargan and Alok Bhargava developed several von Neumann–Durbin–Watson type test statistics for the null hypothesis that the errors on a regression model follow a process with a unit root against the alternative hypothesis that the errors follow a stationary first order autoregression. Note that the distribution of this test statistic does not depend on the estimated regression coefficients and the variance of the errors.

RATS, an abbreviation of Regression Analysis of Time Series, is a statistical package for time series analysis and econometrics. RATS is developed and sold by Estima, Inc., located in Evanston, IL.

The Ljung–Box test is a type of statistical test of whether any of a group of autocorrelations of a time series are different from zero. Instead of testing randomness at each distinct lag, it tests the "overall" randomness based on a number of lags, and is therefore a portmanteau test.

The Unistat computer program is a statistical data analysis tool featuring two modes of operation: The stand-alone user interface is a complete workbench for data input, analysis and visualization while the Microsoft Excel add-in mode extends the features of the mainstream spreadsheet application with powerful analytical capabilities.

In statistics, the Breusch–Godfrey test, named after Trevor S. Breusch and Leslie G. Godfrey, is used to assess the validity of some of the modelling assumptions inherent in applying regression-like models to observed data series. In particular, it tests for the presence of serial correlation that has not been included in a proposed model structure and which, if present, would mean that incorrect conclusions would be drawn from other tests, or that sub-optimal estimates of model parameters are obtained if it is not taken into account. The regression models to which the test can be applied include cases where lagged values of the dependent variables are used as independent variables in the model's representation for later observations. This type of structure is common in econometric models.

In time series analysis, the moving-average model, also known as moving-average process, is a common approach for modeling univariate time series. The moving-average model specifies that the output variable depends linearly on the current and various past values of a stochastic term.

The following outline is provided as an overview of and topical guide to regression analysis:

References

  1. NumXL Team. "NumXL Release Notes".