MParmar
1

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

From India, Vadodara
Attached Files (Download Requires Membership)
File Type: xls Employee_Satisfaction_Qs.xls (38.0 KB, 3674 views)

Autumn Jane
137

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

From Singapore, Singapore
Attached Files (Download Requires Membership)
File Type: xls ESI Calucation.xls (23.5 KB, 2231 views)

MParmar
1

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

From India, Vadodara
Mahr
477

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...
From India, Bangalore
Autumn Jane
137

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

From Singapore, Singapore
Attached Files (Download Requires Membership)
File Type: pdf ESI Cross-Departments Comparison.pdf (10.4 KB, 822 views)
File Type: pdf ESI Cross-Departments Sectional Comparison.pdf (10.3 KB, 519 views)
File Type: pdf ESI Sectional Comparison.pdf (10.2 KB, 509 views)
File Type: pdf OCS Sample Report.pdf (108.6 KB, 847 views)

nashbramhall
1624

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.

From United Kingdom
MParmar
1

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

From India, Vadodara
MParmar
1

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

From India, Vadodara
Autumn Jane
137

Dear Mahesh Re-attaching the sample report as per your request. Regards Autumn Jane
From Singapore, Singapore
Attached Files (Download Requires Membership)
File Type: ppt ESS Sample Report.ppt (411.0 KB, 984 views)

pari.nerurkar
19

Hello The attached excel sheet and word document will be of help. Thank you Regards Pari
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Employee Satisfaction Q Rev Sample Template.xls (41.5 KB, 2111 views)
File Type: doc Reference Work.doc (27.0 KB, 1220 views)

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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.