Les2allan
Managing Director
Nashbramhall
Learning & Teaching Fellow (retired)
Rajeev Verma
Hr Professional
+2 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Attachment 33370Hi
I need your help to analyze my syrvey data on employee satisfaction eith the online performance management system. Please find the attached questionnaire and let me know how could i analyze the same
Thank you,
Akanksha Pandey

Attached Files
 Membership is required for download. Create An Account First PMS questionnaire.doc (87.0 KB, 1303 views)

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

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

Hi Akanksha,
Kindly search CiteHR site and see the various postings I have done.
With due respects to Allen, I would suggest that you calculate the median value and the percentiles rather than the average and standard deviation. The data that you collect are categorical and, hence, average may not be the correct yardstick. However, if there is no difference between the mean and the median then you could.
Like Allen says, you can group them. In order to do that (i.e., develop shorter number of constructs from the various variables) you need to conduct a Factor Analysis Principal Components and Factor Analysis
You also have not stated how may respondents have answered your questionaire.
Have a nice day.
Narasimhan

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

All is forgiven. :)
Les Allan
Author: Managing Change in the Workplace

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.
Dear Allan, I request you to review my report oosted under the thread Project Report and offer your suggesstions on the same.
hi akansha........... i am also searching sum material to do employee satisfaction survey....... can u please help me out in this Regards khushi
Hi Khushi,
i will forwarding you the questionnaire. Please find the attached document of the same and let me know in detail what all factors are you targetting. The attachement sent was found on CiteHR only. I am sure it will help you.

Attached Files
 Membership is required for download. Create An Account First Employee Satisfaction Survey.pdf (43.2 KB, 297 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.