Finding Seasonality for a large number of items in Excel.

2340 pts.
Tags:
Date calculation
Excel 2007
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

<a href=”http://support.microsoft.com/kb/100122″>http://support.microsoft.com/kb/100122</a>
<a href=”http://www.meadinkent.co.uk/xlfreq.htm”>http://www.meadinkent.co.uk/xlfreq.htm</a>
<a href=”http://video.google.com/videosearch?q=excel+frequency+function&rls=com.microsoft:en-us&oe=UTF-8&um=1&ie=UTF-8&ei=ABr7SszaKNiAkQWNweSwCw&sa=X&oi=video_result_group&ct=title&resnum=4&ved=0CBsQqwQwAw#”>Google video search for Excel Frequency function videos</a>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • XENOPHON22
    Last week, between taking care of my primary duties, I tried using frequency functions on this data but could not find a discernible method by which to sort these out. This would be helpful in a handful of items but I have over 30k to review. Any other ideas?
    2,340 pointsBadges:
    report
  • Labnuke99
    I use this function on about 2k items at a time. You could still use it on a large number of items, you just need to break down the categories into reasonable chunks or percentages. You could filter and then run the frequency function and that might help. The videos gave some good ideas about that process.
    32,960 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following