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)