mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmSEASON, Seasonality Indexes

Business Formulas

mmSEASON, Seasonality Indexes

Category: Forecast The function mmSEASON returns seasonal indexes of time series. The knowledge of seasonal movements is typically applied to analyze past performance and change the pattern of production and distribution.

The function mmSEASON can be applied to actual and forecasted sales (or other kinds of time series) as well as to sales as a percentage of the sales trend.

Business analysis formulas for Excel. Marketing tool for professionals

Where:

SI = Seasonal index
V = Values of the same time interval, for instance, all first quarters in the time series
N = Count of values of the same time interval, for instance, all first quarters in the time series

Syntax

mmSEASON(Actual_Data, Optional Cycle_Length, Optional Cycle_Start)

Actual_Data A range of values, e.g, monthly sales
Cycle_Length Optional - An integer value, e.g., 12 for months, 6 for semesters, 4 for quarters, etc.
Cycle_Start Optional - An integer indicating the position of the value in the cycle, e.g., 2 = the second month of the year or the second quarter

Example

See example file Business Formulas.xls, sheet mmSEASON.

Business analysis formulas for Excel. Marketing tool for professionals

Note: This is an Array Function (curly brackets { } ). To enter an array function: (1) select the range where you want to enter it, for instance, E15:E18; (2) type the formula; (3) press CTRL+SHIFT+ENTER. Related functions
  • mmBUYRATE
  • mmCAGR
  • mmCSII
  • mmCSIW
  • mmDW
  • mmGROWTH
  • mmMAD
  • mmMAPE
  • mmME
  • mmMSE
  • mmRMSE
  • mmU
  • mmBASS
  • mmCODING
  • mmINTERPOLE
  • mmRANGE
  • mmRANK
  • mmVARc
Related MM4XL software tools
  • Forecast Manager
  • Quality Manager
  • Variation Analyst
  • Descriptive Statistics
Source
Jeffrey Jarrett, 1987, Business forecasting methods
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: