Unit 4 Coursework

Unit 4 Coursework

Student’s Name

Institution

Data Analysis: Descriptive Statistics and Assumption Testing

The analysis of the data established that health and safety matters are key issues for Sun Coast workers. It is also pointed that there are significant correlations between the lost time hours and safety training expenditure. The study also established that there is relationship between health and safety of workers and the performance of Sun Coast. The study also established that Sun Coast also works around the clock to offer a better working environment for all workers through elimination of substances which can hinder growth of workers. The data analysis is represented on the tables below.

Frequency distribution table

It is a chart, which provides the summary of values and their charts on the table.

Descriptive Statistics Analysis

The descriptive statistic is regarded as the basic feature of data in a study. It provides the mean, mode, median and standard deviation. The mean, mode, media and standard deviation is obtained as illustrated in the table below.

Column1

Column2

Mean

63.66290704

Mean

36.05781174

Standard Error

1.29748924

Standard Error

0.547442611

Median

68.224587

Median

36.089061

Mode

79.43

Mode

31.92666

Standard Deviation

15.78463787

Standard Deviation

6.659926806

Sample Variance

249.1547926

Sample Variance

44.35462506

Kurtosis

-1.024398771

Kurtosis

-1.325145342

Skewness

-0.246301829

Skewness

0.136789913

Range

66.1409

Range

23.034936

Minimum

26.75474

Minimum

24.407484

Maximum

92.89564

Maximum

47.44242

Sum

9422.110242

Sum

5336.556138

Count

148

Count

148

Confidence Level (95.0%)

2.564141412

Confidence Level (95.0%)

1.081874305

The study identified six problems as some of the major concerns for Sun Coast. The first major concern is job site particle pollution affecting the health of employees. It also reported that Sun Coast suffers from high job lose and this could be as a result of poor working condition. Though respirators are needed in certain environment, the particulate matter (PM) differs in size and mostly depends on the job site and project which are being undertaken. There are also other issues such as safety training effectiveness, sound level exposure, new employee training and lead exposure which senior management must address.

Regression analysis

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.057185425

R Square

0.003270173

Adjusted R Square

-0.003556744

Standard Error

6.67176012

Observations

148

ANOVA

df

SS

MS

F

Significance F

Regression

1

21.32195

21.32195

0.479012

0.48997

Residual

146

6498.808

44.51238

Total

147

6520.13

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

34.52175714

2.286143

15.10044

1.26E-31

30.00355

39.03997

30.00355

39.03997

X Variable 1

0.024127937

0.034862

0.692107

0.48997

-0.04477

0.093026

-0.04477

0.093026

It is means that there a relationship between particulate matter size and employee sick days because of the p. value is 0.48997. It means that the hypothesis is accepted. It is also obtained that there a predictive relationship between safety training expenditure and lost time hours?

Cumulative Analysis

Bin

Frequency

Cumulative %

Bin

Frequency

Cumulative %

24.407

0

0.00%

More

127

85.81%

24.407

0

0.00%

42.519

5

89.19%

25.770

0

0.00%

41.574

3

91.22%

25.770

0

0.00%

34.771

2

92.57%

25.909

0

0.00%

36.034

2

93.92%

25.909

0

0.00%

26.854

1

94.59%

26.854

1

0.68%

29.291

1

95.27%

26.854

0

0.68%

29.689

1

95.95%

27.003

0

0.68%

38.849

1

96.62%

27.003

0

0.68%

42.947

1

97.30%

27.073

0

0.68%

44.608

1

97.97%

27.073

0

0.68%

45.473

1

98.65%

27.352

0

0.68%

46.746

1

99.32%

27.352

0

0.68%

47.442

1

100.00%

27.451

0

0.68%

24.407

0

100.00%

27.451

0

0.68%

24.407

0

100.00%

27.550

0

0.68%

25.770

0

100.00%

27.550

0

0.68%

25.770

0

100.00%

27.899

0

0.68%

25.909

0

100.00%

27.899

0

0.68%

25.909

0

100.00%

28.088

0

0.68%

26.854

0

100.00%

28.088

0

0.68%

27.003

0

100.00%

29.291

1

1.35%

27.003

0

100.00%

29.291

0

1.35%

27.073

0

100.00%

29.390

0

1.35%

27.073

0

100.00%

29.390

0

1.35%

27.352

0

100.00%

29.689

1

2.03%

27.352

0

100.00%

29.689

0

2.03%

27.451

0

100.00%

29.977

0

2.03%

