help with case

orangepink
StressData_AnswerGuide.xlsx

Stress Data

Stress Index Pay Gender Stress reduction program Team diversity Supervisor conflict Tenure
3.34 8.14 1 1 4 5 425 dummy
4.35 11.43 1 1 6 3 76 Stress Index Pay Gender Stress reduction program Team diversity Supervisor conflict Tenure
5.87 6.63 1 1 1 3 319 Mean 4.10 8.04 0.64 0.63 3.59 3.43 216.41
4.56 7.11 0 1 1 3 246 Median 4.05 7.93 1.00 1.00 4.00 3.00 206.50
4.86 8.72 0 1 2 3 162 Mode 4.35 5.86 1 1 2 3 109
4.08 8.80 1 1 2 5 53 SD 1.03 1.85 0.48 0.49 2.02 2.07 139.09
4.86 8.22 1 1 5 0 193 CV 25% 23% 76% 78% 56% 60% 64%
2.13 6.89 1 1 0 2 261 Max 6.04
3.44 9.00 0 1 2 6 83 Min 1.36
2.93 4.07 1 1 3 2 282
4.80 9.40 1 1 6 2 240 Attended Not Attended
5.49 7.05 1 1 6 6 449 SD 0.9770511444 1.0287312239
5.46 5.95 1 1 5 1 147 n 50 30
4.55 6.54 1 1 5 5 335 SE 0.138175898 0.1878197656
3.93 6.75 0 1 0 1 366 z 1.96 1.96
4.05 9.68 1 1 3 7 109 Mean 3.89 4.46
4.58 8.31 1 1 4 0 80 UCL 4.16502476 4.8231267407
2.97 5.72 1 1 5 2 152 LCL 3.62337524 4.0868732593
3.81 7.41 1 1 3 2 358
2.69 9.76 0 1 0 6 224
4.48 9.38 0 1 3 3 47
3.60 9.11 1 1 1 5 431
3.42 7.39 1 1 1 5 308
3.45 7.24 1 1 6 7 221
4.23 7.58 1 1 5 1 454
3.16 7.19 0 1 3 7 480
4.35 7.83 0 1 5 4 35
4.04 8.51 1 1 2 1 385
1.61 7.94 1 1 2 7 423
4.15 7.91 1 1 4 4 427
4.92 10.74 1 1 2 1 5
4.96 11.03 0 1 6 7 291
1.49 4.90 0 1 1 5 174
4.79 9.17 0 1 3 3 340
3.97 8.25 1 1 3 2 20
4.34 8.43 1 1 6 6 315
4.50 7.33 1 1 5 6 352
3.24 5.96 1 1 7 2 86
3.97 5.86 1 1 4 3 185
4.21 8.90 1 1 2 1 199
3.30 8.11 0 1 2 0 260
3.82 9.84 1 1 0 3 219
3.77 7.02 1 1 6 3 15
1.36 3.38 0 1 0 2 80
3.98 10.01 1 1 1 6 384
3.18 6.58 0 1 1 3 68
3.14 6.62 0 1 5 4 36
5.07 7.43 0 1 7 5 200
3.23 5.56 1 1 3 1 410
4.23 8.36 1 1 1 2 159
3.64 6.88 0 0 2 5 109
4.00 7.54 1 0 7 0 298
5.94 11.12 0 0 4 5 180
5.41 8.26 1 0 3 4 60
4.72 8.92 0 0 3 1 306
3.12 5.47 1 0 2 0 89
6.03 10.45 1 0 3 3 356
5.66 11.57 1 0 5 6 355
3.15 5.86 1 0 2 6 437
3.49 7.56 0 0 7 2 73
3.45 4.63 0 0 3 0 245
4.01 10.51 0 0 6 6 22
5.54 8.85 0 0 4 4 321
4.26 9.79 1 0 4 5 119
4.65 9.64 1 0 2 2 21
3.52 7.88 1 0 6 4 295
3.11 6.61 1 0 4 3 134
4.14 5.47 0 0 1 4 11
6.04 12.34 1 0 4 2 85
3.87 10.42 0 0 2 3 466
4.00 5.75 0 0 5 3 384
4.16 7.07 1 0 7 3 125
5.55 9.56 1 0 7 2 279
3.25 7.55 1 0 4 4 116
6.00 8.76 0 0 6 1 111
4.35 7.00 1 0 6 1 131
3.73 8.61 1 0 4 5 328
5.45 12.10 0 0 4 3 61
5.97 10.05 1 0 5 7 14
3.44 7.72 0 0 5 7 213