How To Calculate Employee Satisfaction Index? - XLS Download

Dear Friend,
Many of you confused it with Employee Satate Insurance. Please read thread properly and then jump. So once again I am posting it.

I find following formula on net to find ESI. But I don't understand How to use it?
I am a student of MBA(HR) 3-year evening programme and doing project on "Employee Satisfaction" for that I want to use this. Suggest If u have any other formula. I am using 5 scale format for questionnaire as per step 1.
1. How to calculate ESI?
a.There is a five-point scale in the questionnaire or survey from employee responses.
·Strongly Agree
·Agree
·Undecided
· Disagree
· Strongly Disagree.
b. You should remark number attached, include strongly agree (5) to strongly disagree (1).
c. The TOTAL SCORE RECEIVED is calculated = (total number of responses of 5 * 5)+(total number of responses of 4 * 4)+(total number of responses of 3 * 3)+(total number of responses of 2 * 2)+(total number of responses of 1 * 1)
Then, total number of questions with answers against each response is calculated (5, 4, 3, 2, and 1).
d. The total number of questions answered is calculated.
e. Calculate the MAXIMUM TOTAL SCORE which is the TOTAL (pt. d) * 5.
ESI = (TOTAL SCORE RECEIVED / MAXIMUM TOTAL SCORE) * 100
If anybody understand then explain it with example.

Is there any other formula for ESI calculation. I am attaching Qs herewith.

With Regards,
Mahesh

Hi Mahesh
Here is an example based on your explanation.
However, your questionnaire is missing the key overall satisfaction question which is usually used to calculate the ESI:
Example 1: On a scale of 1 (highest) to 5 (lowest), what is your overall job staisfaction in ABC Company? or
Example 2: Overall, I am satisfied with the ABC Company as the place to work.
Regards
Autumn Jane

Dear Autumn,
Thanks for ur reply.
Now I udestood how to calculate because in steps I confused with TotalScore and Maximum total score.
As per ur suggestion I will be add Qs related to overall satisfaction.
How to analyze data after calculation of ESI?
Can we copmare Total Respondent with Deparment Respodent ?
Can we use chi-square test? the what is Observed value and Expected value?
I am very thankful to you.
Regards,
Mahesh

Dear Mahesh,
You shall still go ahead with the search in this community for much more valuable suggestion.. There were lots of discussion happened before...

Dear Mahesh
I have attached more analysis sample for your reference and should answer your other questions.
While Chi-square test may be used but not common. Specific critieria must be met in order to chi-square test which include quantitative data, adequate simple size, etc.
Regards
Autumn Jane

Dear Mahesh
The first step to follow when raising a query is search the web. I know that it is easier to post a query at CiteHr, as people are willing to help.
a quick check of the web using Google would have led you to How to Use the Likert Scale in Statistical Analysis | eHow.com found at
Google
where more links can be found.
I am sure that I posted this or similar info at CiteHr.
Have a nice weekend.

Dear Autumn,
Thanks for your suggestions and samples.
These samples give me direction to make report.
OCS SAMPLES REPORT.PDF file containing unrecognised characters i.e nothing to be readable if possible send same file on maheshantra@gmail.com

With Regards,
Mahesh

Dear Super Moderator,
Thanks for your suggestion.
Before post in citehr.com I searched web and downloaded inforamation about Likert Scale and chi-square test and based on that I made my Qs using 5 scale method. Then I come to know about ESI formula. So for explanation I use citehr.com.
With Regards,
Mahesh

Dear Mahesh
Re-attaching the sample report as per your request.
Regards
Autumn Jane

Hello
The attached excel sheet and word document will be of help.
Thank you
Regards
Pari