Data Analysis for
Community Organizations

Graves_Text_Exercise_Manual_2023_A.pdf

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

 Google Drive

 Box Drive

 One Drive

Lab 2B-1: Using the VLOOKUP Technique to Combine Data Sets

US Census and EPA Data

Google Drive

Box Drive

One Drive

Lab 2B-2: Using the MERGE Technique to Combine Data Sets

US Census and EPA Data

Google Drive

Box Drive

One Drive

Lab 2B-3: Data Management Joining Data with a Pivot Table (Optional)

US Census and EPA Data

Google Drive

Box Drive

One Drive

Exercise 3-A: Describing Your Community with Descriptive Statistics

California Taxes by ZIP Code: 1992-2017

Google Drive

Box Drive

One Drive

Exercise 3-B: Calculating Percentiles and Z-Scores

California Free and Reduced School Mean Program 2018-2019 

Google Drive

Box Drive

One Drive

Exercise 4-A: T-Tests: Comparing Age and Ethnicity in Arrest Data Using LAPD Data

LAPD_Arrest_Data_2015_2020.xlsx

Google Drive

Box Drive

One Drive

Exercise 5A: Calculating Correlation Coefficients – Environmental Data

Cal Enviro Screen Data (filtered)

Google Drive

Box Drive

One Drive

Exercise 5B: Analyzing the Effect of Fast-Food Accessibility on Childhood Fitness Levels in Los Angeles with Regression.


Fast Food Fitness - Regression Data

Google Drive

Box Drive

One Drive