ExcelNewbe
New Member
- Joined
- Jan 26, 2011
- Messages
- 4
Hi everyone
I am in a bit of a pickle with some data i need to analyse. I have run an employee experience survey and have a spreadsheet with the info. Now i am trying to figure out how to analyse one part and i think i need extra brains!
So i have 11 factors that make up our employee experience (leadership, development, physical space etc) and i have asked staff a series of questions (using a ranking from 1-10) for each of these 11 categories. I then calculated the average for each of these 11 categories.
I also had a question that asked staff to rank the 11 categories in order of importance - now the tool i used only let staff rank the top 5. So i have this data.
What i would like to do is do an overlay of the 11 categories and how important they are. So essentially saying overall leadership got 60% satisfaction, development got 40% satisfaction, physical space got 30% satisfaction...and then compare that with the importance given to these same categories..so we might say:
leadership got 60% satisfaction and it's in the top 5 with 80% of staff saying it's important to them, development got 40% satisfaction and 75% of staff saying it's important to them, physical space got 30% satisfaction and 10% of staff saying it's important to them.
Is there a way i can overlay this data onto a graph? i am just not sure how to do that because it seems i am not comparing apples to apples.
hope this makes sense!
thank you
I am in a bit of a pickle with some data i need to analyse. I have run an employee experience survey and have a spreadsheet with the info. Now i am trying to figure out how to analyse one part and i think i need extra brains!
So i have 11 factors that make up our employee experience (leadership, development, physical space etc) and i have asked staff a series of questions (using a ranking from 1-10) for each of these 11 categories. I then calculated the average for each of these 11 categories.
I also had a question that asked staff to rank the 11 categories in order of importance - now the tool i used only let staff rank the top 5. So i have this data.
What i would like to do is do an overlay of the 11 categories and how important they are. So essentially saying overall leadership got 60% satisfaction, development got 40% satisfaction, physical space got 30% satisfaction...and then compare that with the importance given to these same categories..so we might say:
leadership got 60% satisfaction and it's in the top 5 with 80% of staff saying it's important to them, development got 40% satisfaction and 75% of staff saying it's important to them, physical space got 30% satisfaction and 10% of staff saying it's important to them.
Is there a way i can overlay this data onto a graph? i am just not sure how to do that because it seems i am not comparing apples to apples.
hope this makes sense!
thank you
