Chapter 4 - Part 2

Chapter 4 - Part 2 - Section 4.5 Measuring Seasonality The...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
3/10/11 Section 4.5 – Measuring Seasonality The five-step procedure: 1. Find the centered moving averages 2. Divide each yt by its centered moving average 3. Put the ratios into a table and find the mean for each period 4. Adjust the averages so that they sum to 4 (quarterly data) or 12
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/10/11 Sales Data for Video-Comp Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2004 20 12 47 60 2005 40 32 65 76 2006 56 50 85 100 2007 75 70 101 123 Table 4.3
Background image of page 2
3/10/11 Using the KPK Macros – Excel 2007
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/10/11 Enter the values in Column A, by year 2004 2005 2006 2007
Background image of page 4
3/10/11 Run the Decomposition Macro
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/10/11 The Seasonal sheet - Determining the seasonal indexes
Background image of page 6
3/10/11 Determining the Seasonal Indexes
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/10/11 Determining the seasonal indexes
Background image of page 8
3/10/11 Put the ratios into a table
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/10/11 Find the average for each time period
Background image of page 10
Adjust the averages The averages need to be adjusted so that their sum is 4 for quarterly data and 12 for monthly data Let SUM be the sum of the averages Here, SUM is .870 + .708 + 1.190 +
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/09/2011 for the course DSCI 2710 taught by Professor Hossain during the Fall '08 term at North Texas.

Page1 / 27

Chapter 4 - Part 2 - Section 4.5 Measuring Seasonality The...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online