Hi,
I need your help to analyze my survey data on employee satisfaction with the online performance management system. Please find the attached questionnaire and let me know how I could analyze the same.
Thank you, Akanksha Pandey
From India
Acknowledge(0)
Amend(0)
I need your help to analyze my survey data on employee satisfaction with the online performance management system. Please find the attached questionnaire and let me know how I could analyze the same.
Thank you, Akanksha Pandey
From India
Acknowledge(0)Amend(0)
Hello Akanksha. Congratulations on creating such a comprehensive survey. What I do is input the data into an Excel spreadsheet.
SD=1
D =2
N =3
A =4
SA=5
For each question, I create formulae that calculate:
1. average score for question (shows overall satisfaction)
2. standard distribution for each question (shows variability)
I then create an Excel bar chart that displays average response for each question. I then create formulae that strip out the N responses and count (SD + D) and (A + SA) and display these in another chart.
With this second chart, for each question the red component shows (SD + D) whilst the green component shows (A + SA). This chart shows responses from people who have a definite opinion, something that computing the average does not show you.
If you group the questions into three to six question types (e.g., System, Goal setting, HR Service, etc), then you can also provide summary results for each group of questions.
That's the quantitative analysis. I then do a qualitative analysis, where I present the summary results to groups of employees and facilitate a discussion on what works well and what could be improved. The full report is then presented to management for an action plan to be drawn up.
I hope this helps.
Les Allan
Author: Managing Change in the Workplace
www.businessperform.com
From Australia, Glen Waverley
Acknowledge(0)Amend(0)
10SD=1
D =2
N =3
A =4
SA=5
For each question, I create formulae that calculate:
1. average score for question (shows overall satisfaction)
2. standard distribution for each question (shows variability)
I then create an Excel bar chart that displays average response for each question. I then create formulae that strip out the N responses and count (SD + D) and (A + SA) and display these in another chart.
With this second chart, for each question the red component shows (SD + D) whilst the green component shows (A + SA). This chart shows responses from people who have a definite opinion, something that computing the average does not show you.
If you group the questions into three to six question types (e.g., System, Goal setting, HR Service, etc), then you can also provide summary results for each group of questions.
That's the quantitative analysis. I then do a qualitative analysis, where I present the summary results to groups of employees and facilitate a discussion on what works well and what could be improved. The full report is then presented to management for an action plan to be drawn up.
I hope this helps.
Les Allan
Author: Managing Change in the Workplace
www.businessperform.com
From Australia, Glen Waverley
Acknowledge(0)Amend(0)
Hi Allen,
Could you please guide me about Performance appraisal latest trend in Australian Market.
Akhter Sayeed
CEO
NAM Consultant,India
[
quote=les2allan;463198]Hello Akanksha. Congratulations on creating such a comprehensive survey. What I do is input the data into an Excel spreadsheet.
SD=1
D =2
N =3
A =4
SA=5
For each question, I create formulae that calculate:
1. average score for question (shows overall satisfaction)
2. standard distribution for each question (shows variability)
I then create an Excel bar chart that displays average response for each question. I then create formulae that strip out the N responses and count (SD + D) and (A + SA) and display these in another chart.
With this second chart, for each question the red component shows (SD + D) whilst the green component shows (A + SA). This chart shows responses from people who have a definite opinion, something that computing the average does not show you.
If you group the questions into three to six question types (e.g., System, Goal setting, HR Service, etc), then you can also provide summary results for each group of questions.
That's the quantitative analysis. I then do a qualitative analysis, where I present the summary results to groups of employees and facilitate a discussion on what works well and what could be improved. The full report is then presented to management for an action plan to be drawn up.
I hope this helps.
Les Allan
Author: Managing Change in the Workplace
www.businessperform.com[/quote]
From India, Raipur
Acknowledge(0)Amend(0)
Could you please guide me about Performance appraisal latest trend in Australian Market.
Akhter Sayeed
CEO
NAM Consultant,India
[
quote=les2allan;463198]Hello Akanksha. Congratulations on creating such a comprehensive survey. What I do is input the data into an Excel spreadsheet.
SD=1
D =2
N =3
A =4
SA=5
For each question, I create formulae that calculate:
1. average score for question (shows overall satisfaction)
2. standard distribution for each question (shows variability)
I then create an Excel bar chart that displays average response for each question. I then create formulae that strip out the N responses and count (SD + D) and (A + SA) and display these in another chart.
With this second chart, for each question the red component shows (SD + D) whilst the green component shows (A + SA). This chart shows responses from people who have a definite opinion, something that computing the average does not show you.
If you group the questions into three to six question types (e.g., System, Goal setting, HR Service, etc), then you can also provide summary results for each group of questions.
That's the quantitative analysis. I then do a qualitative analysis, where I present the summary results to groups of employees and facilitate a discussion on what works well and what could be improved. The full report is then presented to management for an action plan to be drawn up.
I hope this helps.
Les Allan
Author: Managing Change in the Workplace
www.businessperform.com[/quote]
From India, Raipur
Acknowledge(0)Amend(0)
Hi Akanksha,
Kindly search the CiteHR site and view the various postings I have made. With due respect to Allen, I would suggest that you calculate the median value and the percentiles rather than the average and standard deviation. The data you collect is categorical; hence, the average may not be the correct yardstick. However, if there is no difference between the mean and the median, then you could proceed with using the average.
Like Allen mentioned, you can group them. To accomplish this (i.e., develop a shorter number of constructs from the various variables), you need to conduct a Factor Analysis. You can refer to [Principal Components and Factor Analysis](http://www.statsoft.com/textbook/stfacan.html).
You have not stated how many respondents have answered your questionnaire.
Have a nice day.
Narasimhan
---
Hi,
I need your help to analyze my survey data on employee satisfaction with the online performance management system. Please find the attached questionnaire and let me know how I could analyze the same.
Thank you,
Akanksha Pandey
From United Kingdom
Acknowledge(0)Amend(0)
Kindly search the CiteHR site and view the various postings I have made. With due respect to Allen, I would suggest that you calculate the median value and the percentiles rather than the average and standard deviation. The data you collect is categorical; hence, the average may not be the correct yardstick. However, if there is no difference between the mean and the median, then you could proceed with using the average.
Like Allen mentioned, you can group them. To accomplish this (i.e., develop a shorter number of constructs from the various variables), you need to conduct a Factor Analysis. You can refer to [Principal Components and Factor Analysis](http://www.statsoft.com/textbook/stfacan.html).
You have not stated how many respondents have answered your questionnaire.
Have a nice day.
Narasimhan
---
Hi,
I need your help to analyze my survey data on employee satisfaction with the online performance management system. Please find the attached questionnaire and let me know how I could analyze the same.
Thank you,
Akanksha Pandey
From United Kingdom
Acknowledge(0)Amend(0)
Please note that my name is Les Allan and not “Allen”
“Could you please guide me about Performance appraisal latest trend in Australian Market.
Akhter Sayeed”
Hello Akhter. My experience shows more organizations going for a software performance management solution. On top of that, organizations are moving away from “attitude” scores to 360 degree competency feedback and the setting and tracking of measurable employee goals. However, this is not specific to Australia, but more general for the western countries.
“I would suggest that you calculate the median value and the percentiles rather than the average and standard deviation.
Narasimhan”
Narasimhan, you make a point. No two metrics will tell the whole story and it is somewhat of a compromise when selecting metrics. Yes, the data is categorical and an integer may seem appropriate. But if the median is 3, the median value will not reveal whether there are more 1s and 2s on the low side than 4s and 5s on the high side. This is where the average value can reveal more than the median.
The disadvantage that you rightly point out of using the average is to some extent mitigated by the standard deviation value. This value indicates the variability of the results, something that the median does not reveal. If you mean by “percentiles” reporting the percentage of respondents responding with each of the ratings, then this fills in nicely for the standard deviation. However, reporting percentile figures for each and every question makes for a long report – a report for which many managers may not want to find the time to read and understand. That's what I mean; each measure that you use has its own advantages and disadvantages. Thanks Narasimhan for your thoughtful contribution.
Les Allan
Author: Training Evaluation Toolkit
www.businessperform.com
From Australia, Glen Waverley
Acknowledge(0)Amend(0)
“Could you please guide me about Performance appraisal latest trend in Australian Market.
Akhter Sayeed”
Hello Akhter. My experience shows more organizations going for a software performance management solution. On top of that, organizations are moving away from “attitude” scores to 360 degree competency feedback and the setting and tracking of measurable employee goals. However, this is not specific to Australia, but more general for the western countries.
“I would suggest that you calculate the median value and the percentiles rather than the average and standard deviation.
Narasimhan”
Narasimhan, you make a point. No two metrics will tell the whole story and it is somewhat of a compromise when selecting metrics. Yes, the data is categorical and an integer may seem appropriate. But if the median is 3, the median value will not reveal whether there are more 1s and 2s on the low side than 4s and 5s on the high side. This is where the average value can reveal more than the median.
The disadvantage that you rightly point out of using the average is to some extent mitigated by the standard deviation value. This value indicates the variability of the results, something that the median does not reveal. If you mean by “percentiles” reporting the percentage of respondents responding with each of the ratings, then this fills in nicely for the standard deviation. However, reporting percentile figures for each and every question makes for a long report – a report for which many managers may not want to find the time to read and understand. That's what I mean; each measure that you use has its own advantages and disadvantages. Thanks Narasimhan for your thoughtful contribution.
Les Allan
Author: Training Evaluation Toolkit
www.businessperform.com
From Australia, Glen Waverley
Acknowledge(0)Amend(0)
Thanks Narsimhan for your valuable suggesstions. It is really of immense help to me.I have even attached the questionnaire. Please review it and offer your suggesstions.
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
Dear Allan, I request you to review my report oosted under the thread Project Report and offer your suggesstions on the same.
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
hi akansha........... i am also searching sum material to do employee satisfaction survey....... can u please help me out in this Regards khushi
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee Satisfaction Survey[1].doc