Statistic Help
aljdra
assignment_2.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 above data set, calculate the 1)mean,2) median, 3) mode, 4) standard deviation, 5) range, 6) and 7)varience for the number of injuries that occured per month.
B) 1) create 2 columns and calculate the monthly and cumulative injury incidence rates per 100 employees 2)Chart the frequency of injuries by month and the incidence rates on seperate charts.
