Logo Help center
Sign in
English (US) Español
  • Home
  • Community
  • Submit a request
sidebar image
  1. Help center
  2. Tips & Tricks

Tips & Tricks

Check back here for the latest tips and tricks, demos, and more to help you use NumXL to its full potential.

Descriptive Statistics

  • Hurst Exponent in Excel

Data Fitting

  • Interpolation 101
  • Local & Kernel Regression (Non-Parametric)

Statistical Testing

  • How do I test whether a given time series is just white‐noise?
  • Normality Test - Facts and Myths

ARMA / ARIMA Modeling

  • Backtesting in Excel
  • X12-ARIMA Challenges and Workarounds
  • Using Quarterly Data in X-13ARIMA-SEATS
  • Backtesting for X-13ARIMA-SEATS
  • NumXL Cookbook - AirLine Model
  • Text Book Example - Airline Passenger Data
See all 7 articles

Volatility Modeling

  • Forecast Models with Auto-Update Features
  • NumXL Cookbook - Volatility Forecast With GARCH

Factors Analysis

  • Constructing a Correlation matrix
  • NumXL Cookbook - GLM with Binary Data
  • How to Setup Regression Analysis to Update Automatically

Spectral Analysis

  • Data filtering with Fourier

Utilities

  • Removing Missing Values (RMNA)
© Help center
  • About us
  • Download
  • Buy
  • Contact us