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?
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
|