Hi there,
We are conducting a survey for one of our clients and need to analyze the results to determine the overall Public Satisfaction Rate as a percentage (%). The survey uses a 6-point scale ranging from 1, representing "Extremely Satisfied," to 6, representing "Don't know." An example Excel dataset is attached.
Could you please assist me in calculating the satisfaction percentage? Which formula should I use?
Thank you,
Mayssaa
From United Arab Emirates, Abu Dhabi
Acknowledge(0)
Amend(0)
We are conducting a survey for one of our clients and need to analyze the results to determine the overall Public Satisfaction Rate as a percentage (%). The survey uses a 6-point scale ranging from 1, representing "Extremely Satisfied," to 6, representing "Don't know." An example Excel dataset is attached.
Could you please assist me in calculating the satisfaction percentage? Which formula should I use?
Thank you,
Mayssaa
From United Arab Emirates, Abu Dhabi
Acknowledge(0)Amend(0)
To calculate the overall Public Satisfaction Rate from the 6-point scale survey, you can follow these steps:
1. Determine the total number of responses in your dataset.
2. Count the number of responses falling under each satisfaction level (from 1 to 6).
3. Calculate the total number of responses falling under "Extremely Satisfied" (1 on the scale).
4. Divide the total number of "Extremely Satisfied" responses by the total number of responses and multiply by 100 to get the satisfaction percentage.
5. The formula to calculate the satisfaction percentage is: (Number of "Extremely Satisfied" responses / Total number of responses) * 100.
For example, if you have 200 responses in total and 120 responses are "Extremely Satisfied," the calculation would be (120 / 200) * 100 = 60%. Therefore, the overall Public Satisfaction Rate would be 60%.
Ensure to adapt this formula to your specific dataset to accurately determine the satisfaction percentage.
From India, Gurugram
Acknowledge(0)Amend(0)
351. Determine the total number of responses in your dataset.
2. Count the number of responses falling under each satisfaction level (from 1 to 6).
3. Calculate the total number of responses falling under "Extremely Satisfied" (1 on the scale).
4. Divide the total number of "Extremely Satisfied" responses by the total number of responses and multiply by 100 to get the satisfaction percentage.
5. The formula to calculate the satisfaction percentage is: (Number of "Extremely Satisfied" responses / Total number of responses) * 100.
For example, if you have 200 responses in total and 120 responses are "Extremely Satisfied," the calculation would be (120 / 200) * 100 = 60%. Therefore, the overall Public Satisfaction Rate would be 60%.
Ensure to adapt this formula to your specific dataset to accurately determine the satisfaction percentage.
From India, Gurugram
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of 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 Survey[1].doc