30 X14.30- construction absenteeism The construction industry in the Western Cape is very dependent upon reliable...

Transcribed Image Text:

30 X14.30- construction absenteeism The construction industry in the Western Cape is very dependent upon reliable labour to ensure that it meets its project deadlines and avoids incurring late-delivery penalties. The Construction Federation undertook an analysis of the absentecism levels amongst construction workers over the past six years. The number of man-days lost (based on the number of workers absent), aggregated quarterly, is summarised in the table below. Quarter Days lost 933 Q1 2006 Q2 865 Q3 922 04 864 Q1 2007 967 Q2 936 Q3 931 04 902 01 2008 892 Q2 845 03 907 04 801 Q1 2009 815 Q2 715 03 779 04 711 Q1 2010 822 Q2 856 03 762 04 722 Q1 2011 785 02 715 03 740 04 704 391 Applied Business Statistics (a) Lise Excel to conduct a time series year period. Identify seasonal indexes and produce a trendline of absentecism levels. Also construct a plot (using the Insert > Chart tab) of the actual time series and the seasonally adjusted trend estimates for the six years of historical data. sanalysis of absenteeism levels over the six- (b) Prepare seasonally adjusted trend estimates of absentecism levels for all quarters of 2012. (c) Present your findings in a brief management report. 30 X14.30- construction absenteeism The construction industry in the Western Cape is very dependent upon reliable labour to ensure that it meets its project deadlines and avoids incurring late-delivery penalties. The Construction Federation undertook an analysis of the absentecism levels amongst construction workers over the past six years. The number of man-days lost (based on the number of workers absent), aggregated quarterly, is summarised in the table below. Quarter Days lost 933 Q1 2006 Q2 865 Q3 922 04 864 Q1 2007 967 Q2 936 Q3 931 04 902 01 2008 892 Q2 845 03 907 04 801 Q1 2009 815 Q2 715 03 779 04 711 Q1 2010 822 Q2 856 03 762 04 722 Q1 2011 785 02 715 03 740 04 704 391 Applied Business Statistics (a) Lise Excel to conduct a time series year period. Identify seasonal indexes and produce a trendline of absentecism levels. Also construct a plot (using the Insert > Chart tab) of the actual time series and the seasonally adjusted trend estimates for the six years of historical data. sanalysis of absenteeism levels over the six- (b) Prepare seasonally adjusted trend estimates of absentecism levels for all quarters of 2012. (c) Present your findings in a brief management report.

Answer rating: 100% (QA)

1 Seasonality The repeating shortterm cycle in the series From the below graph we observed that the ... View the full answer