Tutorials and Files

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 LinkDemonstrated SkillsFiles
Downloading Census DataDownloading Demographic Data from US Census Website (2021) None
Download Data from Los Angeles Data HubDownloading Data from Government Data Hub (Los Angeles Police Department Data)None
Convert Vertical Data to Horizontal with Pivot TableConvert Vertical Download Data to Horizontally Arranged Data with Pivot TableLA County Ethnicity Data- Census Tracts, 2010

Excel
VLOOKUP Tool to Join DatasetsJoin/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 column tool.
Pivot Table.
EPA and Census Data
Excel
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 Pearon’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
Table of Tutorials with links to video tutorials, skills and datasets.