Data Analysis for Community Organizations

This page contains links to some of the videos and accompanying files for a few  of the video tutorials posted on my YouTube Channel.

VIDEO LINK

DEMONSTRATED SKILLS

FILES

Downloading Census Data

Downloading Demographic Data from US Census Website (2021)

None

Download Data from Los Angeles Data Hub

Downloading Data from Government Data Hub (Los Angeles Police Department Data)

None

Convert Vertical Data to Horizontal with Pivot Table

Convert Vertical Download Data to Horizontally Arranged Data with Pivot Table

LA County Ethnicity Data- Census Tracts, 2010

Excel

VLOOKUP Tool to Join Datasets

Join/Merge two tables with a common identifier. Convert numeric data to text.

Text to column tool.

VLOOKUP tool.

EPA and Census Data

Excel

Pivot Tables to Join Datasets

Join two tables with a common identifier. Convert numeric data to text.

Text to Columns tool.

Pivot Table.

EPA and Census Data

Basic Descriptive Statistics

Part 1

Part 2

Calculate Mean, Median, Standard Deviation, Skewness, etc. using formulas and Data Analysis too.

Create Simple Histogram of Data

California Income Tax data by ZIP Code

Excel

Calculating Percentiles and Z-Scores Part 1

Part 2

Calculate Percentile Score and Z-scores in Excel

California School Enrollment & Lunch Data

Excel

Calculating T-Tests

Part 1

Part 2

One Sample & Two Sample Difference of Means t-Tests

Paired Samples Difference of Means t-Test

Los Angeles Police Department Data

Excel

(large file)

Calculating Correlation Coefficients

Part 1

Part 2

Calculate Pearson’s R Correlation Coefficient &

Spearman’s Rho for Ranked Data (skewing)

California EPA Data

Excel

Linear

Regression

Part 1

Part 2

Creating a Linear Regression Model

Preparing Data for Regression

Interpreting Output Diagnostics

Los Angeles County Fast Food Data (Census) and California Dept. of Education Data

ZIP Code Level

Excel