A telemarketing firm relies heavily on the casual workers and as such they constantly require to monitor and plan for turnover. They collect quarterly data on employee turnover (resignations) for the three year period.
|
|
Q1
|
Q2
|
Q3
|
Q4
|
|
2006
|
48
|
68
|
56
|
31
|
|
2007
|
51
|
70
|
57
|
30
|
|
2008
|
52
|
71
|
59
|
32
|
|
2009
|
54
|
75
|
61
|
33
|
Required
1. Use linear regression to recognize the trend in firm's turnover.
2. Based upon these results, would you explain turnover as increasing or decreasing?
3. Using this data and incorporating seasonal effects, forecast quarterly turnover for the 2010.
4. Explain the relative impact of trend and seasonal effects on this forecast.