Prepare a scatter plot between “Days absent” and “Hours of Overtime” by using Excel. Do you find any correlation between these data? How does this analysis results inform your managerial decisions?
Do you find any correlation between these data? How does this analysis results inform your managerial decisions?
Develop two separate histograms for hours of overtime and days absent. How do the data appear to be distributed?
| Employee | Hours of Overtime | Days Absent |
| 1 | 243 | 3 |
| 2 | 126 | 2 |
| 3 | 86 | 0 |
| 4 | 424 | 6 |
| 5 | 236 | 3 |
| 6 | 128 | 0 |
| 7 | 0 | 0 |
| 8 | 126 | 2 |
| 9 | 324 | 3 |
| 10 | 118 | 0 |
| 11 | 62 | 0 |
| 12 | 128 | 3 |
| 13 | 460 | 6 |
| 14 | 135 | 1 |
| 15 | 118 | 1 |
| 16 | 260 | 2 |
| 17 | 0 | 1 |
| 18 | 126 | 1 |
| 19 | 234 | 2 |
| 20 | 246 | 3 |
| 21 | 120 | 1 |
| 22 | 80 | 0 |
| 23 | 112 | 1 |
| 24 | 237 | 3 |
| 25 | 129 | 2 |
| 26 | 24 | 1 |
| 27 | 36 | 0 |
| 28 | 128 | 2 |
| 29 | 246 | 3 |
| 30 | 326 | 6 |
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
