-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex_creation.Rmd
More file actions
53 lines (43 loc) · 2.42 KB
/
index_creation.Rmd
File metadata and controls
53 lines (43 loc) · 2.42 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
---
title: "Creating Marginalization and Socioeconomic Hardship Index"
author: "Census Team"
date: "3/9/2022"
output: html_document
---
```{r setup, include=FALSE}
knitr::opts_chunk$set(echo = TRUE)
```
We decided to create an index to allow people interested in the topic to get a
quick overview of some important demographic factors when looking at Divvy data.
Working with our mentor and using his paper "Investigating socio-spatial
differences between solo ridehailing and pooled rides in diverse communities" as
a jumping off point. We variable correlations and used Exploratory Factor Analysis
with a factor loading cutoff of .3, a single factor, and no rotations to create an index.
Factor analysis is a way to reduce data, so instead of having to look at 10
different heatmaps, each colored by a single demographic variable, we use factor
analysis to create an index that represents all 10 variables with a single number.
We use demographic variables that represent various aspects of marginalization
and/or socioeconomic hardship (like the percent of population that is disabled
or the unemployment rate) and used a factor loading cutoff of .3.
Factor loadings measure how strongly related each of our demographic variables
is to our index variable and range from -1 to 1. The sign on the factor tells
us the direction of the factor variable’s relationship with our overall index
variable, positive is they tend to rise and fall together (like our index and
percent of families living below the poverty level) and negative is they rise
and fall in opposite directions (like our index and median income).
The selected variables were:
-Percent of the population that is not non-hispanic/latino white
-Percent of the population that is disabled
-Percent of the population that do not have access to a vehicle
-Percentage of households that are renting
-Percentage of households with a single parent
-Percentage of households with no internet access
-Unemployment Percentage
-Percentage of the population with a bachelors degree
-Percentage of families living below the poverty line
-Median income
Some variables we tried that were not selected due to low factor loadings were:
-Percentage of the population that do not speak English "very well"
-Percentage of commuters that commute by car, truck, or van
We used this factor analysis to create an index and scaled the index between 0 and 1
to be used in our analysis and visualizations.