Seasonality Identification

[jraehoner]

We are looking in the procces of bidding out a lot of seasonal business. The company work for has different fluxuations for different products. We are searching for 2 things.
1) I was to identify the 2or 3 month seasons based on a formula
2) A way to formulaically apply that to another data set.

Here is an example:
We can see from the data that we start with season 1, then in May and june we have 2 months of increased data or season 2, in July this drops again and is season 3. Oct-Dec is variable and we would not want to call that a season.

	2011 Shipment distribution</SPAN>	2013 Distribution based on 120 shipments</SPAN>
Jan</SPAN>	1 </SPAN>
Feb</SPAN>	1 </SPAN>
Mar</SPAN>	2 </SPAN>
Apr</SPAN>	2 </SPAN>
May</SPAN>	10 </SPAN>
Jun</SPAN>	10 </SPAN>
Jul</SPAN>	2 </SPAN>
Aug</SPAN>	2 </SPAN>
Sep</SPAN>	2 </SPAN>
Oct</SPAN>	8 </SPAN>
Nov</SPAN>	1 </SPAN>
Dec</SPAN>	8 </SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[shg]

       -A- -B-- -C--
   1       2011 2012
   2   Jan    1  2.4
   3   Feb    1  2.4
   4   Mar    2  4.9
   5   Apr    2  4.9
   6   May   10 24.5
   7   Jun   10 24.5
   8   Jul    2  4.9
   9   Aug    2  4.9
  10   Sep    2  4.9
  11   Oct    8 19.6
  12   Nov    1  2.4
  13   Dec    8 19.6
  14                
  15         49

In C2 and copy down,

=120*B3/B$15

 

[jraehoner]

Thank you MrEXcel MVP That still leaves question 1.

1) I was to identify the 2or 3 month seasons based on a formula.