#' --- #' title: "Regression and Other Stories: Arsenic" #' author: "Andrew Gelman, Jennifer Hill, Aki Vehtari" #' date: "`r format(Sys.Date())`" #' output: #' html_document: #' theme: readable #' toc: true #' toc_depth: 2 #' toc_float: true #' code_download: true #' --- #' Building a logistic regression model: wells in Bangladesh. See #' Chapter 13 in Regression and Other Stories. #' #' This version uses algorithm='optimizing', which finds the posterior #' mode, computes Hessian and uses a normal distribution approximation #' of the posterior. This can work well for non-hierarchical #' generalized linear models when the number of observations is much #' higher than the number of covariates. #' #' ------------- #' #+ setup, include=FALSE knitr::opts_chunk$set(message=FALSE, error=FALSE, warning=FALSE, comment=NA) # switch this to TRUE to save figures in separate files savefigs <- FALSE #' #### Load packages library("rprojroot") root<-has_file(".ROS-Examples-root")$make_fix_file() library("rstanarm") library("loo") invlogit <- plogis #' #### Load data wells <- read.csv(root("Arsenic/data","wells.csv")) wells$y <- wells$switch n <- nrow(wells) #' ## Null model #' #' #### Log-score for coin flipping prob <- 0.5 round(log(prob)*sum(wells$y) + log(1-prob)*sum(1-wells$y),1) #' #### Log-score for intercept model round(prob <- mean(wells$y),2) round(log(prob)*sum(wells$y) + log(1-prob)*sum(1-wells$y),1) #' ## A single predictor #' #' #### Fit a model using distance to the nearest safe well #+ results='hide' fit_1 <- stan_glm(y ~ dist, family = binomial(link = "logit"), data=wells, algorithm='optimizing') #' print(fit_1, digits=3) summary(fit_1, digits=3) #' #### LOO log score (loo1 <- loo(fit_1)) #' #### Histogram of distances #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.distances.bnew.ps"), height=3, width=4, horizontal=TRUE) #+ hist(wells$dist, breaks=seq(0,10+max(wells$dist),10), freq=TRUE, xlab="Distance (in meters) to nearest safe well", ylab="", main="", mgp=c(2,.5,0)) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' #### Scale distance in meters to distance in 100 meters wells$dist100 <- wells$dist/100 #' #### Fit a model using scaled distance to the nearest safe well #+ results='hide' fit_2 <- stan_glm(y ~ dist100, family = binomial(link = "logit"), data=wells, algorithm='optimizing') #' print(fit_2, digits=2) summary(fit_2, digits=2) #' #### LOO log score (loo2 <- loo(fit_2, save_psis = TRUE)) #' #### Plot model fit jitter_binary <- function(a, jitt=.05){ a + (1-2*a)*runif(length(a),0,jitt) } #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.logitfit.1new.a.ps"), height=3.5, width=4, horizontal=TRUE) #+ plot(c(0,max(wells$dist, na.rm=TRUE)*1.02), c(0,1), xlab="Distance (in meters) to nearest safe well", ylab="Pr (switching)", type="n", xaxs="i", yaxs="i", mgp=c(2,.5,0)) curve(invlogit(coef(fit_1)[1]+coef(fit_1)[2]*x), lwd=1, add=TRUE) points(wells$dist, jitter_binary(wells$y), pch=20, cex=.1) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' #### Plot uncertainty in the estimated coefficients #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.logitfit.scatterplot.ps"), height=3.5, width=3.5, horizontal=TRUE) #+ sims <- as.matrix(fit_2) par(pty="s") plot(sims[1:500,1], sims[1:500,2], xlim=c(.4,.8), ylim=c(-1,0), xlab=expression(beta[0]), ylab=expression(beta[1]), mgp=c(1.5,.5,0), pch=20, cex=.5, xaxt="n", yaxt="n") axis(1, seq(.4,.8,.2), mgp=c(1.5,.5,0)) axis(2, seq(-1,0,.5), mgp=c(1.5,.5,0)) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' #### Plot uncertainty in the estimated predictions #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.logitfit.1new.b.ps"), height=3.5, width=4, horizontal=TRUE) #+ plot(c(0,max(wells$dist, na.rm=T)*1.02), c(0,1), xlab="Distance (in meters) to nearest safe well", ylab="Pr (switching)", type="n", xaxs="i", yaxs="i", mgp=c(2,.5,0)) for (j in 1:20) { curve (invlogit(sims[j,1]+sims[j,2]*x/100), lwd=.5, col="darkgray", add=TRUE) } curve(invlogit(coef(fit_2)[1]+coef(fit_2)[2]*x/100), lwd=1, add=T) points(wells$dist, jitter_binary(wells$y), pch=20, cex=.1) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' ## Two predictors #' #' #### Histogram of arsenic levels #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.levels.a.ps"), height=3, width=4, horizontal=TRUE) #+ hist(wells$arsenic, breaks=seq(0,.25+max(wells$arsenic),.25), freq=TRUE, xlab="Arsenic concentration in well water", ylab="", main="", mgp=c(2,.5,0)) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' #### Fit a model using scaled distance and arsenic level #+ results='hide' fit_3 <- stan_glm(y ~ dist100 + arsenic, family = binomial(link = "logit"), data=wells, algorithm='optimizing') #' print(fit_3, digits=2) summary(fit_3, digits=2) #' #### LOO log score (loo3 <- loo(fit_3, save_psis = TRUE)) #' #### Compare models loo_compare(loo2, loo3) #' #### Average improvement in LOO predictive probabilities
#' from dist100 to dist100 + arsenic pred2 <- loo_predict(fit_2, psis_object = loo2$psis_object)$value pred3 <- loo_predict(fit_3, psis_object = loo3$psis_object)$value round(mean(c(pred3[wells$y==1]-pred2[wells$y==1],pred2[wells$y==0]-pred3[wells$y==0])),3) #' #### Plot model fits #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.2variables.a.ps"), height=3.5, width=4, horizontal=TRUE) #+ plot(c(0,max(wells$dist,na.rm=T)*1.02), c(0,1), xlab="Distance (in meters) to nearest safe well", ylab="Pr (switching)", type="n", xaxs="i", yaxs="i", mgp=c(2,.5,0)) points(wells$dist, jitter_binary(wells$y), pch=20, cex=.1) curve(invlogit(coef(fit_3)[1]+coef(fit_3)[2]*x/100+coef(fit_3)[3]*.50), lwd=.5, add=T) curve(invlogit(coef(fit_3)[1]+coef(fit_3)[2]*x/100+coef(fit_3)[3]*1.00), lwd=.5, add=T) text(50, .27, "if As = 0.5", adj=0, cex=.8) text(75, .50, "if As = 1.0", adj=0, cex=.8) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.2variables.b.ps"), height=3.5, width=4, horizontal=TRUE) #+ plot(c(0,max(wells$arsenic,na.rm=T)*1.02), c(0,1), xlab="Arsenic concentration in well water", ylab="Pr (switching)", type="n", xaxs="i", yaxs="i", mgp=c(2,.5,0)) points(wells$arsenic, jitter_binary(wells$y), pch=20, cex=.1) curve(invlogit(coef(fit_3)[1]+coef(fit_3)[2]*0+coef(fit_3)[3]*x), from=0.5, lwd=.5, add=T) curve(invlogit(coef(fit_3)[1]+coef(fit_3)[2]*0.5+coef(fit_3)[3]*x), from=0.5, lwd=.5, add=T) text(.5, .78, "if dist = 0", adj=0, cex=.8) text(2, .6, "if dist = 50", adj=0, cex=.8) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' ## Interaction #' #' #### Fit a model using scaled distance, arsenic level, and an interaction #+ results='hide' fit_4 <- stan_glm(y ~ dist100 + arsenic + dist100:arsenic, family = binomial(link="logit"), data = wells, algorithm='optimizing') #' print(fit_4, digits=2) summary(fit_4, digits=2) #' #### LOO log score (loo4 <- loo(fit_4)) #' #### Compare models loo_compare(loo3, loo4) #' #### Centering the input variables wells$c_dist100 <- wells$dist100 - mean(wells$dist100) wells$c_arsenic <- wells$arsenic - mean(wells$arsenic) fit_5 <- stan_glm(y ~ c_dist100 + c_arsenic + c_dist100:c_arsenic, family = binomial(link="logit"), data = wells, algorithm='optimizing') #' print(fit_5, digits=2) summary(fit_5, digits=2) #' #### Plot model fits #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.interact.a.ps"), height=3.5, width=4, horizontal=TRUE) #+ plot(c(0,max(wells$dist,na.rm=T)*1.02), c(0,1), xlab="Distance (in meters) to nearest safe well", ylab="Pr (switching)", type="n", xaxs="i", yaxs="i", mgp=c(2,.5,0)) points(wells$dist, jitter_binary(wells$y), pch=20, cex=.1) curve(invlogit(coef(fit_4)[1]+coef(fit_4)[2]*x/100+coef(fit_4)[3]*.50+coef(fit_4)[4]*x/100*.50), lwd=.5, add=T) curve(invlogit(coef(fit_4)[1]+coef(fit_4)[2]*x/100+coef(fit_4)[3]*1.00+coef(fit_4)[4]*x/100*1.00), lwd=.5, add=T) text (50, .29, "if As = 0.5", adj=0, cex=.8) text (75, .50, "if As = 1.0", adj=0, cex=.8) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #+ eval=FALSE, include=FALSE if (savefigs) postscript(root("Arsenic/figs","arsenic.interact.b.ps"), height=3.5, width=4, horizontal=TRUE) #+ plot(c(0,max(wells$arsenic,na.rm=T)*1.02), c(0,1), xlab="Arsenic concentration in well water", ylab="Pr (switching)", type="n", xaxs="i", yaxs="i", mgp=c(2,.5,0)) points(wells$arsenic, jitter_binary(wells$y), pch=20, cex=.1) curve(invlogit(coef(fit_4)[1]+coef(fit_4)[2]*0+coef(fit_4)[3]*x+coef(fit_4)[4]*0*x), from=0.5, lwd=.5, add=T) curve(invlogit(coef(fit_4)[1]+coef(fit_4)[2]*0.5+coef(fit_4)[3]*x+coef(fit_4)[4]*0.5*x), from=0.5, lwd=.5, add=T) text (.5, .78, "if dist = 0", adj=0, cex=.8) text (2, .6, "if dist = 50", adj=0, cex=.8) #+ eval=FALSE, include=FALSE if (savefigs) dev.off() #' ## More predictors #' #' #### Adding social predictors #+ results='hide' fit_6 <- stan_glm(y ~ dist100 + arsenic + educ4 + assoc, family = binomial(link="logit"), data = wells, algorithm='optimizing') #' print(fit_6, digits=2) summary(fit_6, digits=2) #' #### LOO log score (loo6 <- loo(fit_6)) #' #### Compare models loo_compare(loo4, loo6) #' #### Remove assoc #+ results='hide' fit_7 <- stan_glm(y ~ dist100 + arsenic + educ4, family = binomial(link="logit"), data = wells, algorithm='optimizing') #' print(fit_7, digits=2) summary(fit_7, digits=2) #' #### LOO log score (loo7 <- loo(fit_7)) #' #### Compare models loo_compare(loo4, loo7) loo_compare(loo6, loo7) #' #### Add interactions with education #+ results='hide' wells$c_educ4 <- wells$educ4 - mean(wells$educ4) fit_8 <- stan_glm(y ~ c_dist100 + c_arsenic + c_educ4 + c_dist100:c_educ4 + c_arsenic:c_educ4, family = binomial(link="logit"), data = wells, algorithm='optimizing') #' print(fit_8, digits=2) summary(fit_8, digits=2) #' #### LOO log score (loo8 <- loo(fit_8, save_psis=TRUE)) #' #### Compare models loo_compare(loo3, loo8) loo_compare(loo7, loo8) #' #### Average improvement in LOO predictive probabilities
#' from dist100 + arsenic to dist100 + arsenic + educ4 + dist100:educ4 + arsenic:educ4 pred8 <- loo_predict(fit_8, psis_object = loo8$psis_object)$value round(mean(c(pred8[wells$y==1]-pred3[wells$y==1],pred3[wells$y==0]-pred8[wells$y==0])),3) #' ## Transformation of variable #' #' #### Fit a model using scaled distance and log arsenic level wells$log_arsenic <- log(wells$arsenic) #+ results='hide' fit_3a <- stan_glm(y ~ dist100 + log_arsenic, family = binomial(link = "logit"), data = wells, algorithm='optimizing') #' print(fit_3a, digits=2) summary(fit_3a, digits=2) #' #### LOO log score (loo3a <- loo(fit_3a)) #' #### Compare models loo_compare(loo3, loo3a) #' #### Fit a model using scaled distance, log arsenic level, and an interaction
#+ results='hide' fit_4a <- stan_glm(y ~ dist100 + log_arsenic + dist100:log_arsenic, family = binomial(link = "logit"), data = wells, algorithm='optimizing') #' print(fit_4a, digits=2) summary(fit_4a, digits=2) #' #### LOO log score (loo4a <- loo(fit_4a)) #' #### Compare models loo_compare(loo3a, loo4a) #' #### Add interactions with education wells$c_log_arsenic <- wells$log_arsenic - mean(wells$log_arsenic) #+ results='hide' fit_8a <- stan_glm(y ~ c_dist100 + c_log_arsenic + c_educ4 + c_dist100:c_educ4 + c_log_arsenic:c_educ4, family = binomial(link="logit"), data = wells, algorithm='optimizing') #' print(fit_8a, digits=2) summary(fit_8a, digits=2) #' #### LOO log score (loo8a <- loo(fit_8a, save_psis=TRUE)) #' #### Compare models loo_compare(loo8, loo8a)