Telemarketing company relies heavily on casual workers and per se they continually require to monitor and plan for turnover. They gather quarterly data on employee turnover (resignations) for a 3 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
|
Questions:
i) Use linear regression to recognize trend in firm's turnover.
ii) Based on these results, would you explain turnover as increasing or decreasing?
iii) By using this data and incorporating seasonal effects, predict quarterly turnover for 2010.
iv) Explain relative impact of trend and seasonal effects on this forecast