Satisfaction Survey Response Scale Analysis

Description

The objective of this project is to evaluate the response format used in some questions of the citizen perception survey.

Information about the data used

The data used was released by Strategic Plan of Juárez as part of an open data initiative. The data is originally available in Excel format (.xlsx) or as a database for SPSS (.sav).

Data cleaning

To perform the report, data was imported directly from the .sav file using the haven package. Converting the data to .csv using Microsoft Excel or SPSS resulted in poor data conversion due to the complexity of the information in those formats. In this project we focused on questions Q57 to Q64, in which participants rated on a scale from one to ten their satisfaction level with the following services:

• Water.

• Electric power.

• Public lighting.

• Semi-massive and traditional public transport.

• Garbage collection.

• Road signage and traffic lights.

• Availability of green areas and public space.

• Streets and paving.

Descriptive report

The Así Estamos Juárez 2022 report presented satisfaction averages with the quality of public services. In addition, the report includes averages by district, as well as comparisons with previous years.

Method and results

This analysis examined whether the 10-point satisfaction scale could be effectively reduced to fewer response options without losing essential information. The methodology involved creating reduced scales (5-point and 7-point) from the original 10-point responses and comparing their distributions visually through histograms.

Conclusion

The analysis suggests that for most public services evaluated, a reduced scale maintains the essential distribution characteristics of citizen responses, potentially improving survey efficiency and response consistency.

References

Data source: Strategic Plan of Juárez - Citizen Perception Survey 2022