Hi! I have three columns of data:
- % Pay to Market Rate (Employees salary divided by a set market rate for that position)
- Years of experience (1 year, 2 year, 3 year, 4 year, 5 year) (where each employee is grouped into each category)
- Still with company (either Yes or No)
I have 2000 rows, where each row is an employee.
If I had the exact amount of time each person had been with the company (so the X axis might be 60 months instead of just 5 years), I could use a scatter plot where the X axis is years of experience and Y axis is % Pay, and I could make the dots either different colors or different sizes to indicate the binary choice of with company or not.
But the problem is that I only have 5 possible X axis choices so a scatter-plot wouldn't work (would just be 5 vertical lines of dots).
So my question: Given the data and assuming no additional data could be had is there a way to represent this data? The goal of a visual representation would be so that you could see at what % or what year of experience are most people leaving, so that you could theoretically pay those that are in that 'danger zone' a higher salary to retain them?
Thanks!
Bookmarks