I'm looking to demonstrate an association between penalty (overtime) payments and absenteeism. The dependent variable is overtime payments ($0-$highval) for a shift, and the outcome variable is 'was the person absent (sick) for this shift'.
What I'd planned on doing was: a) bucketing overtime payments eg. $0, $0-$50, $51-$100 etc. then b) correlating this against '% of shifts with this particular penalty payment where the person 'went sick' (which is a variable that is either 'at work' or 'absent'.
So the output would be something like:
Penalty %Shifts not worked
0 13%
50+ 6%
100+ 3%
This obviously requires a bit of data pre-processing, which I'd like to avoid in taking a first-pass look at the issue.
Is there a more basic/efficient way to test a continuous dependent variable like $ overtime paid and a 0-1 variable (at work/absent)? Thanks guys Pete