27.451

0

100.00%

29.977

0

2.03%

27.550

0

100.00%

30.027

0

2.03%

27.550

0

100.00%

30.027

0

2.03%

27.899

0

100.00%

30.027

0

2.03%

27.899

0

100.00%

30.037

0

2.03%

28.088

0

100.00%

30.037

0

2.03%

28.088

0

100.00%

30.037

0

2.03%

29.291

0

100.00%

30.236

0

2.03%

29.390

0

100.00%

30.236

0

2.03%

29.390

0

100.00%

30.345

0

2.03%

29.689

0

100.00%

30.345

0

2.03%

29.977

0

100.00%

30.703

0

2.03%

29.977

0

100.00%

30.703

0

2.03%

30.027

0

100.00%

31.051

0

2.03%

30.027

0

100.00%

31.051

0

2.03%

30.027

0

100.00%

31.051

0

2.03%

30.037

0

100.00%

31.081

0

2.03%

30.037

0

100.00%

31.081

0

2.03%

30.037

0

100.00%

31.240

0

2.03%

30.236

0

100.00%

31.240

0

2.03%

30.236

0

100.00%

31.240

0

2.03%

30.345

0

100.00%

31.509

0

2.03%

30.345

0

100.00%

31.509

0

2.03%

30.703

0

100.00%

31.927

0

2.03%

30.703

0

100.00%

31.927

0

2.03%

31.051

0

100.00%

31.927

0

2.03%

31.051

0

100.00%

31.927

0

2.03%

31.051

0

100.00%

31.927

0

2.03%

31.081

0

100.00%

31.927

0

2.03%

31.081

0

100.00%

32.374

0

2.03%

31.240

0

100.00%

32.374

0

2.03%

31.240

0

100.00%

32.404

0

2.03%

31.240

0

100.00%

32.404

0

2.03%

31.509

0

100.00%

33.120

0

2.03%

31.509

0

100.00%

33.120

0

2.03%

31.927

0

100.00%

33.339

0

2.03%

31.927

0

100.00%

33.339

0

2.03%

31.927

0

100.00%

33.339

0

2.03%

31.927

0

100.00%

34.771

2

3.38%

31.927

0

100.00%

34.771

0

3.38%

31.927

0

100.00%

34.771

0

3.38%

32.374

0

100.00%

34.771

0

3.38%

32.374

0

100.00%

36.034

2

4.73%

32.404

0

100.00%

36.034

0

4.73%

32.404

0

100.00%

36.034

0

4.73%

33.120

0

100.00%

36.144

0

4.73%

33.120

0

100.00%

36.144

0

4.73%

33.339

0

100.00%

36.144

0

4.73%

33.339

0

100.00%

36.144

0

4.73%

33.339

0

100.00%

36.850

0

4.73%

34.771

0

100.00%

36.850

0

4.73%

34.771

0

100.00%

36.850

0

4.73%

34.771

0

100.00%

36.850

0

4.73%

36.034

0

100.00%

37.198

0

4.73%

36.034

0

100.00%

37.198

0

4.73%

36.144

0

100.00%

37.198

0

4.73%

36.144

0

100.00%

37.198

0

4.73%

36.144

0

100.00%

37.745

0

4.73%

36.144

0

100.00%

37.745

0

4.73%

36.850

0

100.00%

37.745

0

4.73%

36.850

0

100.00%

37.745

0

4.73%

36.850

0

100.00%

38.203

0

4.73%

36.850

0

100.00%

38.203

0

4.73%

37.198

0

100.00%

38.203

0

4.73%

37.198

0

100.00%

38.203

0

4.73%

37.198

0

100.00%

38.670

0

4.73%

37.198

0

100.00%

38.670

0

4.73%

37.745

0

100.00%

38.670

0

4.73%

37.745

0

100.00%

38.670

0

4.73%

37.745

0

100.00%

38.849

1

5.41%

37.745

0

100.00%

38.849

0

5.41%

38.203

0

100.00%

38.849

0

5.41%

38.203

0

100.00%

38.849

0

5.41%

38.203

0

100.00%

41.574

3

7.43%

38.203

0

100.00%

41.574

0

7.43%

38.670

0

100.00%

41.574

0

7.43%

38.670

0

100.00%

41.574

0

7.43%

38.670

0

100.00%

42.519

5

10.81%

38.670

0

100.00%

42.519

0

10.81%

38.849

0

100.00%

42.519

0

10.81%

38.849

0

100.00%

42.519

0

10.81%

