Home / Statistical Tools / Analysis Tools / Time Series

Time Series

Analyze data collected over time: fit and forecast trends, smooth out noise, and measure how values relate to their own past or to another series.

Worked examples

The How-To pages build this chart step by step from sample data, one walkthrough per data layout the tool accepts. Start there if you would rather see a finished result than read the settings.

Quantum XL's Time Series menu contains six tools in two groups:

Smoothing and forecasting (dialog: Time Series Smoothing)

• Trend Analysis: fit a linear or quadratic trend over time, with optional forecasts
• Moving Average: smooth the series with a running average
• Double Exponential Smoothing: Holt's method, tracking both level and trend, with optional forecasts

Correlation over time (dialog: Time Series Correlation)

• Autocorrelation: how a series correlates with its own past values (ACF)
• Partial Autocorrelation: the same, with intermediate lags removed (PACF)
• Cross Correlation: how two series correlate across time shifts (CCF)

All six take numeric data columns in time order. Each tool's page lists every option in its dialog.

Learn More

• Math Details: The exact formulas behind all six tools