Key Facts
- Category
- Data Analysis
- Input Types
- textarea, number, select, checkbox
- Output Type
- json
- Sample Coverage
- 4
- API Ready
- Yes
Overview
The Seasonal Index Calculator helps you quantify recurring patterns in your time series data, allowing you to isolate seasonal fluctuations from underlying trends for more accurate forecasting.
When to Use
- •When you need to identify recurring peaks and troughs in historical sales or demand data.
- •When you want to remove seasonal noise to better understand the long-term trend of your data.
- •When preparing baseline data for future period forecasting based on historical seasonality.
How It Works
- •Input your time series data using your preferred separator (comma, space, or newline).
- •Define the number of periods per season, such as 12 for monthly data or 4 for quarterly data.
- •Select a calculation method, such as the Ratio to Moving Average, to determine the seasonal indices.
- •Optionally enable deseasonalized output to view your data with the seasonal component removed.
Use Cases
Examples
1. Monthly Sales Seasonality Analysis
Retail Manager- Background
- A retail manager has two years of monthly sales data and needs to understand which months consistently underperform to plan marketing budgets.
- Problem
- The raw data shows high volatility, making it difficult to distinguish between genuine growth and seasonal spikes.
- How to Use
- Paste the 24 months of sales figures, set 'Seasonal Periods' to 12, and select 'Ratio to Moving Average'.
- Example Config
-
periods: 12, method: 'ratio-to-moving-average', deseasonalize: true - Outcome
- The tool provides an index for each month, revealing that December consistently performs at 1.4x the average, while February drops to 0.7x.
Try with Samples
videoRelated Hubs
FAQ
What is a seasonal index?
A seasonal index is a value that represents the degree to which a specific period deviates from the average due to seasonal factors.
Which calculation method should I choose?
The Ratio to Moving Average method is recommended for most datasets as it effectively separates seasonal variations from trend and irregular components.
Can this tool forecast future values?
Yes, by specifying the number of forecast periods, the tool can project future values based on the calculated seasonal indices.
What does 'deseasonalize' mean?
Deseasonalizing removes the seasonal effect from your data, leaving only the trend and irregular components for clearer analysis.
What is the maximum number of periods I can set?
You can set the seasonal periods up to 365, accommodating daily data patterns.