Finding Seasonality for a large number of items in Excel.
Home > IT Answers > Microsoft Windows > Finding Seasonality for a large number of ite...
XENOPHON22
185 pts.
0
Q:
Finding Seasonality for a large number of items in Excel.
Excel 2007, Date calculation, Excel Calendars
I am trying to establish any seasonality with what is, unfortunately, a large number of items and a relatively small time sample.  I have 32,000 different items which have typically sold at a steady pace over the past three years.  I have the sales of each item by month for the previous three years and am trying to identify those with larger sales over particular recurring monthly periods.

I am currently using a few ideas which pit single or small groups of consecutive months against the next year.  Does any one have a better idea?


Thank you.


Software/Hardware used:
EXCEL 2007
ASKED: Nov 11 2009  7:36 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Labnuke99
26695 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Try the frequency function in Excel to parse out ranges of the values for each month. You could have sales of a certain dollar value or sales of specific quantities in the bin ranges. See the links below for more information on the frequency function.

http://support.microsoft.com/kb/100122
http://www.meadinkent.co.uk/xlfreq.htm
Google video search for Excel Frequency function videos
Last Answered: Nov 11 2009  8:13 PM GMT by Labnuke99   26695 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0