Hi guys,
I'm a newbie after a steer please.
I've got a 1000+ employee HR data file e.g. as per the picture attached.
What I'm trying to do is e.g. create a scatter graph of each employee's promotional progress over time of employment. To then plot a linear regression line through it to show an average it would take for e.g. a new grade 3 to become a grade 7. I think this would lean towards scatter plots X being time of months and y by salary grade.
The issue I think is an employee can have several jobs in their career, I'd want to see that on a graph with all their points of movement - it could be e.g. 6 different positions in their time. I've got over a thousand employees to plot.
Struggling for ideas, can you please point me in the right direction!?
Looking forward to hearing from you,
Samir
I'm a newbie after a steer please.
I've got a 1000+ employee HR data file e.g. as per the picture attached.
What I'm trying to do is e.g. create a scatter graph of each employee's promotional progress over time of employment. To then plot a linear regression line through it to show an average it would take for e.g. a new grade 3 to become a grade 7. I think this would lean towards scatter plots X being time of months and y by salary grade.
The issue I think is an employee can have several jobs in their career, I'd want to see that on a graph with all their points of movement - it could be e.g. 6 different positions in their time. I've got over a thousand employees to plot.
Struggling for ideas, can you please point me in the right direction!?
Looking forward to hearing from you,
Samir