{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 4 - Part 2

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

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

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

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

View Full Document
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
3/10/11 Using the KPK Macros – Excel 2007

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

View Full Document
3/10/11 Enter the values in Column A, by year 2004 2005 2006 2007
3/10/11 Run the Decomposition Macro

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

View Full Document
3/10/11 The Seasonal sheet - Determining the seasonal indexes
3/10/11 Determining the Seasonal Indexes

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

View Full Document
3/10/11 Determining the seasonal indexes
3/10/11 Put the ratios into a table

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

View Full Document
3/10/11 Find the average for each time period
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 +

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online