Research Data Paper Selection
Marcos Carmona
2025-10-22
DISCLAIMER: This is a resubmission of the original assignment. The first time, I only sent in the data set and answered the questions, but did not provide the R Markdown link. Here is that submission.
This data set is a mixture of several data sets: the Point in Time Count Data for 2023, CoC Funding Award Data for 2022, System Performance Measures for 2022, and Housing Inventory Count for 2022. All of these reports come from HUD and I pulled variables from each to create this mixed report. Each report has a data dictionary that can be used.
All PPI and PHI have been cleaned from this data set.
All reports are public available on hud.data.gov
This data set has enough variables and observations for a healthy analysis. Specifically, there are 34 variables and 382 observations. It is likely that this data set will have less variables in its final form.
This data is relevant to the study of Public Administration as it studies the effect of federal funding on the rates of homelessness across the nation.
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.5.2 ✔ tibble 3.3.0
## ✔ lubridate 1.9.4 ✔ tidyr 1.3.1
## ✔ purrr 1.1.0
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorslibrary(ggplot2)
library(readxl)
Quant_Data_Set <- read_excel("C:/Users/carmo/Downloads/Quant Data Set.xlsx")
View(Quant_Data_Set)
summary(Quant_Data_Set)## CoC Number CoC Name CoC Category
## Length:382 Length:382 Length:382
## Class :character Class :character Class :character
## Mode :character Mode :character Mode :character
##
##
##
##
## Numerated CoC Category Count Types Total Amount Awarded
## Min. :1.000 Length:382 Min. : 3775
## 1st Qu.:2.000 Class :character 1st Qu.: 1056235
## Median :2.000 Mode :character Median : 2701802
## Mean :2.474 Mean : 7301051
## 3rd Qu.:3.000 3rd Qu.: 6826987
## Max. :4.000 Max. :157847769
## NA's :4 NA's :4
## Total CoC Planning Total HMIS Total Joint TH-RRH Total PSH
## Min. : 3775 Min. : 4675 Min. : 16800 Min. : 7776
## 1st Qu.: 44248 1st Qu.: 62704 1st Qu.: 183168 1st Qu.: 638120
## Median : 89490 Median : 117968 Median : 327748 Median : 1799715
## Mean : 203952 Mean : 200370 Mean : 812735 Mean : 4918289
## 3rd Qu.: 221374 3rd Qu.: 238205 3rd Qu.: 959394 3rd Qu.: 4493120
## Max. :1250000 Max. :2389260 Max. :5874778 Max. :126435112
## NA's :18 NA's :62 NA's :212 NA's :19
## Total RRH Total Safe Haven Total SSO Total TH
## Min. : 18936 Min. : 73949 Min. : 10000 Min. : 15559
## 1st Qu.: 259212 1st Qu.: 163241 1st Qu.: 92113 1st Qu.: 128384
## Median : 754588 Median : 327384 Median : 239700 Median : 217562
## Mean : 1624612 Mean : 381822 Mean : 437907 Mean : 448915
## 3rd Qu.: 1606551 3rd Qu.: 440976 3rd Qu.: 546348 3rd Qu.: 450153
## Max. :19252751 Max. :1105623 Max. :3039058 Max. :4567185
## NA's :66 NA's :354 NA's :108 NA's :270
## Total UFA Overall Homeless Sheltered Total Homeless
## Min. : 13038 Min. : 55.0 Min. : 13
## 1st Qu.: 68150 1st Qu.: 337.5 1st Qu.: 210
## Median :171232 Median : 680.0 Median : 423
## Mean :257370 Mean : 3440.3 Mean : 2090
## 3rd Qu.:337149 3rd Qu.: 1577.0 3rd Qu.: 950
## Max. :795975 Max. :653104.0 Max. :396494
## NA's :368 NA's :3 NA's :3
## Unsheltered Homeless Total Support Funding (CoC Planning + HMIS + SSO + UFA)
## Min. : 0.0 Min. : 0
## 1st Qu.: 50.0 1st Qu.: 133110
## Median : 169.0 Median : 322671
## Mean : 1350.5 Mean : 692981
## 3rd Qu.: 515.5 3rd Qu.: 815605
## Max. :256610.0 Max. :6678318
## NA's :3 NA's :4
## Total ES Funding (ES SH, TH) Total PH Funding (PSH + RRH) Total Support 2021
## Min. : 0 Min. : 0 Min. : 0
## 1st Qu.: 0 1st Qu.: 825221 1st Qu.: 121154
## Median : 113732 Median : 2051412 Median : 307277
## Mean : 526811 Mean : 6081260 Mean : 637996
## 3rd Qu.: 448144 3rd Qu.: 5616718 3rd Qu.: 724140
## Max. :9095741 Max. :142073710 Max. :6678318
## NA's :4 NA's :4 NA's :4
## Total ES 2021 Total PH 2021 Total Amount Awarded 2021
## Min. : 0 Min. : 0 Min. : 3446
## 1st Qu.: 0 1st Qu.: 805616 1st Qu.: 1045003
## Median : 98647 Median : 2070237 Median : 2550329
## Mean : 508871 Mean : 5843872 Mean : 6990739
## 3rd Qu.: 437263 3rd Qu.: 5598866 3rd Qu.: 6753820
## Max. :11372872 Max. :137305161 Max. :155356351
## NA's :4 NA's :4 NA's :4
## Total Support Funding Difference Total ES Funding Difference
## Min. :-1586002 Min. :-2277131
## 1st Qu.: 0 1st Qu.: 0
## Median : 7104 Median : 0
## Mean : 54985 Mean : 17940
## 3rd Qu.: 66794 3rd Qu.: 0
## Max. : 1930166 Max. : 2191472
## NA's :4 NA's :4
## Total PH Funding Difference Total Overall Funding Difference
## Min. :-22432119 Min. :-2.257e+07
## 1st Qu.: -11538 1st Qu.:-8.678e+02
## Median : 0 Median : 4.953e+04
## Mean : 237388 Mean : 3.103e+05
## 3rd Qu.: 368573 3rd Qu.: 4.677e+05
## Max. : 19461077 Max. : 2.211e+07
## NA's :4 NA's :4
## Overall Homelessness in 2022 Overall Sheltered Homelessness in 2022
## Min. : 20 Min. : 16.0
## 1st Qu.: 300 1st Qu.: 205.5
## Median : 606 Median : 397.0
## Mean : 1531 Mean : 919.9
## 3rd Qu.: 1386 3rd Qu.: 863.5
## Max. :65111 Max. :58385.0
## NA's :4 NA's :4
## Overall Unsheltered Homelessness in 2022 Total Amounts of Beds in 2022
## Min. : 0.0 Min. : 53.0
## 1st Qu.: 36.0 1st Qu.: 581.2
## Median : 123.0 Median : 1147.5
## Mean : 610.9 Mean : 2759.5
## 3rd Qu.: 464.0 3rd Qu.: 2669.2
## Max. :45878.0 Max. :103069.0
## NA's :4 NA's :4
## Total Persons Exited PH to permanent destinations or Remained in PH for 6+ months (measure excludes PH-RRH) in 2022
## Min. : 0.0
## 1st Qu.: 119.8
## Median : 333.0
## Mean : 867.9
## 3rd Qu.: 856.0
## Max. :15817.0
## NA's :6hist(Quant_Data_Set$`Numerated CoC Category`)
plot(Quant_Data_Set$`Numerated CoC Category`,Quant_Data_Set$`Overall Homeless`)
cor(Quant_Data_Set$`Total Amount Awarded`,Quant_Data_Set$`Numerated CoC Category`)## [1] NA