Data Analysis for
Community Organizations
About this textbook and lab manual:
This text was written for people seeking to lead community organizations. In some ways, it is a guidebook for a crash course in statistics for people working in urban, non-profit environments. The course is taught in Los Angeles, so the examples are largely from Southern California.
The language is purposefully informal and statistical jargon is avoided as much as is possible. It is not a book for statisticians. It fails, purposefully, to fully address many of the footnotes and caveats that mark rigorous statistical testing. Instead, this text paints with broad strokes to bring readers up-to-speed on the basics of data analysis.
People who read this text and complete the exercises should be able to speak with consultants, grant agents, the media, and the public about their community using terminology that describes both the community and the dynamics that create conditions affecting urban communities.
After reading the text and completing the accompanying assignments, you should know how to do some basic data analysis on real-world data. More importantly, should know “what to ask for” if you need outside help with your data analysis.
The text is divided into four parts:
1. Gathering and processing quantitative data about urban environments.
2. Measuring and describing aspects of urban communities using basic statistics.
3. Characterizing differences, needs, and changes in urban communities.
4. Measuring the level of association among urban characteristics as well as cause-and-effect.
Lab Datasets and Tutorial Videos
Lab 1A: Downloading Community Data from the US Census Website
No data is provided. Your task is to download it yourself.
Lab 1B: Downloading Data from the Los Angeles Police Department
No data is provided. Your task is to download it yourself.
Lab 2A: Data Management with Pivot Tables and Census Data
Los Angeles County, American Community Survey, Census Tracts
Lab 2B-1: Using the VLOOKUP Technique to Combine Data Sets
US Census and EPA Data
Lab 2B-2: Using the MERGE Technique to Combine Data Sets
US Census and EPA Data
Lab 2B-3: Data Management Joining Data with a Pivot Table (Optional)
US Census and EPA Data
Exercise 3-A: Describing Your Community with Descriptive Statistics
California Taxes by ZIP Code: 1992-2017
Exercise 3-B: Calculating Percentiles and Z-Scores
California Free and Reduced School Mean Program 2018-2019
Exercise 4-A: T-Tests: Comparing Age and Ethnicity in Arrest Data Using LAPD Data
LAPD_Arrest_Data_2015_2020.xlsx
Exercise 5A: Calculating Correlation Coefficients – Environmental Data
Cal Enviro Screen Data (filtered)
Exercise 5B: Analyzing the Effect of Fast-Food Accessibility on Childhood Fitness Levels in Los Angeles with Regression.
Fast Food Fitness - Regression Data