Skip to content

SEIE Survey Analysis Project Summary

TaniaKhan04 edited this page Jan 9, 2024 · 4 revisions

Background Info

On June 19, 2020 the City of Los Angeles issued executive directive #27 to address racial equality within the city government. The Department of Neighborhood Empowerment conducted a survey with Neighborhood Council members to identify issues of social and economic inclusiveness and equity (SEIE) in the community.

Timeline: n/a

Partners: Empower LA, Department of Neighborhood Empowerment

Tools Used: Jupyter Notebook

Objective

The purpose of this project was to translate, analyze and summarize the data from the Social and Economic Inclusiveness and Equity (SEIE) Survey into meaningful and actionable insights.

Process

Demographic Information

  • The survey was distributed online between July 6, 2020 and July 13, 2020 to the emails of record with the Department. The survey was available in English, Spanish, Chinese, and Korean. Demographic questions related to participants' ethnicities and gender were also recorded.

Participant Ethnicity

participant_ethnicity

  • 54.6% of participants identified as White/Caucasian
  • 17.0% of participants identified as Latino/Hispanic
  • 14.5% of participants identified as Black/African American
  • 8.1% of participants identified as Asian/Pacific Islander
  • 5.7% of participants identified as Multiethnic

Participant Gender

participant_sex

Neighborhood Council Information

  • Of the 665 Neighborhood Council Board Members who responded to the survey, 575 wrote at least one open-ended response. All together, respondents submitted 3,107 open-ended survey responses, totaling a novel-length 110,981 words in all.

Neighborhood Council Areas

neighbourhood_council

  • The majority of respondents were part of the West Hills Neighborhood Council

Years of Membership in Neighborhood Councils Per Participant

nc_board_years

  • 35.8% of participants had been a part of their council for 2-4 years
  • 33.8% participants had been part of their council for 0-2 years

Thematic Analysis Findings

  • Thematic Analysis was used to find patterns and frequently used terminology in the survey responses. Particular attention was given to geographic and demographic trends in the language used.

  • The responses were then transferred into several Word Clouds, highlighting the most recurring words.

word_cloud_2

  • Housing and Homelessness was most important to all genders, except for Not Reported who felt that topics around Police were most important. 51% of Females vs 38% of Males resonated with issues surrounding Housing and Homelessness.

  • Across all genders, Safety and Emergency Preparedness and Environment and Infrastructure and Transport ranked lowest in issues respondents cared about (10% of Females brought up issues around Infrastructure and Transport and only 8% of Males brought up issues around Safety and Emergency Preparedness).

Deliverables

  • Documented results in Jupyter notebook
  • Visualizations of the Data Analysis were presented for client review

Links to Project Files

Clone this wiki locally