38.849

0

100.00%

42.947

1

11.49%

41.574

0

100.00%

42.947

0

11.49%

41.574

0

100.00%

42.947

0

11.49%

41.574

0

100.00%

42.947

0

11.49%

42.519

0

100.00%

44.170

0

11.49%

42.519

0

100.00%

44.170

0

11.49%

42.519

0

100.00%

44.170

0

11.49%

42.947

0

100.00%

44.170

0

11.49%

42.947

0

100.00%

44.409

0

11.49%

42.947

0

100.00%

44.409

0

11.49%

44.170

0

100.00%

44.409

0

11.49%

44.170

0

100.00%

44.409

0

11.49%

44.170

0

100.00%

44.558

0

11.49%

44.170

0

100.00%

44.558

0

11.49%

44.409

0

100.00%

44.558

0

11.49%

44.409

0

100.00%

44.558

0

11.49%

44.409

0

100.00%

44.608

1

12.16%

44.409

0

100.00%

44.608

0

12.16%

44.558

0

100.00%

44.608

0

12.16%

44.558

0

100.00%

44.608

0

12.16%

44.558

0

100.00%

45.055

0

12.16%

44.558

0

100.00%

45.055

0

12.16%

44.608

0

100.00%

45.055

0

12.16%

44.608

0

100.00%

45.055

0

12.16%

44.608

0

100.00%

45.473

1

12.84%

45.055

0

100.00%

45.473

0

12.84%

45.055

0

100.00%

45.473

0

12.84%

45.055

0

100.00%

45.473

0

12.84%

45.055

0

100.00%

45.503

0

12.84%

45.473

0

100.00%

45.503

0

12.84%

45.473

0

100.00%

45.503

0

12.84%

45.473

0

100.00%

45.503

0

12.84%

45.503

0

100.00%

46.746

1

13.51%

45.503

0

100.00%

46.746

0

13.51%

45.503

0

100.00%

46.746

0

13.51%

45.503

0

100.00%

46.746

0

13.51%

46.746

0

100.00%

47.442

1

14.19%

46.746

0

100.00%

47.442

0

14.19%

46.746

0

100.00%

More

127

100.00%

47.442

0

100.00%

Data for the company:

Sun Coast Closing

Sun Coast Return

30-Jun-2019

82.780

47.442

31-May-2019

78.510

45.503

30-Apr-2019

74.520

45.473

31-Mar-2019

70.640

44.558

28-Feb-2019

73.950

44.170

31-Jan-2019

69.910

42.947

31-Dec-2018

72.390

46.746

30-Nov-2018

71.230

45.055

31-Oct-2018

69.230

44.608

30-Sep-2018

71.410

44.409

31-Aug-2018

71.240

42.519

31-Jul-2018

74.790

41.574

30-Jun-2018

72.870

38.670

31-May-2018

69.300

38.203

30-Apr-2018

71.820

37.198

31-Mar-2018

72.310

38.849

28-Feb-2018

76.390

37.745

31-Jan-2018

78.870

36.850

31-Dec-2017

80.340

36.144

30-Nov-2017

79.430

34.771

31-Oct-2017

77.630

36.034

30-Sep-2017

75.250

33.339

31-Aug-2017

75.800

31.927

31-Jul-2017

83.730

31.240

30-Jun-2017

82.810

31.927

31-May-2017

79.650

30.027

30-Apr-2017

87.400

30.037

31-Mar-2017

85.910

31.051

28-Feb-2017

82.320

32.404

31-Jan-2017

81.660

32.374

31-Dec-2016

82.410

31.081

30-Nov-2016

78.650

33.120

31-Oct-2016

73.390

31.509

30-Sep-2016

72.400

30.345

31-Aug-2016

71.810

29.291

31-Jul-2016

77.350

27.451

30-Jun-2016

74.370

27.352

31-May-2016

77.430

27.550

30-Apr-2016

73.890

27.899

31-Mar-2016

74.920

29.689

29-Feb-2016

70.140

29.390

31-Jan-2016

78.670

28.088

31-Dec-2015

85.530

27.073

30-Nov-2015

79.430

25.909

31-Oct-2015

76.730

24.407

30-Sep-2015

72.720

25.770

31-Aug-2015

75.080

26.854

31-Jul-2015

87.087

27.003

30-Jun-2015

84.670

30.236

31-May-2015

84.631

29.977

30-Apr-2015

88.390

30.703

31-Mar-2015

92.896

45.503

28-Feb-2015

91.424

