Logo Help center
Sign in
English (US) Deutsch Español Français 日本語 한국어 Português Русский 简体中文
  • Home
  • Community
  • Submit a request
sidebar image
  1. Help center
  2. Tips & Tricks

Tips & Tricks

Explore the articles in this section for the latest tips, tricks, demos, free resources, and more to help you maximize the use of NumXL functions and wizards in Microsoft Excel. Whether you want to enhance your data analysis skills, troubleshoot common issues, or discover new ways to utilize NumXL, you'll find valuable insights and practical guidance here.

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