XYZ Corp.'s # of Management Safety Walks By Month and Corresponding # of Recordables

Month / Year # of Walks #Recordables

Jan 2014	23	6
Feb	20	7
March	16	5
April	15	10
May	20	10
June	13	12
July	12	10
August	15	7
September	20	9
October	23	8
November	15	10
December	10	23
Jan 2015	25	22
Feb	37	28
March	30	12
April	28	14
May	27	13
June	25	12
July	25	11
August	31	8
Sept	37	12
Oct	32	11
Nov	20	6
Dec	18	5

1. Calculate the following for each set (column) of data:
   1. Mean
   2. Median
   3. Mode
   4. Range
   5. Standard Deviation
2. Calculate the correlation coefficient between # of recordables and # of management walks.
3. Construct statistical process control chart for each set of data.
4. Can you reach any conclusions about the effectiveness of management walks?
5. What might you do further statistically investigate the effectiveness of management walks?