Ruben Apaza

20/04/2026

The next evolution of analytic, data science, and econometrics in Excel is coming soon.

Following the success of raXL Stat v0.5.2, we’ve been working intensively on our most ambitious update to date.
In just a couple of months, your spreadsheet will harness the power of high-end specialized software.

Currently in the final testing phase, the new version includes:

- Cointegration Tests: Engle–Granger and Johansen
- Advanced Time Series Modeling: Airline, SARIMA and SARIMAX
- Multivariate models such as VAR and VECM,
- Extended GARCH Family: GARCH-in-Mean models (GARCH-ARMA, TGARCH-ARMA, GJR-GARCH-ARMA, EGARCH-ARMA)
- Multivariate Volatility Models: CCC-ARMA, DCC-ARMA, BEKK
- And more exciting features to be revealed

All powered by carefully developed optimization algorithms, including Newton–Raphson, Levenberg–Marquardt, BHHH, DFP, and BFGS. We are refining every function to ensure precision and stability.

Get ready to take your data analysis and research to the next level.

Follow us for the official release date.

Note: This new version was made possible by the incentive of previously acquired licenses. As a token of our gratitude, discount codes will be offered to the users who supported us by purchasing previous versions. Thank you for making this growth possible!

24/12/2025

Wishing you peace, love, and happiness this Christmas. Let’s welcome 2026 with open hearts and new dreams!

27/08/2025

🚀 New Release!
We are excited to announce the launch of raXL Stat v0.5.2 [Beta], our advanced statistical and econometric add-in for Excel 📊.

🔹 What’s new in this version:

New functions Logit & Probit and Principal Component Analysis (PCA).

Improved statistical tests and model diagnostics.

Faster interface and built-in documentation for each function.

Stability and performance enhancements.

With raXL Stat, we bring the power of statistics and data science directly into Excel, making it more accessible, flexible, and powerful.

