hi am new to this site. In my company we are conducting employee satisfaction survey and we made a questionnaire and also collected the data. can any body help how to consolidate it and analyse it. The qestionnaire is framed on parameters like a. Roles & responsibility .B. policies & prosedures. c.Training. d. Organization etc and few open ended question. I dnt know how consolidate and analyse it as each parameter contains minmum of 4 questions.pls help

From India, Bangalore
Learning & Teaching Fellow (retired)
Manager Hr
Training & Development, Performance Mgt
+3 Others
no we not done that.. am bit confused hw to do as it is a three scle rating...lke-10, 5and 1. where 10 stands for good, 5 for average and 1 for poor...
From India, Bangalore
Pl find attached the questionnaire.
From India, Bangalore

Attached Files (Download Requires Membership)
File Type: doc ESI format-New.doc (55.5 KB, 786 views)


Prepare a spreadsheet with the questions at the top, ie. columns and the individuals responding to the questions as rows. And enter the ratings given by them in the corresponding cells.
How many responses have you got?
It's a bit late to redesign the questionnaire. However, had you sought advice before, it could have been improved.

From United Kingdom

Dear Sara,
Do you have the soft copy of the received forms from the employees? If yes, forward the same to my e-mail id
If not, do as directed by the previous post and send me that spread sheet for analysis.

From India, Bangalore
Thanks a lot.The questionnaire was approved by the sr. managers. We are collecting the filled questioner. Iwill consolidate the data as suggested by u.and will share it....
From India, Bangalore

Once you have collected all the data put it in excel sheet columns for various question-response and rows for people responded..send it to me.
I have the ready formula and chart generation which you can use.

From India, Bangalore

hi all,
I am also in the same process of ESS in my organization. Can you all tell me that how I analyze the same as my organization doesn't want to float it outside the organiztion.
Can I have the format of the analysis.

From India, Delhi

I forgot to mention ..there are lot of SME service providers who can set it up online for you that comes with lot of analytical reports. No! I am not saying buy a software..just buy the service one time taht can cost little as Rs 10,000. may try them also..but your people must be able to have an access to the internet and must be able to take it online...

From India, Bangalore

1. Your Questionnaire is actually a 3-point scale no matter what you call the anchore (1,2,3 or 1,5,10) and actually represent the degree of separation from 'No' to 'Yes'
Hence you can safely code all your response to either 1,2,3 or stick to your anchores of 1,5,10 it dose not matter.
2. You can put code such as R1, R2, R3...etc in colums of Excel and put code for sample in 1st row. and you will have raw data.
3. Ensure that there are no missing data in any of the Qs otherwise do not include that in your analysis.
4. Aggregated score (Av. of R1-R12) will give you a score for employee's perception about her/his roles and Responsibilities...similalry you get a score for all the other parameters.
5. you can group your data dept-wise, level-wise as per your org. norms and tinker n see if the mean values change.
6. you can represent your data through charts (no. who respond to 1, nos who respond to 5, & nos who reponsd to 10)
7. Do a self study on how to calculate mean difference - i.e. if the mean on R&R for Exec is 3 and mean on R&R for Sups is 3.5 then is there a 'signifincant' difference between the two. Other wise 3.5>3 does not give you any meaningful analysis if the mean diff. is not significant and they actually are at the same level of perception.
8. there are host of possibilities of treating your data - but I guess from your responses you are at present not equipped to deal with study further on Research Methods if you want to embark into a journey of greater data crunching.
Best Luck

From India

If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of Such Discussions in Future - Please Register and Log In to Cite Community.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server