Wondering if I can get steer on this question.
I have a dataset with the columns -date,employee id, task id, volume of work completed as percentage (float) for that task, time taken to complete that volume in hours. From this data, I calculated a metric called rate per hour(rph) which is volume/ time taken in hours.
So this is per day, per employee, per task rph.
An employee can work on any number is tasks in a day and he will log in what volume of work is completed for a particular task and time
Now I need to calculate best ( or ideal rph) for a team for a given task ( I.e rph per task)
I can’t use employee demographics for example the experience, as such data could take very long time to gather and is not practical
I tried modelling this problem as non parametric global mode estimation using kernel density.
I am wondering if there are any other methods ?
Any help is greatly appreciated. Thanks 🙏🏼