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
Acknowledge(0)
Amend(0)
1Many 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
Acknowledge(0)Amend(0)
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 satisfaction in ABC Company?
Example 2: Overall, I am satisfied with ABC Company as the place to work.
Regards,
Autumn Jane
From Singapore, Singapore
Acknowledge(0)Amend(0)
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 satisfaction in ABC Company?
Example 2: Overall, I am satisfied with ABC Company as the place to work.
Regards,
Autumn Jane
From Singapore, Singapore
Acknowledge(0)Amend(0)
Dear Autumn,
Thank you for your reply. Now, I understand how to calculate because in steps I was confused with Total Score and Maximum total score. As per your suggestion, I will add questions related to overall satisfaction.
How do we analyze data after the calculation of ESI? Can we compare Total Respondents with Department Respondents? Can we use a chi-square test? If so, what are the Observed value and Expected value?
I am very thankful to you.
Regards,
Mahesh
From India, Vadodara
Acknowledge(0)Amend(0)
Thank you for your reply. Now, I understand how to calculate because in steps I was confused with Total Score and Maximum total score. As per your suggestion, I will add questions related to overall satisfaction.
How do we analyze data after the calculation of ESI? Can we compare Total Respondents with Department Respondents? Can we use a chi-square test? If so, what are the Observed value and Expected value?
I am very thankful to you.
Regards,
Mahesh
From India, Vadodara
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Mahesh,
I have attached more analysis samples for your reference and should answer your other questions. While the chi-square test may be used, it is not common. Specific criteria must be met in order to conduct a chi-square test, which include quantitative data, adequate sample size, etc.
Regards, Autumn Jane
From Singapore, Singapore
Acknowledge(0)Amend(0)
I have attached more analysis samples for your reference and should answer your other questions. While the chi-square test may be used, it is not common. Specific criteria must be met in order to conduct a chi-square test, which include quantitative data, adequate sample size, etc.
Regards, Autumn Jane
From Singapore, Singapore
Acknowledge(0)Amend(0)
Dear Mahesh,
The first step to follow when raising a query is to 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 on 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
Acknowledge(0)Amend(0)
The first step to follow when raising a query is to 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 on 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
Acknowledge(0)Amend(0)
Dear Autumn,
Thanks for your suggestions and samples. These samples give me direction to make a report. The OCS SAMPLES REPORT.PDF file contains unrecognized characters, making it unreadable. If possible, please send the same file to maheshantra@gmail.com.
With Regards,
Mahesh
From India, Vadodara
Acknowledge(0)Amend(0)
Thanks for your suggestions and samples. These samples give me direction to make a report. The OCS SAMPLES REPORT.PDF file contains unrecognized characters, making it unreadable. If possible, please send the same file to maheshantra@gmail.com.
With Regards,
Mahesh
From India, Vadodara
Acknowledge(0)Amend(0)
Dear Mahesh Re-attaching the sample report as per your request. Regards Autumn Jane
From Singapore, Singapore
Acknowledge(0)Amend(0)
From Singapore, Singapore
Acknowledge(0)Amend(0)
Hello The attached excel sheet and word document will be of help. Thank you Regards Pari
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Sir,
My name is Pratik Sarwadnya. I also want to calculate ESI, but I cannot understand how to calculate it. Specifically, I cannot understand the formula: (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). What does the star mark indicate? Is it for multiplication?
Another query I have is regarding "TOTAL (pt. d) * 5." Could you please explain what "pt. d" refers to?
Regards,
Pratik Sarwadnya
sarwadnya.pratik@yahoo.in
From India
Acknowledge(0)Amend(0)
My name is Pratik Sarwadnya. I also want to calculate ESI, but I cannot understand how to calculate it. Specifically, I cannot understand the formula: (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). What does the star mark indicate? Is it for multiplication?
Another query I have is regarding "TOTAL (pt. d) * 5." Could you please explain what "pt. d" refers to?
Regards,
Pratik Sarwadnya
sarwadnya.pratik@yahoo.in
From India
Acknowledge(0)Amend(0)
Dear Pratik,
Please download the Excel table attached by Autumn Jane. I am sure the table clearly explains what is done. You are correct, the asterisk sign in 5*5 represents multiplication. By clicking on different cells in the table, it will show you what has been done.
From United Kingdom
Acknowledge(0)Amend(0)
Please download the Excel table attached by Autumn Jane. I am sure the table clearly explains what is done. You are correct, the asterisk sign in 5*5 represents multiplication. By clicking on different cells in the table, it will show you what has been done.
From United Kingdom
Acknowledge(0)Amend(0)
Dear PARI.NERURKAR,
Please explain to me the Excel sheet calculation attached here. I didn't understand the numbers mentioned corresponding to each question. Usually, employees will tick on the appropriate columns to show their satisfaction level. For example, for the first question, if they strongly agree, then they will tick on the 1st column, and the points should be four. However, in the first column, it is mentioned as 1. What is the rating for that particular question?
Binoy M George (binoy.mgeorge@gmail.com)
From United%20Arab%20Emirates, Sharjah
Acknowledge(0)Amend(0)
Please explain to me the Excel sheet calculation attached here. I didn't understand the numbers mentioned corresponding to each question. Usually, employees will tick on the appropriate columns to show their satisfaction level. For example, for the first question, if they strongly agree, then they will tick on the 1st column, and the points should be four. However, in the first column, it is mentioned as 1. What is the rating for that particular question?
Binoy M George (binoy.mgeorge@gmail.com)
From United%20Arab%20Emirates, Sharjah
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Employee Satisfaction analysis[1][1]. chr.xls
Employee Satisfaction Survey[1].doc