45.473

31-Jan-2015

88.848

44.558

31-Dec-2014

85.187

44.170

30-Nov-2014

80.284

42.947

31-Oct-2014

80.045

46.746

30-Sep-2014

74.883

45.055

31-Aug-2014

80.881

44.608

31-Jul-2014

83.298

44.409

30-Jun-2014

80.443

42.519

31-May-2014

81.149

41.574

30-Apr-2014

78.474

38.670

31-Mar-2014

77.022

38.203

28-Feb-2014

74.257

37.198

31-Jan-2014

73.829

38.849

31-Dec-2013

77.380

37.745

30-Nov-2013

77.400

36.850

31-Oct-2013

75.669

36.144

30-Sep-2013

70.825

34.771

31-Aug-2013

72.447

36.034

31-Jul-2013

73.809

33.339

30-Jun-2013

68.806

31.927

31-May-2013

66.499

31.240

30-Apr-2013

73.053

31.927

31-Mar-2013

67.643

30.027

28-Feb-2013

66.907

30.037

31-Jan-2013

64.102

31.051

31-Dec-2012

61.844

47.442

30-Nov-2012

59.368

45.503

31-Oct-2012

57.438

45.473

30-Sep-2012

55.469

44.558

31-Aug-2012

54.444

44.170

31-Jul-2012

57.219

42.947

30-Jun-2012

52.813

46.746

31-May-2012

49.133

45.055

30-Apr-2012

51.689

44.608

31-Mar-2012

49.829

44.409

29-Feb-2012

49.163

42.519

31-Jan-2012

50.386

41.574

31-Dec-2011

48.954

38.670

30-Nov-2011

47.144

38.203

31-Oct-2011

49.004

37.198

30-Sep-2011

45.304

38.849

31-Aug-2011

47.960

37.745

31-Jul-2011

49.004

36.850

30-Jun-2011

52.018

36.144

31-May-2011

50.347

34.771

30-Apr-2011

53.420

36.034

31-Mar-2011

52.117

33.339

28-Feb-2011

52.823

31.927

31-Jan-2011

52.177

31.240

31-Dec-2010

50.496

31.927

30-Nov-2010

48.019

30.027

31-Oct-2010

48.636

30.037

30-Sep-2010

50.894

31.051

31-Aug-2010

50.028

32.404

31-Jul-2010

52.276

32.374

30-Jun-2010

48.377

31.081

31-May-2010

51.093

33.120

30-Apr-2010

58.194

31.509

31-Mar-2010

55.986

30.345

28-Feb-2010

53.629

29.291

31-Jan-2010

52.943

27.451

31-Dec-2009

54.554

27.352

30-Nov-2009

52.515

27.550

31-Oct-2009

51.968

27.899

30-Sep-2009

51.471

29.689

31-Aug-2009

45.752

29.390

31-Jul-2009

42.569

28.088

30-Jun-2009

38.789

27.073

31-May-2009

34.950

25.909

30-Apr-2009

34.920

24.407

31-Mar-2009

34.542

25.770

28-Feb-2009

29.639

26.854

31-Jan-2009

26.755

27.003

31-Dec-2008

28.744

30.236

30-Nov-2008

33.906

29.977

31-Oct-2008

40.082

30.703

30-Sep-2008

42.390

45.503

31-Aug-2008

42.171

45.473

31-Jul-2008

39.535

44.558

30-Jun-2008

39.953

44.170

31-May-2008

42.091

42.947

30-Apr-2008

44.608

46.746

31-Mar-2008

41.584

45.055

29-Feb-2008

41.902

44.608

31-Jan-2008

49.133

44.409

31-Dec-2007

58.781

42.519

30-Nov-2007

59.328

41.574

31-Oct-2007

61.168

38.670

30-Sep-2007

56.085

38.203

31-Aug-2007

54.852

37.198

31-Jul-2007

53.967

38.849

30-Jun-2007

54.952

37.745

31-May-2007

55.101

36.850

30-Apr-2007

52.475

36.144

31-Mar-2007

49.989

34.771

References

BIBLIOGRAPHY

Denyer, B., & Jaina, ,. J. (2017). How do they manage? A qualitative study of the realities of

middle and front-line management work in health care. NIHR Journals Library , 2-15.

P, M., Kumar, S., Lizarondo, L., & Baldock, K. (2015). Debriefing about the challenges of

working in a remote area: A qualitative study of Australian allied health professionals' perspectives on clinical supervision. Journal of health and safety issues , 2-15.