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
Regards
Sara:icon9:
From India, Bangalore
Regards
Sara:icon9:
From India, Bangalore
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
From India, Bangalore
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
1624How 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
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
From India, Bangalore
Hi,
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.
regrds
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.
regrds
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 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 you...as little as Rs 10,000. ...you 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...
rgds
From India, Bangalore
rgds
From India, Bangalore
Hi,
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 them...do study further on Research Methods if you want to embark into a journey of greater data crunching.
Best Luck
From India
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 them...do study further on Research Methods if you want to embark into a journey of greater data crunching.
Best Luck
From India
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Emp satisfaction survey.doc