raXL Stat, statistical Add-in for Data Science in Excel

raXl Stat. The ultimate Excel add-in to analyze your data quickly and accurately. Save time and make better decisions with our powerful statistics and data visualization features.

raXL Stat is an add-in for Microsoft Excel that turns your favorite spreadsheet into a quantitative and predictive analysis software, offering a collection of functions to create statistical, econometric and mathematical models. You can call these functions directly from a spreadsheet and they will return the modeling results directly to it.

raXL Stat is a statistical analysis software that will offer¹ easy-to-use tools to perform and deliver quality work in a short time. It is developed² to be used by both beginners and experts. The easiest and most intuitive way to run the functions is through the ribbon menu. If necessary, the user can directly write the functions in the spreadsheet cells or can invoke the functions from VBA (Visual Basic for Application) programming.

A feature of raXL Stat is that it does not require installation (portable .xll file), it integrates seamlessly with Excel with new User Defined Functions (UDF), automated charts, a rich set of shortcuts and an intuitive user interface for use. It integrates with the version of Excel you have installed on your Personal Computer (PC), not the Windows version.

With the raXL Stat v.0.0 [Beta] add-in you can do the following:

• Calculate and graph the Autocorrelation Function (ACF).
• Calculate and graph the Partial Autocorrelation Function (PACF).
• Perform the White Noise and independence test with the Ljung-Box or Box-Pierce test.
• Perform the Unit Root and Stationarity test with the Augmented Dickey-Fuller (ADF) or Kwiatkowski-Phillips-Schmidt-Shin (KPSS) test.
• Calculate coefficients, estimate, forecast, and graph the ARIMA(p,d,q) models, i.e., AR(p), MA(q), and ARMA(p,q).
• Calculate coefficients, estimate, forecast, and graph the ARCH(p) and GARCH(p,q) models.
• It has 30 complementary User Defined Functions (UPF)³, such as covariance matrix, invert range (Upward-Downward), differencing range, numerical interpolation(x,y) and display lags.

Footnotes

1. raXL Stat version v.0.0 [Beta] is a test version to which new public functions will be added to the existing 30. ↩

2. Acknowledgment: raXL Stat uses Excel-DNA: Copyright (c) 2024 Govert van Drimmelen. ↩

3. The ARIMA and GARCH functions use the Maximum Likelihood Estimation (MLE) method together with the Newton-Raphson (NR) optimization algorithm, however, other optimization methods such as Levenberg-Marquardt, BHHH, BFGS and others will be added in development. ↩