Observational Data Analysis
mhd
assignment_420.xlsxSheet1
| Month | # of Injuries | Hours |
| Jan | 5 | 345000 |
| Feb | 8 | 456789 |
| Mar | 9 | 398679 |
| Apr | 5 | 439990 |
| May | 4 | 417567 |
| Jun | 6 | 379988 |
| Jul | 7 | 434567 |
| Aug | 4 | 441253 |
| Sep | 8 | 441123 |
| Oct | 9 | 450023 |
| Nov | 5 | 443567 |
| Dec | 4 | 420989 |
| Jan | 5 | 350098 |
| Feb | 8 | 367854 |
| Mar | 9 | 399894 |
| Apr | 5 | 423875 |
| May | 4 | 439956 |
| Jun | 6 | 441019 |
| Jul | 7 | 439985 |
| Aug | 4 | 465231 |
| Sept | 8 | 459965 |
| Oct | 5 | 449908 |
| Nov | 6 | 439765 |
| Dec | 3 | 438567 |
A) For the data set provided, calculate the 1)mean,2) median, 3) mode, 4) standard deviation, 5) range, and 6) the varience.
B) Chart the frequency of injuries by month and the incidence rate per month on seperate charts.
C) From the work you completed, calculate the Upper and Lower Control Limits, using 2 SD instead of the traditional 3 SD. Apply this to a line chart to show the data (you have already done this), the Mean, and UCL and LCL.
