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 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
Join/Merge two tables with a common identifier. Convert numeric data to text.
Text to column tool.
VLOOKUP tool.
EPA and Census Data
Join two tables with a common identifier. Convert numeric data to text.
Text to column tool.
Pivot Table.
EPA and Census Data
Basic Descriptive Statistics
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
Calculating Percentiles and Z-Scores Part 1
Calculate Percentile Score and Z scores in Excel
California School Enrollment & Lunch Data
Calculating T-Tests
One Sample & Two Sample Difference of Means t-Tests
Paired Samples Difference of Means t-Test
Los Angeles Police Department Data
Calculating Correlation Coefficients
Calculate Pearon’s R Correlation Coefficient &
Spearman’s Rho for Ranked Data (skewing)
California EPA Data
Linear
Regression
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