We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Logbook activity 6

The best essay writers are ready to impress your teacher.
Make an order now!


Proceed

Tasks

GET EVEN A BETTER ESSAY WE WILL WRITE A CUSTOM
ESSAY SAMPLE ON
Logbook activity 6 TOPICS SPECIFICALLY FOR YOU

An 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)
Year
Quarter
Sales (000’s)
2005
1
20
2007
1
26
2
24
2
32
3
24
3
31
4
30
4
40
2006
1
24
2008
1
29
2
30
2
35
3
28
3
33
4
40
4
44

1. Produce a Time Series plot of the data in Excel.

2. Use Excel to calculate a centered moving average.

3. Using an additive model, calculate the seasonal components.

Page 2 Logbook Activity 6 Department of Economics and Statistics Middlesex University Business School

4. 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.

 

Share this Post!

Send a Comment

Your email address will not be published.

Kylie Garcia

Hi there, would you like to get such a paper? How about receiving a customized one?

Check it out