library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.2.1 ✔ readr 2.2.0
## ✔ forcats 1.0.1 ✔ stringr 1.6.0
## ✔ ggplot2 4.0.3 ✔ tibble 3.3.1
## ✔ lubridate 1.9.5 ✔ tidyr 1.3.2
## ✔ purrr 1.2.2
## ── 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 errors
library(readxl)
library(lmtest)
## Loading required package: zoo
##
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric
library(MASS)
##
## Attaching package: 'MASS'
## The following object is masked from 'package:dplyr':
##
## select
library(car)
## Loading required package: carData
##
## Attaching package: 'car'
## The following object is masked from 'package:dplyr':
##
## recode
## The following object is masked from 'package:purrr':
##
## some
texas_data <- read_excel("tx.counties.xlsx", sheet = "Additional Measure Data", skip = 1)
## New names:
## • `95% CI - Low` -> `95% CI - Low...5`
## • `95% CI - High` -> `95% CI - High...6`
## • `# Deaths` -> `# Deaths...28`
## • `95% CI - Low` -> `95% CI - Low...30`
## • `95% CI - High` -> `95% CI - High...31`
## • `# Deaths` -> `# Deaths...53`
## • `95% CI - Low` -> `95% CI - Low...55`
## • `95% CI - High` -> `95% CI - High...56`
## • `# Deaths` -> `# Deaths...78`
## • `95% CI - Low` -> `95% CI - Low...80`
## • `95% CI - High` -> `95% CI - High...81`
## • `95% CI - Low` -> `95% CI - Low...104`
## • `95% CI - High` -> `95% CI - High...105`
## • `95% CI - Low` -> `95% CI - Low...107`
## • `95% CI - High` -> `95% CI - High...108`
## • `95% CI - Low` -> `95% CI - Low...112`
## • `95% CI - High` -> `95% CI - High...113`
## • `95% CI - Low` -> `95% CI - Low...115`
## • `95% CI - High` -> `95% CI - High...116`
## • `# Deaths` -> `# Deaths...117`
## • `95% CI - Low` -> `95% CI - Low...119`
## • `95% CI - High` -> `95% CI - High...120`
## • `95% CI - Low` -> `95% CI - Low...144`
## • `95% CI - High` -> `95% CI - High...145`
## • `95% CI - Low` -> `95% CI - Low...151`
## • `95% CI - High` -> `95% CI - High...152`
## • `95% CI - Low` -> `95% CI - Low...154`
## • `95% CI - High` -> `95% CI - High...155`
## • `95% CI - Low` -> `95% CI - Low...180`
## • `95% CI - High` -> `95% CI - High...181`
## • `95% CI - Low` -> `95% CI - Low...185`
## • `95% CI - High` -> `95% CI - High...186`
## • `95% CI - Low` -> `95% CI - Low...189`
## • `95% CI - High` -> `95% CI - High...190`
## • `95% CI - Low` -> `95% CI - Low...213`
## • `95% CI - High` -> `95% CI - High...214`
## • `95% CI - Low` -> `95% CI - Low...216`
## • `95% CI - High` -> `95% CI - High...217`
## • `95% CI - Low` -> `95% CI - Low...220`
## • `95% CI - High` -> `95% CI - High...221`
## • `95% CI - Low` -> `95% CI - Low...224`
## • `95% CI - High` -> `95% CI - High...225`
## • `95% CI - Low` -> `95% CI - Low...231`
## • `95% CI - High` -> `95% CI - High...232`
## • `95% CI - Low` -> `95% CI - Low...235`
## • `95% CI - High` -> `95% CI - High...236`
## • `Average Grade Performance` -> `Average Grade Performance...246`
## • `Average Grade Performance (AIAN)` -> `Average Grade Performance
## (AIAN)...247`
## • `Average Grade Performance (Asian)` -> `Average Grade Performance
## (Asian)...248`
## • `Average Grade Performance (Black)` -> `Average Grade Performance
## (Black)...249`
## • `Average Grade Performance (Hispanic)` -> `Average Grade Performance
## (Hispanic)...250`
## • `Average Grade Performance (White)` -> `Average Grade Performance
## (White)...251`
## • `Average Grade Performance` -> `Average Grade Performance...252`
## • `Average Grade Performance (AIAN)` -> `Average Grade Performance
## (AIAN)...253`
## • `Average Grade Performance (Asian)` -> `Average Grade Performance
## (Asian)...254`
## • `Average Grade Performance (Black)` -> `Average Grade Performance
## (Black)...255`
## • `Average Grade Performance (Hispanic)` -> `Average Grade Performance
## (Hispanic)...256`
## • `Average Grade Performance (White)` -> `Average Grade Performance
## (White)...257`
## • `Segregation Index` -> `Segregation Index...258`
## • `95% CI - Low` -> `95% CI - Low...265`
## • `95% CI - High` -> `95% CI - High...266`
## • `95% CI - Low` -> `95% CI - Low...268`
## • `95% CI - High` -> `95% CI - High...269`
## • `Segregation Index` -> `Segregation Index...287`
## • `95% CI - Low` -> `95% CI - Low...289`
## • `95% CI - High` -> `95% CI - High...290`
## • `95% CI - Low` -> `95% CI - Low...314`
## • `95% CI - High` -> `95% CI - High...315`
## • `95% CI - Low` -> `95% CI - Low...339`
## • `95% CI - High` -> `95% CI - High...340`
## • `95% CI - Low` -> `95% CI - Low...363`
## • `95% CI - High` -> `95% CI - High...364`
## • `95% CI - Low` -> `95% CI - Low...366`
## • `95% CI - High` -> `95% CI - High...367`
## • `95% CI - Low` -> `95% CI - Low...386`
## • `95% CI - High` -> `95% CI - High...387`
## • `95% CI - Low` -> `95% CI - Low...391`
## • `95% CI - High` -> `95% CI - High...392`
counties <- texas_data[-1, ]
names(counties)
## [1] "FIPS"
## [2] "State"
## [3] "County"
## [4] "Life Expectancy"
## [5] "95% CI - Low...5"
## [6] "95% CI - High...6"
## [7] "Life Expectancy (Hispanic (all races))"
## [8] "Life Expectancy (Hispanic (all races)) 95% CI - Low"
## [9] "Life Expectancy (Hispanic (all races)) 95% CI - High"
## [10] "Life Expectancy (Non-Hispanic AIAN)"
## [11] "Life Expectancy (Non-Hispanic AIAN) 95% CI - Low"
## [12] "Life Expectancy (Non-Hispanic AIAN) 95% CI - High"
## [13] "Life Expectancy (Non-Hispanic Asian)"
## [14] "Life Expectancy (Non-Hispanic Asian) 95% CI - Low"
## [15] "Life Expectancy (Non-Hispanic Asian) 95% CI - High"
## [16] "Life Expectancy (Non-Hispanic Black)"
## [17] "Life Expectancy (Non-Hispanic Black) 95% CI - Low"
## [18] "Life Expectancy (Non-Hispanic Black) 95% CI - High"
## [19] "Life Expectancy (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [20] "Life Expectancy (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [21] "Life Expectancy (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [22] "Life Expectancy (Non-Hispanic 2+ races)"
## [23] "Life Expectancy (Non-Hispanic 2+ races) 95% CI - Low"
## [24] "Life Expectancy (Non-Hispanic 2+ races) 95% CI - High"
## [25] "Life Expectancy (Non-Hispanic White)"
## [26] "Life Expectancy (Non-Hispanic White) 95% CI - Low"
## [27] "Life Expectancy (Non-Hispanic White) 95% CI - High"
## [28] "# Deaths...28"
## [29] "Age-Adjusted Death Rate"
## [30] "95% CI - Low...30"
## [31] "95% CI - High...31"
## [32] "Age-Adjusted Mortality (Hispanic (all races))"
## [33] "Age-Adjusted Mortality (Hispanic (all races)) 95% CI - Low"
## [34] "Age-Adjusted Mortality (Hispanic (all races)) 95% CI - High"
## [35] "Age-Adjusted Mortality (Non-Hispanic AIAN)"
## [36] "Age-Adjusted Mortality (Non-Hispanic AIAN) 95% CI - Low"
## [37] "Age-Adjusted Mortality (Non-Hispanic AIAN) 95% CI - High"
## [38] "Age-Adjusted Mortality (Non-Hispanic Asian)"
## [39] "Age-Adjusted Mortality (Non-Hispanic Asian) 95% CI - Low"
## [40] "Age-Adjusted Mortality (Non-Hispanic Asian) 95% CI - High"
## [41] "Age-Adjusted Mortality (Non-Hispanic Black)"
## [42] "Age-Adjusted Mortality (Non-Hispanic Black) 95% CI - Low"
## [43] "Age-Adjusted Mortality (Non-Hispanic Black) 95% CI - High"
## [44] "Age-Adjusted Mortality (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [45] "Age-Adjusted Mortality (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [46] "Age-Adjusted Mortality (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [47] "Age-Adjusted Mortality (Non-Hispanic 2+ races)"
## [48] "Age-Adjusted Mortality (Non-Hispanic 2+ races) 95% CI - Low"
## [49] "Age-Adjusted Mortality (Non-Hispanic 2+ races) 95% CI - High"
## [50] "Age-Adjusted Mortality (Non-Hispanic White)"
## [51] "Age-Adjusted Mortality (Non-Hispanic White) 95% CI - Low"
## [52] "Age-Adjusted Mortality (Non-Hispanic White) 95% CI - High"
## [53] "# Deaths...53"
## [54] "Child Mortality Rate"
## [55] "95% CI - Low...55"
## [56] "95% CI - High...56"
## [57] "Child Mortality Rate (Hispanic (all races))"
## [58] "Child Mortality Rate (Hispanic (all races)) 95% CI - Low"
## [59] "Child Mortality Rate (Hispanic (all races)) 95% CI - High"
## [60] "Child Mortality Rate (Non-Hispanic AIAN)"
## [61] "Child Mortality Rate (Non-Hispanic AIAN) 95% CI - Low"
## [62] "Child Mortality Rate (Non-Hispanic AIAN) 95% CI - High"
## [63] "Child Mortality Rate (Non-Hispanic Asian)"
## [64] "Child Mortality Rate (Non-Hispanic Asian) 95% CI - Low"
## [65] "Child Mortality Rate (Non-Hispanic Asian) 95% CI - High"
## [66] "Child Mortality Rate (Non-Hispanic Black)"
## [67] "Child Mortality Rate (Non-Hispanic Black) 95% CI - Low"
## [68] "Child Mortality Rate (Non-Hispanic Black) 95% CI - High"
## [69] "Child Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [70] "Child Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [71] "Child Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [72] "Child Mortality Rate (Non-Hispanic 2+ races)"
## [73] "Child Mortality Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [74] "Child Mortality Rate (Non-Hispanic 2+ races) 95% CI - High"
## [75] "Child Mortality Rate (Non-Hispanic White)"
## [76] "Child Mortality Rate (Non-Hispanic White) 95% CI - Low"
## [77] "Child Mortality Rate (Non-Hispanic White) 95% CI - High"
## [78] "# Deaths...78"
## [79] "Infant Mortality Rate"
## [80] "95% CI - Low...80"
## [81] "95% CI - High...81"
## [82] "Infant Mortality Rate (Hispanic (all races))"
## [83] "Infant Mortality Rate (Hispanic (all races)) 95% CI - Low"
## [84] "Infant Mortality Rate (Hispanic (all races)) 95% CI - High"
## [85] "Infant Mortality Rate (Non-Hispanic AIAN)"
## [86] "Infant Mortality Rate (Non-Hispanic AIAN) 95% CI - Low"
## [87] "Infant Mortality Rate (Non-Hispanic AIAN) 95% CI - High"
## [88] "Infant Mortality Rate (Non-Hispanic Asian)"
## [89] "Infant Mortality Rate (Non-Hispanic Asian) 95% CI - Low"
## [90] "Infant Mortality Rate (Non-Hispanic Asian) 95% CI - High"
## [91] "Infant Mortality Rate (Non-Hispanic Black)"
## [92] "Infant Mortality Rate (Non-Hispanic Black) 95% CI - Low"
## [93] "Infant Mortality Rate (Non-Hispanic Black) 95% CI - High"
## [94] "Infant Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [95] "Infant Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [96] "Infant Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [97] "Infant Mortality Rate (Non-Hispanic 2+ races)"
## [98] "Infant Mortality Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [99] "Infant Mortality Rate (Non-Hispanic 2+ races) 95% CI - High"
## [100] "Infant Mortality Rate (Non-Hispanic White)"
## [101] "Infant Mortality Rate (Non-Hispanic White) 95% CI - Low"
## [102] "Infant Mortality Rate (Non-Hispanic White) 95% CI - High"
## [103] "% Frequent Physical Distress"
## [104] "95% CI - Low...104"
## [105] "95% CI - High...105"
## [106] "% Adults with Diabetes"
## [107] "95% CI - Low...107"
## [108] "95% CI - High...108"
## [109] "# HIV Cases"
## [110] "HIV Prevalence Rate"
## [111] "% Adults with Obesity"
## [112] "95% CI - Low...112"
## [113] "95% CI - High...113"
## [114] "% Frequent Mental Distress"
## [115] "95% CI - Low...115"
## [116] "95% CI - High...116"
## [117] "# Deaths...117"
## [118] "Suicide Rate (Age-Adjusted)"
## [119] "95% CI - Low...119"
## [120] "95% CI - High...120"
## [121] "Crude Rate"
## [122] "Suicide Rate (Hispanic (all races))"
## [123] "Suicide Rate (Hispanic (all races)) 95% CI - Low"
## [124] "Suicide Rate (Hispanic (all races)) 95% CI - High"
## [125] "Suicide Rate (Non-Hispanic AIAN)"
## [126] "Suicide Rate (Non-Hispanic AIAN) 95% CI - Low"
## [127] "Suicide Rate (Non-Hispanic AIAN) 95% CI - High"
## [128] "Suicide Rate (Non-Hispanic Asian)"
## [129] "Suicide Rate (Non-Hispanic Asian) 95% CI - Low"
## [130] "Suicide Rate (Non-Hispanic Asian) 95% CI - High"
## [131] "Suicide Rate (Non-Hispanic Black)"
## [132] "Suicide Rate (Non-Hispanic Black) 95% CI - Low"
## [133] "Suicide Rate (Non-Hispanic Black) 95% CI - High"
## [134] "Suicide Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [135] "Suicide Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [136] "Suicide Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [137] "Suicide Rate (Non-Hispanic 2+ races)"
## [138] "Suicide Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [139] "Suicide Rate (Non-Hispanic 2+ races) 95% CI - High"
## [140] "Suicide Rate (Non-Hispanic White)"
## [141] "Suicide Rate (Non-Hispanic White) 95% CI - Low"
## [142] "Suicide Rate (Non-Hispanic White) 95% CI - High"
## [143] "% feeling lonely"
## [144] "95% CI - Low...144"
## [145] "95% CI - High...145"
## [146] "# Limited Access to Healthy Foods"
## [147] "% Limited Access to Healthy Foods"
## [148] "# Food Insecure"
## [149] "% Food Insecure"
## [150] "% Insufficient Sleep"
## [151] "95% CI - Low...151"
## [152] "95% CI - High...152"
## [153] "Teen Birth Rate"
## [154] "95% CI - Low...154"
## [155] "95% CI - High...155"
## [156] "Teen Birth Rate (Hispanic (all races))"
## [157] "Teen Birth Rate (Hispanic (all races)) 95% CI - Low"
## [158] "Teen Birth Rate (Hispanic (all races)) 95% CI - High"
## [159] "Teen Birth Rate (Non-Hispanic AIAN)"
## [160] "Teen Birth Rate (Non-Hispanic AIAN) 95% CI - Low"
## [161] "Teen Birth Rate (Non-Hispanic AIAN) 95% CI - High"
## [162] "Teen Birth Rate (Non-Hispanic Asian)"
## [163] "Teen Birth Rate (Non-Hispanic Asian) 95% CI - Low"
## [164] "Teen Birth Rate (Non-Hispanic Asian) 95% CI - High"
## [165] "Teen Birth Rate (Non-Hispanic Black)"
## [166] "Teen Birth Rate (Non-Hispanic Black) 95% CI - Low"
## [167] "Teen Birth Rate (Non-Hispanic Black) 95% CI - High"
## [168] "Teen Birth Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [169] "Teen Birth Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [170] "Teen Birth Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [171] "Teen Birth Rate (Non-Hispanic 2+ races)"
## [172] "Teen Birth Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [173] "Teen Birth Rate (Non-Hispanic 2+ races) 95% CI - High"
## [174] "Teen Birth Rate (Non-Hispanic White)"
## [175] "Teen Birth Rate (Non-Hispanic White) 95% CI - Low"
## [176] "Teen Birth Rate (Non-Hispanic White) 95% CI - High"
## [177] "# Chlamydia Cases"
## [178] "Chlamydia Rate"
## [179] "% Excessive Drinking"
## [180] "95% CI - Low...180"
## [181] "95% CI - High...181"
## [182] "# Alcohol-Impaired Driving Deaths"
## [183] "# Driving Deaths"
## [184] "% Driving Deaths with Alcohol Involvement"
## [185] "95% CI - Low...185"
## [186] "95% CI - High...186"
## [187] "# Drug Overdose Deaths"
## [188] "Drug Overdose Mortality Rate"
## [189] "95% CI - Low...189"
## [190] "95% CI - High...190"
## [191] "Drug Overdose Mortality Rate (Hispanic (all races))"
## [192] "Drug Overdose Mortality Rate (Hispanic (all races)) 95% CI - Low"
## [193] "Drug Overdose Mortality Rate (Hispanic (all races)) 95% CI - High"
## [194] "Drug Overdose Mortality Rate (Non-Hispanic AIAN)"
## [195] "Drug Overdose Mortality Rate (Non-Hispanic AIAN) 95% CI - Low"
## [196] "Drug Overdose Mortality Rate (Non-Hispanic AIAN) 95% CI - High"
## [197] "Drug Overdose Mortality Rate (Non-Hispanic Asian)"
## [198] "Drug Overdose Mortality Rate (Non-Hispanic Asian) 95% CI - Low"
## [199] "Drug Overdose Mortality Rate (Non-Hispanic Asian) 95% CI - High"
## [200] "Drug Overdose Mortality Rate (Non-Hispanic Black)"
## [201] "Drug Overdose Mortality Rate (Non-Hispanic Black) 95% CI - Low"
## [202] "Drug Overdose Mortality Rate (Non-Hispanic Black) 95% CI - High"
## [203] "Drug Overdose Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [204] "Drug Overdose Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [205] "Drug Overdose Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [206] "Drug Overdose Mortality Rate (Non-Hispanic 2+ races)"
## [207] "Drug Overdose Mortality Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [208] "Drug Overdose Mortality Rate (Non-Hispanic 2+ races) 95% CI - High"
## [209] "Drug Overdose Mortality Rate (Non-Hispanic White)"
## [210] "Drug Overdose Mortality Rate (Non-Hispanic White) 95% CI - Low"
## [211] "Drug Overdose Mortality Rate (Non-Hispanic White) 95% CI - High"
## [212] "% Adults Reporting Currently Smoking"
## [213] "95% CI - Low...213"
## [214] "95% CI - High...214"
## [215] "% Physically Inactive"
## [216] "95% CI - Low...216"
## [217] "95% CI - High...217"
## [218] "# Uninsured Adults"
## [219] "% Uninsured Adults"
## [220] "95% CI - Low...220"
## [221] "95% CI - High...221"
## [222] "# Uninsured Children"
## [223] "% Uninsured Children"
## [224] "95% CI - Low...224"
## [225] "95% CI - High...225"
## [226] "Other Primary Care Provider Rate"
## [227] "Other Primary Care Provider Ratio"
## [228] "Traffic Volume"
## [229] "# Homeowners"
## [230] "% Homeowners"
## [231] "95% CI - Low...231"
## [232] "95% CI - High...232"
## [233] "# Households with Severe Cost Burden"
## [234] "% Households with Severe Cost Burden"
## [235] "95% CI - Low...235"
## [236] "95% CI - High...236"
## [237] "% with access to parks"
## [238] "Adverse Climate Events"
## [239] "Days above 90F"
## [240] "Weeks in moderate or greater drought"
## [241] "Disaster declarations"
## [242] "% Census Participation"
## [243] "% Voter Turnout"
## [244] "Cohort Size"
## [245] "High School Graduation Rate"
## [246] "Average Grade Performance...246"
## [247] "Average Grade Performance (AIAN)...247"
## [248] "Average Grade Performance (Asian)...248"
## [249] "Average Grade Performance (Black)...249"
## [250] "Average Grade Performance (Hispanic)...250"
## [251] "Average Grade Performance (White)...251"
## [252] "Average Grade Performance...252"
## [253] "Average Grade Performance (AIAN)...253"
## [254] "Average Grade Performance (Asian)...254"
## [255] "Average Grade Performance (Black)...255"
## [256] "Average Grade Performance (Hispanic)...256"
## [257] "Average Grade Performance (White)...257"
## [258] "Segregation Index...258"
## [259] "Spending per Pupil"
## [260] "School Funding Adequacy"
## [261] "% Enrolled in Free or Reduced Lunch"
## [262] "Women's Median Earnings"
## [263] "Men's Median Earnings"
## [264] "Gender Pay Gap"
## [265] "95% CI - Low...265"
## [266] "95% CI - High...266"
## [267] "Median Household Income"
## [268] "95% CI - Low...268"
## [269] "95% CI - High...269"
## [270] "Household Income (AIAN)"
## [271] "Household Income (AIAN) 95% CI - Low"
## [272] "Household Income (AIAN) 95% CI - High"
## [273] "Household Income (Asian)"
## [274] "Household Income (Asian) 95% CI - Low"
## [275] "Household Income (Asian) 95% CI - High"
## [276] "Household Income (Black)"
## [277] "Household Income (Black) 95% CI - Low"
## [278] "Household Income (Black) 95% CI - High"
## [279] "Household Income (Hispanic)"
## [280] "Household Income (Hispanic) 95% CI - Low"
## [281] "Household Income (Hispanic) 95% CI - High"
## [282] "Household Income (White)"
## [283] "Household Income (White) 95% CI - Low"
## [284] "Household Income (White) 95% CI - High"
## [285] "# Child Care Centers"
## [286] "Child Care Centers per 1,000 Children"
## [287] "Segregation Index...287"
## [288] "Homicide Rate"
## [289] "95% CI - Low...289"
## [290] "95% CI - High...290"
## [291] "Homicide Rate (Hispanic (all races))"
## [292] "Homicide Rate (Hispanic (all races)) 95% CI - Low"
## [293] "Homicide Rate (Hispanic (all races)) 95% CI - High"
## [294] "Homicide Rate (Non-Hispanic AIAN)"
## [295] "Homicide Rate (Non-Hispanic AIAN) 95% CI - Low"
## [296] "Homicide Rate (Non-Hispanic AIAN) 95% CI - High"
## [297] "Homicide Rate (Non-Hispanic Asian)"
## [298] "Homicide Rate (Non-Hispanic Asian) 95% CI - Low"
## [299] "Homicide Rate (Non-Hispanic Asian) 95% CI - High"
## [300] "Homicide Rate (Non-Hispanic Black)"
## [301] "Homicide Rate (Non-Hispanic Black) 95% CI - Low"
## [302] "Homicide Rate (Non-Hispanic Black) 95% CI - High"
## [303] "Homicide Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [304] "Homicide Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [305] "Homicide Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [306] "Homicide Rate (Non-Hispanic 2+ races)"
## [307] "Homicide Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [308] "Homicide Rate (Non-Hispanic 2+ races) 95% CI - High"
## [309] "Homicide Rate (Non-Hispanic White)"
## [310] "Homicide Rate (Non-Hispanic White) 95% CI - Low"
## [311] "Homicide Rate (Non-Hispanic White) 95% CI - High"
## [312] "# Motor Vehicle Deaths"
## [313] "Motor Vehicle Mortality Rate"
## [314] "95% CI - Low...314"
## [315] "95% CI - High...315"
## [316] "MV Mortality Rate (Hispanic (all races))"
## [317] "MV Mortality Rate (Hispanic (all races)) 95% CI - Low"
## [318] "MV Mortality Rate (Hispanic (all races)) 95% CI - High"
## [319] "MV Mortality Rate (Non-Hispanic AIAN)"
## [320] "MV Mortality Rate (Non-Hispanic AIAN) 95% CI - Low"
## [321] "MV Mortality Rate (Non-Hispanic AIAN) 95% CI - High"
## [322] "MV Mortality Rate (Non-Hispanic Asian)"
## [323] "MV Mortality Rate (Non-Hispanic Asian) 95% CI - Low"
## [324] "MV Mortality Rate (Non-Hispanic Asian) 95% CI - High"
## [325] "MV Mortality Rate (Non-Hispanic Black)"
## [326] "MV Mortality Rate (Non-Hispanic Black) 95% CI - Low"
## [327] "MV Mortality Rate (Non-Hispanic Black) 95% CI - High"
## [328] "MV Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [329] "MV Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [330] "MV Mortality Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [331] "MV Mortality Rate (Non-Hispanic 2+ races)"
## [332] "MV Mortality Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [333] "MV Mortality Rate (Non-Hispanic 2+ races) 95% CI - High"
## [334] "MV Mortality Rate (Non-Hispanic White)"
## [335] "MV Mortality Rate (Non-Hispanic White) 95% CI - Low"
## [336] "MV Mortality Rate (Non-Hispanic White) 95% CI - High"
## [337] "# Firearm Fatalities"
## [338] "Firearm Fatalities Rate"
## [339] "95% CI - Low...339"
## [340] "95% CI - High...340"
## [341] "Firearm Fatalities Rate (Hispanic (all races))"
## [342] "Firearm Fatalities Rate (Hispanic (all races)) 95% CI - Low"
## [343] "Firearm Fatalities Rate (Hispanic (all races)) 95% CI - High"
## [344] "Firearm Fatalities Rate (Non-Hispanic AIAN)"
## [345] "Firearm Fatalities Rate (Non-Hispanic AIAN) 95% CI - Low"
## [346] "Firearm Fatalities Rate (Non-Hispanic AIAN) 95% CI - High"
## [347] "Firearm Fatalities Rate (Non-Hispanic Asian)"
## [348] "Firearm Fatalities Rate (Non-Hispanic Asian) 95% CI - Low"
## [349] "Firearm Fatalities Rate (Non-Hispanic Asian) 95% CI - High"
## [350] "Firearm Fatalities Rate (Non-Hispanic Black)"
## [351] "Firearm Fatalities Rate (Non-Hispanic Black) 95% CI - Low"
## [352] "Firearm Fatalities Rate (Non-Hispanic Black) 95% CI - High"
## [353] "Firearm Fatalities Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander)"
## [354] "Firearm Fatalities Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - Low"
## [355] "Firearm Fatalities Rate (Non-Hispanic Native Hawaiian and Other Pacific Islander) 95% CI - High"
## [356] "Firearm Fatalities Rate (Non-Hispanic 2+ races)"
## [357] "Firearm Fatalities Rate (Non-Hispanic 2+ races) 95% CI - Low"
## [358] "Firearm Fatalities Rate (Non-Hispanic 2+ races) 95% CI - High"
## [359] "Firearm Fatalities Rate (Non-Hispanic White)"
## [360] "Firearm Fatalities Rate (Non-Hispanic White) 95% CI - Low"
## [361] "Firearm Fatalities Rate (Non-Hispanic White) 95% CI - High"
## [362] "% Disconnected Youth"
## [363] "95% CI - Low...363"
## [364] "95% CI - High...364"
## [365] "% lacking support"
## [366] "95% CI - Low...366"
## [367] "95% CI - High...367"
## [368] "% Below 18 Years of Age"
## [369] "% 65 and Over"
## [370] "% Female"
## [371] "# American Indian or Alaska Native"
## [372] "% American Indian or Alaska Native"
## [373] "# Asian"
## [374] "% Asian"
## [375] "# Hispanic"
## [376] "% Hispanic"
## [377] "# Native Hawaiian or Other Pacific Islander"
## [378] "% Native Hawaiian or Other Pacific Islander"
## [379] "# Non-Hispanic Black"
## [380] "% Non-Hispanic Black"
## [381] "# Non-Hispanic White"
## [382] "% Non-Hispanic White"
## [383] "% with disability"
## [384] "# Not Proficient in English"
## [385] "% Not Proficient in English"
## [386] "95% CI - Low...386"
## [387] "95% CI - High...387"
## [388] "# Children in Single-Parent Households"
## [389] "# Children in Households"
## [390] "% Children in Single-Parent Households"
## [391] "95% CI - Low...391"
## [392] "95% CI - High...392"
## [393] "# Rural Residents"
## [394] "% Rural"
## [395] "Population"
research_data <- counties[, c("% Frequent Mental Distress", "% Food Insecure", "% Uninsured Adults", "Median Household Income", "% Rural")]
summary(research_data)
## % Frequent Mental Distress % Food Insecure % Uninsured Adults
## Min. :13.6 Min. :10.60 Min. : 3.226
## 1st Qu.:18.5 1st Qu.:15.50 1st Qu.:20.192
## Median :19.3 Median :16.90 Median :23.041
## Mean :19.2 Mean :17.31 Mean :23.303
## 3rd Qu.:20.0 3rd Qu.:18.80 3rd Qu.:26.161
## Max. :24.6 Max. :28.50 Max. :40.732
## Median Household Income % Rural
## Min. : 36695 Min. : 0.5783
## 1st Qu.: 53505 1st Qu.: 34.8484
## Median : 60358 Median : 71.9345
## Mean : 63467 Mean : 65.4546
## 3rd Qu.: 69532 3rd Qu.:100.0000
## Max. :120149 Max. :100.0000
model1 <- lm(`% Frequent Mental Distress`~ `% Food Insecure`+ `Median Household Income`+ `% Uninsured Adults`+ `% Rural`, data = research_data)
summary(model1)
##
## Call:
## lm(formula = `% Frequent Mental Distress` ~ `% Food Insecure` +
## `Median Household Income` + `% Uninsured Adults` + `% Rural`,
## data = research_data)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.7412 -0.6989 0.0557 0.7447 3.6624
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.744e+01 1.133e+00 15.387 < 2e-16 ***
## `% Food Insecure` 1.513e-01 3.379e-02 4.478 1.15e-05 ***
## `Median Household Income` -3.101e-05 7.604e-06 -4.078 6.10e-05 ***
## `% Uninsured Adults` 2.725e-02 1.643e-02 1.659 0.098474 .
## `% Rural` 7.284e-03 2.164e-03 3.365 0.000885 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.119 on 249 degrees of freedom
## Multiple R-squared: 0.4425, Adjusted R-squared: 0.4335
## F-statistic: 49.4 on 4 and 249 DF, p-value: < 2.2e-16
summary(model1)
##
## Call:
## lm(formula = `% Frequent Mental Distress` ~ `% Food Insecure` +
## `Median Household Income` + `% Uninsured Adults` + `% Rural`,
## data = research_data)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.7412 -0.6989 0.0557 0.7447 3.6624
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.744e+01 1.133e+00 15.387 < 2e-16 ***
## `% Food Insecure` 1.513e-01 3.379e-02 4.478 1.15e-05 ***
## `Median Household Income` -3.101e-05 7.604e-06 -4.078 6.10e-05 ***
## `% Uninsured Adults` 2.725e-02 1.643e-02 1.659 0.098474 .
## `% Rural` 7.284e-03 2.164e-03 3.365 0.000885 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.119 on 249 degrees of freedom
## Multiple R-squared: 0.4425, Adjusted R-squared: 0.4335
## F-statistic: 49.4 on 4 and 249 DF, p-value: < 2.2e-16
plot(model1, which = 1)
this model is not linear.
durbinWatsonTest(model1)
## lag Autocorrelation D-W Statistic p-value
## 1 0.0502668 1.895521 0.404
## Alternative hypothesis: rho != 0
plot(model1, which = 2)
plot(model1, which = 3)
bptest(model1)
##
## studentized Breusch-Pagan test
##
## data: model1
## BP = 6.1227, df = 4, p-value = 0.1902
vif(model1)
## `% Food Insecure` `Median Household Income` `% Uninsured Adults`
## 2.084292 2.528601 1.456520
## `% Rural`
## 1.131232
pairs(research_data)
model2 <- lm(log(`% Frequent Mental Distress`)~ `% Food Insecure`+`Median Household Income`+`% Uninsured Adults`+`% Rural`, data = research_data)
plot(model2, which = 1)