Description This activity is based on the material you learned in Unit 18, Time Series Analysis. You will

Description

This activity is based on the material you learned in Unit 18, Time Series Analysis.

You will also need to be familiar with the material from lab 19 as you will need to use Excel to complete this activity.

The logbook activity must be written up in the form of a brief report so that it can be printed and handed into the student office at the end of the module. This report should be no more than 2 pages long.

Tasks

A n analyst has just completed an investigation into the sales of a computer software application over the past four years. The results are shown in the table below.

Year	Quarter	Sales (000’s)
	1	20
2005	2	24
	3	24
	4	30
	1	24
2006	2	30
	3	28
	4	40

Year	Quarter	Sales (000’s)
	1	26
2007	2	32
	3	31
	4	40
	1	29
2008	2	35
	3	33
	4	44

Produce a Time Series plot of the data i n Excel.
Use Excel to calculate a centered moving average.

s4. The forecast for the trend for quarter 4 of 2009 is calculated to be 42.52. Use your results to produce a seasonally adjusted forecast for quarter 4 of 2009.

Price: $5.19

Solution: The downloadable solution consists of 3 pages, 219 words and 5 charts.
Deliverable: Word Document