👉 Download it, try it, and share your feedback.
🔗 [https://github.com/rubenfapaza/raXL-Stat/releases/download/raXL_Stat_v0.5/raXL_Stat_v0.5.2.zip]

23/08/2025

raXL Stat, an Excel add-in, is already transforming the way professionals and companies manage data in Peru, Colombia, France, and England. 🇵🇪🇨🇴🇫🇷🇬🇧
We thank our global community 🌍 for their trust in this tool to take their statistical, econometric, and financial analysis to the next level 🙌.



https://www.instagram.com/p/DHGoHqWprSQ/?utm_source=ig_web_copy_link

17/04/2025

La Facultad de Ciencias Económicas y Financieras invita cordialmente al lanzamiento del libro "Elementos de Econometría Contemporánea", una obra académica fruto de la investigación y producción del Docente Titular Ph.D. HUMEREZ QUIROZ JULIO.
🗓 Fecha: Miércoles 23 de abril
🕓 Hora: 18:30
📍 Lugar: Paraninfo Universitario
🎓 Los participantes podrán recibir un certificado de asistencia, previa inscripción a través del siguiente formulario:
👉https://forms.gle/unNKSadEBoQNx9Q89
¡Acompáñanos en este importante evento académico y celebremos juntos el conocimiento y la investigación!

La Facultad de Ciencias Económicas y Financieras invita cordialmente al lanzamiento del libro "Elementos de Econometría Contemporánea", una obra académica fruto de la investigación y producción del Docente Titular Ph.D. HUMEREZ QUIROZ JULIO.
🗓 Fecha: Miércoles 23 de abril
🕓 Hora: 18:30
📍 Lugar: Paraninfo Universitario
🎓 Los participantes podrán recibir un certificado de asistencia, previa inscripción a través del siguiente formulario:
👉https://forms.gle/unNKSadEBoQNx9Q89
¡Acompáñanos en este importante evento académico y celebremos juntos el conocimiento y la investigación!

17/03/2025

raXL_Stat-v.0.4.1
• New: Multiple and simple linear regression, coefficient estimation, fitting, and forecasting (UDF only)
• Improved: Scatter plot matrix.

Download trial
https://ruben-apaza.blogspot.com/p/raxl-stat.html

31/12/2024

Happy New Year 2025
Wishing you a year full of endless possibilities, boundless joy, and unforgettable moments!

07/12/2024

raXL Stat v0.4
Statistical Add-in for Data Science in Excel

raXL Stat is an advanced add-in for Microsoft Excel designed to enhance the capabilities of Excel by providing a suite of statistical, econometric, financial, and mathematical modeling functions. This tool allows users to perform complex data analyses directly within their spreadsheets, making it accessible for both beginners and experts in data science.

Key Features of raXL Stat

User-Friendly Interface: raXL Stat integrates seamlessly with Excel, featuring an intuitive ribbon menu that simplifies access to its functions. Users can also write functions directly into spreadsheet cells or utilize VBA (Visual Basic for Applications) for more advanced programming needs.

Statistical Analysis Tools: The add-in offers a wide range of statistical tools including:

Autocorrelation Function (ACF) and Partial Autocorrelation Function (PACF) calculations.

White Noise tests such as the Ljung-Box or Box-Pierce tests.

Unit Root and Stationarity tests using the Augmented Dickey-Fuller (ADF) test or Kwiatkowski-Phillips-Schmidt-Shin (KPSS) test.

Modeling Capabilities: Users can estimate, forecast, and graph various time series models including:

ARIMA(p,d,q) models which encompass autoregressive (AR), moving average (MA), and integrated components.

ARCH(p) and GARCH(p,q) models for analyzing time series data with volatility clustering.

Data Visualization: raXL Stat facilitates the creation of visual representations of data through automated charts. Users can generate histograms with cumulative curves or normal curves, box plots with outliers, and scatter plot matrices.

Descriptive Statistics: The add-in provides tools to compute descriptive statistics along with normality tests using methods like Shapiro-Wilk, Anderson-Darling, and Jarque-Bera tests.

Investment Portfolio Analysis: For finance professionals, raXL Stat includes features to calculate Value at Risk (VaR), perform backtesting with z-tests and LR-Kupiec tests, assess weights, risk and return metrics, and visualize the Efficient Portfolio Frontier (EPF) alongside the Capital Market Line (CML).

Simulation Functions: The software supports simulations such as Geometric Brownian Motion (GBM), allowing users to model stock prices or other financial instruments over time.

Installation Requirements: Notably, raXL Stat does not require traditional installation; it operates as a portable .xll file compatible with various versions of Microsoft Excel from 2010 through 2024 on Windows operating systems.

In summary, raXL Stat is a powerful tool that transforms Microsoft Excel into a robust platform for quantitative analysis, enabling users to conduct sophisticated statistical evaluations efficiently while leveraging familiar spreadsheet functionalities.

Download Trial v0.3
https://ruben-apaza.blogspot.com/p/raxl-stat.html

16/11/2024

raXL Stat v0.3
Complemento estadístico para Ciencia de Datos en Excel

Descargar:
https://ruben-apaza.blogspot.com/p/raxl-stat.html

16/10/2024

Prueba de Dickey-Fuller Aumentada o KPSS en Excel con el Complemento raXL Stat

La prueba de Dickey-Fuller Aumentada (ADF) o KPSS test (Kwiatkowski-Phillips-Schmidt-Shin) son herramientas estadísticas fundamentales para analizar series temporales, ya que permite determinar la presencia de una raíz unitaria y, por lo tanto, evaluar la estacionariedad de los datos. La estacionariedad es crucial en muchos modelos de pronóstico, ya que los datos no estacionarios pueden conducir a resultados engañosos. En este artículo, exploraremos cómo realizar la prueba ADF o KPSS en Excel utilizando el complemento raXL Stat, lo que facilita su uso para aquellos que no tienen acceso a software estadístico avanzado.

RubenApaza - Consultor, Asesor y Capacitador en temas de Ingeniería Industrial, de Sistemas, Proyectos, Finanzas y Economía. .

16/10/2024

Crear Correlograma ACF, PACF y la Prueba de Ljung-Box en Excel con el Complemento raXL Stat

El análisis de series temporales es fundamental en muchas áreas, como la economía y la ingeniería. Herramientas como la Función de Autocorrelación (ACF), la Función de Autocorrelación Parcial (PACF) y la prueba de Ljung-Box son esenciales para identificar modelos adecuados y validar los resultados. El complemento raXL Stat para Excel facilita la creación de estos análisis. A continuación, se presenta una guía paso a paso para crear un correlograma ACF y PACF y realizar la prueba de Ljung-Box o Box-Pierce.

RubenApaza - Consultor, Asesor y Capacitador en temas de Ingeniería Industrial, de Sistemas, Proyectos, Finanzas y Economía. .

16/10/2024

Modelo ARIMA en Excel con el complemento raXL Stat

El modelo ARIMA (AutoRegressive Integrated Moving Average) es una herramienta muy utilizada para el análisis y pronóstico de series temporales. El complemento raXL Stat para Excel facilita la implementación de este modelo.

RubenApaza - Consultor, Asesor y Capacitador en temas de Ingeniería Industrial, de Sistemas, Proyectos, Finanzas y Economía. .