Predict quarterly turnover by incorporating seasonal effects

Reference no: EM1314063

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

Reference no: EM1314063

Questions Cloud

Prepare a bank reconciliation at july 31 : Prepare a bank reconciliation at July 31, 2007 and Journalize the adjusting entries at July 31 on the books of DeVries Company.

Computing pearson-s correlation coefficient : Compute Pearson's correlation coefficient between age and amount spent on this particular product.

Prepare a bank reconciliation : Preparation of Bank Reconciliation Statement and Prepare a bank reconciliation.

Impact of change from federal income tax to federal : The impact of changing from a federal income tax to a federal consumption tax would be:

Predict quarterly turnover by incorporating seasonal effects : By using this data and incorporating seasonal effects, predict quarterly turnover for 2010.

Which of the following are functions : Which of the following are functions? The two problems, i.e., 1 & 3, are multi part relations consider all parts when determining whether or not these relations are functions. Explain your reason for 1, 2, & 3.

Chi-square goodness of fit test : The chi-square goodness of fit test can be used when we:

Consumption tax on the loan able funds market graphically : Show the effect of moving to a consumption tax on the loan able funds market if people react favourably to the incentive to save. Choose which curve or curves you believe are affected.

Computation of adjusted cash balance : Computation of Adjusted Cash Balance - which the company had erroneously recorded in the accounting records as $40. The "adjusted cash balance" at June 30 should be?

User Account

All Pages