Are there any fabulous statisticians/mathematicians among us?

[Holdingmynerve]

I have a problem to solve and don't really know where to start.

I have a monthly rota which lists all the staff at work on each day. I have reduced this down to their grades. So for example: 50A, 25B, 10C, 2D.

The next day I could have 40A, 30B, 5C, 2D.

I have a months worth of this data.

I also have how the team performed that day - target of 90%. So this is shown as a percentage for the day. However.....I also have the amount of clients that called/visited that day.

So three lots of data. Mix of staff/performance/client numbers.

I would like (if this is even possible) to work out which mix of staff = higher performance and which mix of staff doesn't work so well.

Is this something which would be possible at all? I can't even think where to start, I'm having a complete mental block!

Thanks

Presuming you must be talking about some form of urgent/emergency care where you don’t control the input of patients? Is there a large degree of variation on patient numbers day to day (i’be got in mind Friday night in A&E here).

Is staff behaviour likely to be a factor? When demand is high they shift up a gear, when it is lower they relax a bit, spend more time with each patient? So the relationship you would expect to see between patient numbers and performance doesn’t exist?

When demand is high they shift up a gear, when it is lower they relax a bit, spend more time with each patient

The psychology behind the data and performance.

This is why data driven exercises are problematic - as they take the human element out (looking at you, schools)