This workshop will provide hands-on instruction and exercises covering basic statistical analysis in R. This will cover descriptive statistics, t-tests, linear models, chi-square, clustering, dimensionality reduction, and resampling strategies. We will also cover methods for “tidying” model results for downstream visualization and summarization.

Prerequisites: Familiarity with R is required (including working with data frames, installing/using packages, importing data, and saving results); familiarity with dplyr and ggplot2 packages is highly recommended.

You must complete the basic R setup here prior to class. This includes installing R, RStudio, and the required packages. Please contact one of the instructors prior to class if you are having difficulty with any of the setup. Please bring your laptop and charger cable to class.

Handouts: Download and print out these handouts and bring them to class:

Slides: click here.

Our data: NHANES

About NHANES

The data we’re going to work with comes from the National Health and Nutrition Examination Survey (NHANES) program at the CDC. You can read a lot more about NHANES on the CDC’s website or Wikipedia. NHANES is a research program designed to assess the health and nutritional status of adults and children in the United States. The survey is one of the only to combine both survey questions and physical examinations. It began in the 1960s and since 1999 examines a nationally representative sample of about 5,000 people each year. The NHANES interview includes demographic, socioeconomic, dietary, and health-related questions. The physical exam includes medical, dental, and physiological measurements, as well as several standard laboratory tests. NHANES is used to determine the prevalence of major diseases and risk factors for those diseases. NHANES data are also the basis for national standards for measurements like height, weight, and blood pressure. Data from this survey is used in epidemiology studies and health sciences research, which help develop public health policy, direct and design health programs and services, and expand the health knowledge for the Nation.

We are using a small slice of this data. We’re only using a handful of variables from the 2011-2012 survey years on about 5,000 individuals. The CDC uses a sampling strategy to purposefully oversample certain subpopulations like racial minorities. Naive analysis of the original NHANES data can lead to mistaken conclusions because the percentages of people from each racial group in the data are different from general population. The 5,000 individuals here are resampled from the larger NHANES study population to undo these oversampling effects, so you can treat this as if it were a simple random sample from the American population.

You can download the data at the link above. The file is called nhanes.csv. There’s also a data dictionary (filename nhanes_dd.csv) that lists and describes each variable in our NHANES dataset. This table is copied below.

Variable Definition
id A unique sample identifier
Gender Gender (sex) of study participant coded as male or female
Age Age in years at screening of study participant. Note: Subjects 80 years or older were recorded as 80.
Race Reported race of study participant, including non-Hispanic Asian category: Mexican, Hispanic, White, Black, Asian, or Other. Not availale for 2009-10.
Education Educational level of study participant Reported for participants aged 20 years or older. One of 8thGrade, 9-11thGrade, HighSchool, SomeCollege, or CollegeGrad.
MaritalStatus Marital status of study participant. Reported for participants aged 20 years or older. One of Married, Widowed, Divorced, Separated, NeverMarried, or LivePartner (living with partner).
RelationshipStatus Simplification of MaritalStatus, coded as Committed if MaritalStatus is Married or LivePartner, and Single otherwise.
Insured Indicates whether the individual is covered by health insurance.
Income Numerical version of HHIncome derived from the middle income in each category
Poverty A ratio of family income to poverty guidelines. Smaller numbers indicate more poverty
HomeRooms How many rooms are in home of study participant (counting kitchen but not bathroom). 13 rooms = 13 or more rooms.
HomeOwn One of Home, Rent, or Other indicating whether the home of study participant or someone in their family is owned, rented or occupied by some other arrangement.
Work Indicates whether the individual is current working or not.
Weight Weight in kg
Height Standing height in cm. Reported for participants aged 2 years or older.
BMI Body mass index (weight/height2 in kg/m2). Reported for participants aged 2 years or older.
Pulse 60 second pulse rate
BPSys Combined systolic blood pressure reading, following the procedure outlined for BPXSAR.
BPDia Combined diastolic blood pressure reading, following the procedure outlined for BPXDAR.
Testosterone Testerone total (ng/dL). Reported for participants aged 6 years or older. Not available for 2009-2010.
HDLChol Direct HDL cholesterol in mmol/L. Reported for participants aged 6 years or older.
TotChol Total HDL cholesterol in mmol/L. Reported for participants aged 6 years or older.
Diabetes Study participant told by a doctor or health professional that they have diabetes. Reported for participants aged 1 year or older as Yes or No.
DiabetesAge Age of study participant when first told they had diabetes. Reported for participants aged 1 year or older.
nPregnancies How many times participant has been pregnant. Reported for female participants aged 20 years or older.
nBabies How many of participants deliveries resulted in live births. Reported for female participants aged 20 years or older.
SleepHrsNight Self-reported number of hours study participant usually gets at night on weekdays or workdays. Reported for participants aged 16 years and older.
PhysActive Participant does moderate or vigorous-intensity sports, fitness or recreational activities (Yes or No). Reported for participants 12 years or older.
PhysActiveDays Number of days in a typical week that participant does moderate or vigorous-intensity activity. Reported for participants 12 years or older.
AlcoholDay Average number of drinks consumed on days that participant drank alcoholic beverages. Reported for participants aged 18 years or older.
AlcoholYear Estimated number of days over the past year that participant drank alcoholic beverages. Reported for participants aged 18 years or older.
SmokingStatus Smoking status: Current Former or Never.

Import & inspect

First, let’s load the dplyr and readr libraries.

library(readr)
library(dplyr)

If you see a warning that looks like this: Error in library(dplyr) : there is no package called 'dplyr' (or similar with readr), then you don’t have the package installed correctly. See the setup page.

Now, let’s actually load the data. When we load data we assign it to a variable just like any other, and we can choose a name for that data. Since we’re going to be referring to this data a lot, let’s give it a short easy name to type. I’m going to call it nh. Once we’ve loaded it we can type the name of the object itself (nh) to see it printed to the screen.

nh <- read_csv(file="data/nhanes.csv")
nh
## # A tibble: 5,000 × 32
##       id Gender   Age Race    Education   MaritalStatus RelationshipSta… Insured
##    <dbl> <chr>  <dbl> <chr>   <chr>       <chr>         <chr>            <chr>  
##  1 62163 male      14 Asian   <NA>        <NA>          <NA>             Yes    
##  2 62172 female    43 Black   High School NeverMarried  Single           Yes    
##  3 62174 male      80 White   College Gr… Married       Committed        Yes    
##  4 62174 male      80 White   College Gr… Married       Committed        Yes    
##  5 62175 male       5 White   <NA>        <NA>          <NA>             Yes    
##  6 62176 female    34 White   College Gr… Married       Committed        Yes    
##  7 62178 male      80 White   High School Widowed       Single           Yes    
##  8 62180 male      35 White   College Gr… Married       Committed        Yes    
##  9 62186 female    17 Black   <NA>        <NA>          <NA>             Yes    
## 10 62190 female    15 Mexican <NA>        <NA>          <NA>             Yes    
## # … with 4,990 more rows, and 24 more variables: Income <dbl>, Poverty <dbl>,
## #   HomeRooms <dbl>, HomeOwn <chr>, Work <chr>, Weight <dbl>, Height <dbl>,
## #   BMI <dbl>, Pulse <dbl>, BPSys <dbl>, BPDia <dbl>, Testosterone <dbl>,
## #   HDLChol <dbl>, TotChol <dbl>, Diabetes <chr>, DiabetesAge <dbl>,
## #   nPregnancies <dbl>, nBabies <dbl>, SleepHrsNight <dbl>, PhysActive <chr>,
## #   PhysActiveDays <dbl>, AlcoholDay <dbl>, AlcoholYear <dbl>,
## #   SmokingStatus <chr>

Take a look at that output. The nice thing about loading dplyr and reading data with readr functions is that data are displayed in a much more friendly way. This dataset has 5,000 rows and 32 columns. When you import/convert data this way and try to display the object in the console, instead of trying to display all 5,000 rows, you’ll only see about 10 by default. Also, if you have so many columns that the data would wrap off the edge of your screen, those columns will not be displayed, but you’ll see at the bottom of the output which, if any, columns were hidden from view.

A note on characters versus factors: One thing that you immediately notice is that all the categorical variables are read in as character data types. This data type is used for storing strings of text, for example, IDs, names, descriptive text, etc. There’s another related data type called factors. Factor variables are used to represent categorical variables with two or more levels, e.g., “male” or “female” for Gender, or “Single” versus “Committed” for RelationshipStatus. For the most part, statistical analysis treats these two data types the same. It’s often easier to leave categorical variables as characters. However, in some cases you may get a warning message alerting you that a character variable was converted into a factor variable during analysis. Generally, these warnings are nothing to worry about. You can, if you like, convert individual variables to factor variables, or simply use dplyr’s mutate_if to convert all character vectors to factor variables:

nh <- nh %>% mutate_if(is.character, as.factor)
nh

Now just take a look at just a few columns that are now factors. Remember, you can look at individual variables with the mydataframe$specificVariable syntax.

nh$RelationshipStatus
nh$Race
levels(nh$Race)

If you want to see the whole dataset, there are two ways to do this. First, you can click on the name of the data.frame in the Environment panel in RStudio. Or you could use the View() function (with a capital V).

View(nh)

Recall several built-in functions that are useful for working with data frames.

  • Content:
    • head(): shows the first few rows
    • tail(): shows the last few rows
  • Size:
    • dim(): returns a 2-element vector with the number of rows in the first element, and the number of columns as the second element (the dimensions of the object)
    • nrow(): returns the number of rows
    • ncol(): returns the number of columns
  • Summary:
    • colnames() (or just names()): returns the column names
    • glimpse() (from dplyr): Returns a glimpse of your data, telling you the structure of the dataset and information about the class, length and content of each column
head(nh)
tail(nh)
dim(nh)
names(nh)
glimpse(nh)

Descriptive statistics

We can access individual variables within a data frame using the $ operator, e.g., mydataframe$specificVariable. Let’s print out all the Race values in the data. Let’s then see what are the unique values of each. Then let’s calculate the mean, median, and range of the Age variable.

# Display all Race values
nh$Race

# Get the unique values of Race
unique(nh$Race)
length(unique(nh$Race))
# Do the same thing the dplyr way
nh$Race %>% unique()
nh$Race %>% unique() %>% length()

# Age mean, median, range
mean(nh$Age)
median(nh$Age)
range(nh$Age)

You could also do the last few operations using dplyr, but remember, this returns a single-row, single-column tibble, not a single scalar value like the above. This is only really useful in the context of grouping and summarizing.

# Compute the mean age
nh %>% 
  summarize(mean(Age))

# Now grouped by other variables
nh %>% 
  group_by(Gender, Race) %>% 
  summarize(mean(Age))

The summary() function (note, this is different from dplyr’s summarize()) works differently depending on which kind of object you pass to it. If you run summary() on a data frame, you get some very basic summary statistics on each variable in the data.

summary(nh)

Missing data

Let’s try taking the mean of a different variable, either the dplyr way or the simpler $ way.

# the dplyr way: returns a single-row single-column tibble/dataframe
nh %>% summarize(mean(Income))

# returns a single value
mean(nh$Income)

What happened there? NA indicates missing data. Take a look at the Income variable.

# Look at just the Income variable
nh$Income

# Or view the dataset
# View(nh)

Notice that there are lots of missing values for Income. Trying to get the mean a bunch of observations with some missing data returns a missing value by default. This is almost universally the case with all summary statistics – a single NA will cause the summary to return NA. Now look at the help for ?mean. Notice the na.rm argument. This is a logical (i.e., TRUE or FALSE) value indicating whether or not missing values should be removed prior to computing the mean. By default, it’s set to FALSE. Now try it again.

mean(nh$Income, na.rm=TRUE)
## [1] 57078

The is.na() function tells you if a value is missing. Get the sum() of that vector, which adds up all the TRUEs to tell you how many of the values are missing.

is.na(nh$Income)
sum(is.na(nh$Income))

There are a few handy functions in the Tmisc package for summarizing missingness in a data frame. You can graphically display missingness in a data frame as holes on a black canvas with gg_na() (use ggplot2 to plot NA values), or show a table of all the variables and the missingness level with propmiss().

# Install if you don't have it already
# install.packages("Tmisc")

# Load Tmisc
library(Tmisc)
gg_na(nh)

propmiss(nh)
## # A tibble: 32 × 4
##    var                nmiss     n propmiss
##    <chr>              <dbl> <dbl>    <dbl>
##  1 id                     0  5000   0     
##  2 Gender                 0  5000   0     
##  3 Age                    0  5000   0     
##  4 Race                   0  5000   0     
##  5 Education           1416  5000   0.283 
##  6 MaritalStatus       1415  5000   0.283 
##  7 RelationshipStatus  1415  5000   0.283 
##  8 Insured                7  5000   0.0014
##  9 Income               377  5000   0.0754
## 10 Poverty              325  5000   0.065 
## # … with 22 more rows

Now, let’s talk about exploratory data analysis (EDA).

EDA

It’s always worth examining your data visually before you start any statistical analysis or hypothesis testing. We could spend an entire day on exploratory data analysis. The data visualization lesson covers this in much broader detail. Here we’ll just mention a few of the big ones: histograms and scatterplots.

Histograms

We can learn a lot from the data just looking at the value distributions of particular variables. Let’s make some histograms with ggplot2. Looking at BMI shows a few extreme outliers. Looking at weight initially shows us that the units are probably in kg. Replotting that in lbs with more bins shows a clear bimodal distribution. Are there kids in this data? The age distribution shows us the answer is yes.

library(ggplot2)
ggplot(nh, aes(BMI)) + geom_histogram(bins=30)

ggplot(nh, aes(Weight)) + geom_histogram(bins=30)

# In pounds, more bins
ggplot(nh, aes(Weight*2.2)) + geom_histogram(bins=80)

ggplot(nh, aes(Age)) + geom_histogram(bins=30)

Scatterplots

Let’s look at how a few different variables relate to each other. E.g., height and weight:

ggplot(nh, aes(Height, Weight, col=Gender)) + geom_point()

Let’s filter out all the kids, draw trend lines using a linear model:

nh %>% 
  filter(Age>=18) %>% 
  ggplot(aes(Height, Weight, col=Gender)) + 
    geom_point() + 
    geom_smooth(method="lm")

Check out the data visualization lesson for much more on this topic.

Exercise set 1

  1. What’s the mean 60-second pulse rate for all participants in the data?
## [1] 73.6
  1. What’s the range of values for diastolic blood pressure in all participants? (Hint: see help for min(), max(), and range() functions, e.g., enter ?range without the parentheses to get help).
## [1]   0 116
  1. What are the median, lower, and upper quartiles for the age of all participants? (Hint: see help for median, or better yet, quantile).
##   0%  25%  50%  75% 100% 
##    0   17   36   54   80
  1. What’s the variance and standard deviation for income among all participants?
## [1] 1.12e+09
## [1] 33490

Continuous variables

T-tests

First let’s create a new dataset from nh called nha that only has adults. To prevent us from making any mistakes downstream, let’s remove the nh object.

nha <- filter(nh, Age>=18)
rm(nh)
# View(nha)

Let’s do a few two-sample t-tests to test for differences in means between two groups. The function for a t-test is t.test(). See the help for ?t.test. We’ll be using the forumla method. The usage is t.test(response~group, data=myDataFrame).

  1. Are there differences in age for males versus females in this dataset?
  2. Does BMI differ between diabetics and non-diabetics?
  3. Do single or married/cohabitating people drink more alcohol? Is this relationship significant?
t.test(Age~Gender, data=nha)
## 
##  Welch Two Sample t-test
## 
## data:  Age by Gender
## t = 2, df = 3697, p-value = 0.06
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  -0.0278  2.2219
## sample estimates:
## mean in group female   mean in group male 
##                 47.1                 46.0
t.test(BMI~Diabetes, data=nha)
## 
##  Welch Two Sample t-test
## 
## data:  BMI by Diabetes
## t = -11, df = 407, p-value <2e-16
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  -5.56 -3.92
## sample estimates:
##  mean in group No mean in group Yes 
##              28.1              32.8
t.test(AlcoholYear~RelationshipStatus, data=nha)
## 
##  Welch Two Sample t-test
## 
## data:  AlcoholYear by RelationshipStatus
## t = 5, df = 2675, p-value = 6e-08
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  13.1 27.8
## sample estimates:
## mean in group Committed    mean in group Single 
##                    83.9                    63.5

See the heading, Welch Two Sample t-test, and notice that the degrees of freedom might not be what we expected based on our sample size. Now look at the help for ?t.test again, and look at the var.equal argument, which is by default set to FALSE. One of the assumptions of the t-test is homoscedasticity, or homogeneity of variance. This assumes that the variance in the outcome (e.g., BMI) is identical across both levels of the predictor (diabetic vs non-diabetic). Since this is rarely the case, the t-test defaults to using the Welch correction, which is a more reliable version of the t-test when the homoscedasticity assumption is violated.

A note on one-tailed versus two-tailed tests: A two-tailed test is almost always more appropriate. The hypothesis you’re testing here is spelled out in the results (“alternative hypothesis: true difference in means is not equal to 0”). If the p-value is very low, you can reject the null hypothesis that there’s no difference in means. Because you typically don’t know a priori whether the difference in means will be positive or negative (e.g., we don’t know a priori whether Single people would be expected to drink more or less than those in a committed relationship), we want to do the two-tailed test. However, if we only wanted to test a very specific directionality of effect, we could use a one-tailed test and specify which direction we expect. This is more powerful if we “get it right”, but much less powerful for the opposite effect. Notice how the p-value changes depending on how we specify the hypothesis. Again, the two-tailed test is almost always more appropriate.

# Two tailed
t.test(AlcoholYear~RelationshipStatus, data=nha)

# Difference in means is >0 (committed drink more)
t.test(AlcoholYear~RelationshipStatus, data=nha, alternative="greater")

# Difference in means is <0 (committed drink less)
t.test(AlcoholYear~RelationshipStatus, data=nha, alternative="less")

A note on paired versus unpaired t-tests: The t-test we performed here was an unpaired test. Here the males and females are different people. The diabetics and nondiabetics are different samples. The single and committed individuals are completely independent, separate observations. In this case, an unpaired test is appropriate. An alternative design might be when data is derived from samples who have been measured at two different time points or locations, e.g., before versus after treatment, left versus right hand, etc. In this case, a paired t-test would be more appropriate. A paired test takes into consideration the intra and inter-subject variability, and is more powerful than the unpaired test. See the help for ?t.test for more information on how to do this.

Wilcoxon test

Another assumption of the t-test is that data is normally distributed. Looking at the histogram for AlcoholYear shows that this data clearly isn’t.

ggplot(nha, aes(AlcoholYear)) + geom_histogram()

The Wilcoxon rank-sum test (a.k.a. Mann-Whitney U test) is a nonparametric test of differences in mean that does not require normally distributed data. When data is perfectly normal, the t-test is uniformly more powerful. But when this assumption is violated, the t-test is unreliable. This test is called in a similar way as the t-test.

wilcox.test(AlcoholYear~RelationshipStatus, data=nha)
## 
##  Wilcoxon rank sum test with continuity correction
## 
## data:  AlcoholYear by RelationshipStatus
## W = 1e+06, p-value = 2e-04
## alternative hypothesis: true location shift is not equal to 0

The results are still significant, but much less than the p-value reported for the (incorrect) t-test above. Also note in the help for ?wilcox.test that there’s a paired option here too.

Linear models

(See slides)

Analysis of variance and linear modeling are complex topics that deserve an entire semester dedicated to theory, design, and interpretation. A very good resource is An Introduction to Statistical Learning: with Applications in R by Gareth James, Daniela Witten, Trevor Hastie and Robert Tibshirani. The PDF of the book and all the R code used throughout are available free on the author’s website. What follows is a necessary over-simplification with more focus on implementation, and less on theory and design.

Where t-tests and their nonparametric substitutes are used for assessing the differences in means between two groups, ANOVA is used to assess the significance of differences in means between multiple groups. In fact, a t-test is just a specific case of ANOVA when you only have two groups. And both t-tests and ANOVA are just specific cases of linear regression, where you’re trying to fit a model describing how a continuous outcome (e.g., BMI) changes with some predictor variable (e.g., diabetic status, race, age, etc.). The distinction is largely semantic – with a linear model you’re asking, “do levels of a categorical variable affect the response?” where with ANOVA or t-tests you’re asking, “does the mean response differ between levels of a categorical variable?”

Let’s examine the relationship between BMI and relationship status (RelationshipStatus was derived from MaritalStatus, coded as Committed if MaritalStatus is Married or LivePartner, and Single otherwise). Let’s first do this with a t-test, and for now, let’s assume that the variances between groups are equal.

t.test(BMI~RelationshipStatus, data=nha, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  BMI by RelationshipStatus
## t = -2, df = 3552, p-value = 0.1
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  -0.7782  0.0955
## sample estimates:
## mean in group Committed    mean in group Single 
##                    28.5                    28.9

It looks like single people have a very slightly higher BMI than those in a committed relationship, but the magnitude of the difference is trivial, and the difference is not significant. Now, let’s do the same test in a linear modeling framework. First, let’s create the fitted model and store it in an object called fit.

fit <- lm(BMI~RelationshipStatus, data=nha)

You can display the object itself, but that isn’t too interesting. You can get the more familiar ANOVA table by calling the anova() function on the fit object. More generally, the summary() function on a linear model object will tell you much more. (Note this is different from dplyr’s summarize function).

fit
## 
## Call:
## lm(formula = BMI ~ RelationshipStatus, data = nha)
## 
## Coefficients:
##              (Intercept)  RelationshipStatusSingle  
##                   28.513                     0.341
anova(fit)
## Analysis of Variance Table
## 
## Response: BMI
##                      Df Sum Sq Mean Sq F value Pr(>F)
## RelationshipStatus    1     98    98.3    2.35   0.13
## Residuals          3552 148819    41.9
summary(fit)
## 
## Call:
## lm(formula = BMI ~ RelationshipStatus, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
## -12.81  -4.61  -0.95   3.29  52.09 
## 
## Coefficients:
##                          Estimate Std. Error t value Pr(>|t|)
## (Intercept)                28.513      0.139  205.44   <2e-16
## RelationshipStatusSingle    0.341      0.223    1.53     0.13
## 
## Residual standard error: 6.47 on 3552 degrees of freedom
##   (153 observations deleted due to missingness)
## Multiple R-squared:  0.00066,    Adjusted R-squared:  0.000379 
## F-statistic: 2.35 on 1 and 3552 DF,  p-value: 0.126

Go back and re-run the t-test assuming equal variances as we did before. Now notice a few things:

t.test(BMI~RelationshipStatus, data=nha, var.equal=TRUE)
  1. The p-values from all three tests (t-test, ANOVA, and linear regression) are all identical (p=0.1256). This is because they’re all identical: a t-test is a specific case of ANOVA, which is a specific case of linear regression. There may be some rounding error, but we’ll talk about extracting the exact values from a model object later on.
  2. The test statistics are all related. The t statistic from the t-test is 1.532, which is the same as the t-statistic from the linear regression. If you square that, you get 2.347, the F statistic from the ANOVA.
  3. The t.test() output shows you the means for the two groups, Committed and Single. Just displaying the fit object itself or running summary(fit) shows you the coefficients for a linear model. Here, the model assumes the “baseline” RelationshipStatus level is Committed, and that the intercept in a regression model (e.g., \(\beta_{0}\) in the model \(Y = \beta_{0} + \beta_{1}X\)) is the mean of the baseline group. Being Single results in an increase in BMI of 0.3413. This is the \(\beta_{1}\) coefficient in the model. You can easily change the ordering of the levels. See the help for ?factor, and check out the new forcats package, which provides tools for manipulating categorical variables.
# P-value computed on a t-statistic with 3552 degrees of freedom
# (multiply times 2 because t-test is assuming two-tailed)
2*(1-pt(1.532, df=3552))
## [1] 0.126
# P-value computed on an F-test with 1 and 3552 degrees of freedom
1-pf(2.347, df1=1, df2=3552)
## [1] 0.126

A note on dummy coding: If you have a \(k\)-level factor, R creates \(k-1\) dummy variables, or indicator variables, by default, using the alphabetically first level as baseline. For example, the levels of RelationshipStatus are “Committed” and “Single”. R creates a dummy variable called “RelationshipStatusSingle” that’s 0 if you’re committed, and 1 if you’re Single. The linear model is saying for every unit increase in RelationshipStatusSingle, i.e., going from committed to single, results in a 0.314-unit increase in BMI. You can change the ordering of the factors to change the interpretation of the model (e.g., treating Single as baseline and going from Single to Committed). We’ll do this in the next section.

ANOVA

Recap: t-tests are for assessing the differences in means between two groups. A t-test is a specific case of ANOVA, which is a specific case of a linear model. Let’s run ANOVA, but this time looking for differences in means between more than two groups.

Let’s look at the relationship between smoking status (Never, Former, or Current), and BMI.

fit <- lm(BMI~SmokingStatus, data=nha)
anova(fit)
## Analysis of Variance Table
## 
## Response: BMI
##                 Df Sum Sq Mean Sq F value  Pr(>F)
## SmokingStatus    2   1411     706      17 4.5e-08
## Residuals     3553 147551      42
summary(fit)
## 
## Call:
## lm(formula = BMI ~ SmokingStatus, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
## -12.56  -4.56  -1.06   3.32  51.74 
## 
## Coefficients:
##                     Estimate Std. Error t value Pr(>|t|)
## (Intercept)           27.391      0.245  111.97  < 2e-16
## SmokingStatusFormer    1.774      0.329    5.39  7.6e-08
## SmokingStatusNever     1.464      0.284    5.16  2.6e-07
## 
## Residual standard error: 6.44 on 3553 degrees of freedom
##   (151 observations deleted due to missingness)
## Multiple R-squared:  0.00947,    Adjusted R-squared:  0.00891 
## F-statistic:   17 on 2 and 3553 DF,  p-value: 4.54e-08

The F-test on the ANOVA table tells us that there is a significant difference in means between current, former, and never smokers (p=\(4.54 \times 10^{-8}\)). However, the linear model output might not have been what we wanted. Because the default handling of categorical variables is to treat the alphabetical first level as the baseline, “Current” smokers are treated as baseline, and this mean becomes the intercept, and the coefficients on “Former” and “Never” describe how those groups’ means differ from current smokers.

Back to dummy coding / indicator variables: SmokingStatus is “Current”, “Former”, and “Never.” By default, R will create two indicator variables here that in tandem will explain this variable.

Original SmokingStatus Indicator: SmokingStatusFormer Indicator: SmokingStatusNever
Current 0 0
Former 1 0
Never 0 1

What if we wanted “Never” smokers to be the baseline, followed by Former, then Current? Have a look at ?factor to relevel the factor levels.

# Look at nha$SmokingStatus
nha$SmokingStatus

# What happens if we relevel it? Let's see what that looks like.
relevel(nha$SmokingStatus, ref="Never")

# If we're happy with that, let's change the value of nha$SmokingStatus in place
nha$SmokingStatus <- relevel(nha$SmokingStatus, ref="Never")

# Or we could do this the dplyr way
nha <- nha %>% 
  mutate(SmokingStatus=relevel(SmokingStatus, ref="Never"))
# Re-fit the model
fit <- lm(BMI~SmokingStatus, data=nha)

# Optionally, show the ANOVA table
# anova(fit)

# Print the full model statistics
summary(fit)
## 
## Call:
## lm(formula = BMI ~ SmokingStatus, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
## -12.56  -4.56  -1.06   3.32  51.74 
## 
## Coefficients:
##                      Estimate Std. Error t value Pr(>|t|)
## (Intercept)            28.856      0.144  200.60  < 2e-16
## SmokingStatusCurrent   -1.464      0.284   -5.16  2.6e-07
## SmokingStatusFormer     0.309      0.263    1.17     0.24
## 
## Residual standard error: 6.44 on 3553 degrees of freedom
##   (151 observations deleted due to missingness)
## Multiple R-squared:  0.00947,    Adjusted R-squared:  0.00891 
## F-statistic:   17 on 2 and 3553 DF,  p-value: 4.54e-08

Notice that the p-value on the ANOVA/regression didn’t change, but the coefficients did. Never smokers are now treated as baseline. The intercept coefficient (28.856) is now the mean for Never smokers. The SmokingStatusFormer coefficient of .309 shows the apparent increase in BMI that former smokers have when compared to never smokers, but that difference is not significant (p=.24). The SmokingStatusCurrent coefficient of -1.464 shows that current smokers actually have a lower BMI than never smokers, and that this decrease is highly significant.

Finally, you can do the typical post-hoc ANOVA procedures on the fit object. For example, the TukeyHSD() function will run Tukey’s test (also known as Tukey’s range test, the Tukey method, Tukey’s honest significance test, Tukey’s HSD test (honest significant difference), or the Tukey-Kramer method). Tukey’s test computes all pairwise mean difference calculation, comparing each group to each other group, identifying any difference between two groups that’s greater than the standard error, while controlling the type I error for all multiple comparisons. First run aov() (not anova()) on the fitted linear model object, then run TukeyHSD() on the resulting analysis of variance fit.

TukeyHSD(aov(fit))
##   Tukey multiple comparisons of means
##     95% family-wise confidence level
## 
## Fit: aov(formula = fit)
## 
## $SmokingStatus
##                  diff    lwr    upr p adj
## Current-Never  -1.464 -2.130 -0.799 0.000
## Former-Never    0.309 -0.308  0.926 0.469
## Former-Current  1.774  1.002  2.546 0.000

This shows that there isn’t much of a difference between former and never smokers, but that both of these differ significantly from current smokers, who have significantly lower BMI.

Finally, let’s visualize the differences in means between these groups. The NA category, which is omitted from the ANOVA, contains all the observations who have missing or non-recorded Smoking Status.

ggplot(nha, aes(SmokingStatus, BMI)) + geom_boxplot() + theme_classic()

Linear regression

(See slides)

Linear models are mathematical representations of the process that (we think) gave rise to our data. The model seeks to explain the relationship between a variable of interest, our Y, outcome, response, or dependent variable, and one or more X, predictor, or independent variables. Previously we talked about t-tests or ANOVA in the context of a simple linear regression model with only a single predictor variable, \(X\):

\[Y = \beta_{0} + \beta_{1}X\]

But you can have multiple predictors in a linear model that are all additive, accounting for the effects of the others:

\[Y = \beta_{0} + \beta_{1}X_{1} + \beta_{2}X_{2} + \epsilon\]

  • \(Y\) is the response
  • \(X_{1}\) and \(X_{2}\) are the predictors
  • \(\beta_{0}\) is the intercept, and \(\beta_{1}\), \(\beta_{2}\) etc are coefficients that describe what 1-unit changes in \(X_{1}\) and \(X_{2}\) do to the outcome variable \(Y\).
  • \(\epsilon\) is random error. Our model will not perfectly predict \(Y\). It will be off by some random amount. We assume this amount is a random draw from a Normal distribution with mean 0 and standard deviation \(\sigma\).

Building a linear model means we propose a linear model and then estimate the coefficients and the variance of the error term. Above, this means estimating \(\beta_{0}, \beta_{1}, \beta_{2}\) and \(\sigma\). This is what we do in R.

Let’s look at the relationship between height and weight.

fit <- lm(Weight~Height, data=nha)
summary(fit)
## 
## Call:
## lm(formula = Weight ~ Height, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
## -40.34 -13.11  -2.66   9.31 127.97 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)
## (Intercept)   -73.71       5.08   -14.5   <2e-16
## Height          0.92       0.03    30.6   <2e-16
## 
## Residual standard error: 18.6 on 3674 degrees of freedom
##   (31 observations deleted due to missingness)
## Multiple R-squared:  0.203,  Adjusted R-squared:  0.203 
## F-statistic:  938 on 1 and 3674 DF,  p-value: <2e-16

The relationship is highly significant (P<\(2.2 \times 10^{-16}\)). The intercept term is not very useful most of the time. Here it shows us what the value of Weight would be when Height=0, which could never happen. The Height coefficient is meaningful – each one unit increase in height results in a 0.92 increase in the corresponding unit of weight. Let’s visualize that relationship:

ggplot(nha, aes(x=Height, y=Weight)) + geom_point() + geom_smooth(method="lm")

By default, this is only going to show the prediction over the range of the data. This is important! You never want to try to extrapolate response variables outside of the range of your predictor(s). For example, the linear model tells us that weight is -73.7kg when height is zero. We can extend the predicted model / regression line past the lowest value of the data down to height=0. The bands on the confidence interval tell us that the model is apparently confident within the regions defined by the gray boundary. But this is silly – we would never see a height of zero, and predicting past the range of the available training data is never a good idea.

ggplot(nha, aes(x=Height, y=Weight)) + 
  geom_point() + 
  geom_smooth(method="lm", fullrange=TRUE) + 
  xlim(0, NA) + 
  ggtitle("Friends don't let friends extrapolate.")

Multiple regression

Finally, let’s do a multiple linear regression analysis, where we attempt to model the effect of multiple predictor variables at once on some outcome. First, let’s look at the effect of physical activity on testosterone levels. Let’s do this with a t-test and linear regression, showing that you get the same results.

t.test(Testosterone~PhysActive, data=nha, var.equal=TRUE)
## 
##  Two Sample t-test
## 
## data:  Testosterone by PhysActive
## t = -2, df = 3436, p-value = 0.02
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  -34.81  -3.72
## sample estimates:
##  mean in group No mean in group Yes 
##               208               227
summary(lm(Testosterone~PhysActive, data=nha))
## 
## Call:
## lm(formula = Testosterone ~ PhysActive, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
##   -224   -196   -116    167   1588 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)
## (Intercept)     207.56       5.87   35.34   <2e-16
## PhysActiveYes    19.27       7.93    2.43    0.015
## 
## Residual standard error: 231 on 3436 degrees of freedom
##   (269 observations deleted due to missingness)
## Multiple R-squared:  0.00172,    Adjusted R-squared:  0.00142 
## F-statistic:  5.9 on 1 and 3436 DF,  p-value: 0.0152

In both cases, the p-value is significant (p=0.01516), and the result suggest that increased physical activity is associated with increased testosterone levels. Does increasing your physical activity increase your testosterone levels? Or is it the other way – will increased testosterone encourage more physical activity? Or is it none of the above – is the apparent relationship between physical activity and testosterone levels only apparent because both are correlated with yet a third, unaccounted for variable? Let’s throw Age into the model as well.

summary(lm(Testosterone~PhysActive+Age, data=nha))
## 
## Call:
## lm(formula = Testosterone ~ PhysActive + Age, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
##   -239   -197   -112    167   1598 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)
## (Intercept)    247.883     13.085   18.94  < 2e-16
## PhysActiveYes   13.674      8.081    1.69  0.09073
## Age             -0.800      0.232   -3.45  0.00057
## 
## Residual standard error: 231 on 3435 degrees of freedom
##   (269 observations deleted due to missingness)
## Multiple R-squared:  0.00516,    Adjusted R-squared:  0.00458 
## F-statistic:  8.9 on 2 and 3435 DF,  p-value: 0.000139

This shows us that after accounting for age that the testosterone / physical activity link is no longer significant. Every 1-year increase in age results in a highly significant decrease in testosterone, and since increasing age is also likely associated with decreased physical activity, perhaps age is the confounder that makes this relationship apparent.

Adding other predictors can also swing things the other way. We know that men have much higher testosterone levels than females. Sex is probably the single best predictor of testosterone levels in our dataset. By not accounting for this effect, our unaccounted-for variation remains very high. By accounting for Gender, we now reduce the residual error in the model, and the physical activity effect once again becomes significant. Also notice that our model fits much better (higher R-squared), and is much more significant overall.

summary(lm(Testosterone ~ PhysActive+Age+Gender, data=nha))
## 
## Call:
## lm(formula = Testosterone ~ PhysActive + Age + Gender, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
## -397.9  -31.0   -4.4   20.5 1400.9 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)
## (Intercept)     46.693      7.573    6.17  7.8e-10
## PhysActiveYes    9.275      4.462    2.08    0.038
## Age             -0.590      0.128   -4.60  4.3e-06
## Gendermale     385.199      4.351   88.53  < 2e-16
## 
## Residual standard error: 128 on 3434 degrees of freedom
##   (269 observations deleted due to missingness)
## Multiple R-squared:  0.697,  Adjusted R-squared:  0.697 
## F-statistic: 2.63e+03 on 3 and 3434 DF,  p-value: <2e-16

We’ve only looked at the summary() and anova() functions for extracting information from an lm class object. There are several other accessor functions that can be used on a linear model object. Check out the help page for each one of these to learn more.

Exercise set 2

  1. Is the average BMI different in single people versus those in a committed relationship? Perform a t-test.
  2. The Work variable is coded “Looking” (n=159), “NotWorking” (n=1317), and “Working” (n=2230).
    • Fit a linear model of Income against Work. Assign this to an object called fit. What does the fit object tell you when you display it directly?
    • Run an anova() to get the ANOVA table. Is the model significant?
    • Run a Tukey test to get the pairwise contrasts. (Hint: TukeyHSD() on aov() on the fit). What do you conclude?
    • Instead of thinking of this as ANOVA, think of it as a linear model. After you’ve thought about it, get some summary() statistics on the fit. Do these results jive with the ANOVA model?
  3. Examine the relationship between HDL cholesterol levels (HDLChol) and whether someone has diabetes or not (Diabetes).
    • Is there a difference in means between diabetics and nondiabetics? Perform a t-test without a Welch correction (that is, assuming equal variances – see ?t.test for help).
    • Do the same analysis in a linear modeling framework.
    • Does the relationship hold when adjusting for Weight?
    • What about when adjusting for Weight, Age, Gender, PhysActive (whether someone participates in moderate or vigorous-intensity sports, fitness or recreational activities, coded as yes/no). What is the effect of each of these explanatory variables?

Discrete variables

Until now we’ve only discussed analyzing continuous outcomes / dependent variables. We’ve tested for differences in means between two groups with t-tests, differences among means between n groups with ANOVA, and more general relationships using linear regression. In all of these cases, the dependent variable, i.e., the outcome, or \(Y\) variable, was continuous, and usually normally distributed. What if our outcome variable is discrete, e.g., “Yes/No”, “Mutant/WT”, “Case/Control”, etc.? Here we use a different set of procedures for assessing significant associations.

Contingency tables

The xtabs() function is useful for creating contingency tables from categorical variables. Let’s create a gender by diabetes status contingency table, and assign it to an object called xt. After making the assignment, type the name of the object to view it.

xt <- xtabs(~Gender+Diabetes, data=nha)
xt
##         Diabetes
## Gender     No  Yes
##   female 1692  164
##   male   1653  198

There are two useful functions, addmargins() and prop.table() that add more information or manipulate how the data is displayed. By default, prop.table() will divide the number of observations in each cell by the total. But you may want to specify which margin you want to get proportions over. Let’s do this for the first (row) margin.

# Add marginal totals
addmargins(xt)
##         Diabetes
## Gender     No  Yes  Sum
##   female 1692  164 1856
##   male   1653  198 1851
##   Sum    3345  362 3707
# Get the proportional table
prop.table(xt)
##         Diabetes
## Gender       No    Yes
##   female 0.4564 0.0442
##   male   0.4459 0.0534
# That wasn't really what we wanted. 
# Do this over the first (row) margin only.
prop.table(xt, margin=1)
##         Diabetes
## Gender       No    Yes
##   female 0.9116 0.0884
##   male   0.8930 0.1070

Looks like men have slightly higher rates of diabetes than women. But is this significant?

The chi-square test is used to assess the independence of these two factors. That is, if the null hypothesis that gender and diabetes are independent is true, the we would expect a proportionally equal number of diabetics across each sex. Males seem to be at slightly higher risk than females, but the difference is just short of statistically significant.

chisq.test(xt)
## 
##  Pearson's Chi-squared test with Yates' continuity correction
## 
## data:  xt
## X-squared = 3, df = 1, p-value = 0.06

An alternative to the chi-square test is Fisher’s exact test. Rather than relying on a critical value from a theoretical chi-square distribution, Fisher’s exact test calculates the exact probability of observing the contingency table as is. It’s especially useful when there are very small n’s in one or more of the contingency table cells. Both the chi-square and Fisher’s exact test give us p-values of approximately 0.06.

fisher.test(xt)
## 
##  Fisher's Exact Test for Count Data
## 
## data:  xt
## p-value = 0.06
## alternative hypothesis: true odds ratio is not equal to 1
## 95 percent confidence interval:
##  0.988 1.547
## sample estimates:
## odds ratio 
##       1.24

There’s a useful plot for visualizing contingency table data called a mosaic plot. Call the mosaicplot() function on the contingency table object. Note this is a built-in plot, not a ggplot2-style plot.

mosaicplot(xt, main=NA)

Let’s create a different contingency table, this time looking at the relationship between race and whether the person had health insurance. Display the table with marginal totals.

xt <- xtabs(~Race+Insured, data=nha)
addmargins(xt)
##           Insured
## Race         No  Yes  Sum
##   Asian      46  169  215
##   Black      86  330  416
##   Hispanic   89  151  240
##   Mexican   147  141  288
##   Other      33   65   98
##   White     307 2141 2448
##   Sum       708 2997 3705

Let’s do the same thing as above, this time showing the proportion of people in each race category having health insurance.

prop.table(xt, margin=1)
##           Insured
## Race          No   Yes
##   Asian    0.214 0.786
##   Black    0.207 0.793
##   Hispanic 0.371 0.629
##   Mexican  0.510 0.490
##   Other    0.337 0.663
##   White    0.125 0.875

Now, let’s run a chi-square test for independence.

chisq.test(xt)
## 
##  Pearson's Chi-squared test
## 
## data:  xt
## X-squared = 323, df = 5, p-value <2e-16

The result is highly significant. In fact, so significant, that the display rounds off the p-value to something like \(<2.2 \times 10^{-16}\). If you look at the help for ?chisq.test you’ll see that displaying the test only shows you summary information, but other components can be accessed. For example, we can easily get the actual p-value, or the expected counts under the null hypothesis of independence.

chisq.test(xt)$p.value
## [1] 9.75e-68
chisq.test(xt)$expected
##           Insured
## Race          No    Yes
##   Asian     41.1  173.9
##   Black     79.5  336.5
##   Hispanic  45.9  194.1
##   Mexican   55.0  233.0
##   Other     18.7   79.3
##   White    467.8 1980.2

We can also make a mosaic plot similar to above:

mosaicplot(xt, main=NA)

Logistic regression

(See slides)

What if we wanted to model the discrete outcome, e.g., whether someone is insured, against several other variables, similar to how we did with multiple linear regression? We can’t use linear regression because the outcome isn’t continuous – it’s binary, either Yes or No. For this we’ll use logistic regression to model the log odds of binary response. That is, instead of modeling the outcome variable, \(Y\), directly against the inputs, we’ll model the log odds of the outcome variable.

If \(p\) is the probability that the individual is insured, then \(\frac{p}{1-p}\) is the odds that person is insured. Then it follows that the linear model is expressed as:

\[log(\frac{p}{1-p}) = \beta_0 + \beta_1 x_1 + \cdots + \beta_k x_k\]

Where \(\beta_0\) is the intercept, \(\beta_1\) is the increase in the odds of the outcome for every unit increase in \(x_1\), and so on.

Logistic regression is a type of generalized linear model (GLM). We fit GLM models in R using the glm() function. It works like the lm() function except we specify which GLM to fit using the family argument. Logistic regression requires family=binomial.

The typical use looks like this:

mod <- glm(y ~ x, data=yourdata, family='binomial')
summary(mod)

Before we fit a logistic regression model let’s relevel the Race variable so that “White” is the baseline. We saw above that people who identify as “White” have the highest rates of being insured. When we run the logistic regression, we’ll get a separate coefficient (effect) for each level of the factor variable(s) in the model, telling you the increased odds that that level has, as compared to the baseline group.

#Look at Race. The default ordering is alphabetical
nha$Race

# Let's relevel that where the group with the highest rate of insurance is "baseline"
relevel(nha$Race, ref="White")

# If we're happy with that result, permanently change it
nha$Race <- relevel(nha$Race, ref="White")

# Or do it the dplyr way
nha <- nha %>% 
  mutate(Race=relevel(Race, ref="White"))

Now, let’s fit a logistic regression model assessing how the odds of being insured change with different levels of race.

fit <- glm(Insured~Race, data=nha, family="binomial")
summary(fit)
## 
## Call:
## glm(formula = Insured ~ Race, family = "binomial", data = nha)
## 
## Deviance Residuals: 
##    Min      1Q  Median      3Q     Max  
## -2.038   0.518   0.518   0.518   1.195  
## 
## Coefficients:
##              Estimate Std. Error z value Pr(>|z|)
## (Intercept)     1.942      0.061   31.82  < 2e-16
## RaceAsian      -0.641      0.177   -3.62    3e-04
## RaceBlack      -0.597      0.136   -4.41  1.1e-05
## RaceHispanic   -1.413      0.147   -9.62  < 2e-16
## RaceMexican    -1.984      0.133  -14.95  < 2e-16
## RaceOther      -1.264      0.222   -5.69  1.3e-08
## 
## (Dispersion parameter for binomial family taken to be 1)
## 
##     Null deviance: 3614.6  on 3704  degrees of freedom
## Residual deviance: 3336.6  on 3699  degrees of freedom
##   (2 observations deleted due to missingness)
## AIC: 3349
## 
## Number of Fisher Scoring iterations: 4

The Estimate column shows the log of the odds ratio – how the log odds of having health insurance changes at each level of race compared to White. The P-value for each coefficient is on the far right. This shows that every other race has significantly less rates of health insurance coverage. But, as in our multiple linear regression analysis above, are there other important variables that we’re leaving out that could alter our conclusions? Lets add a few more variables into the model to see if something else can explain the apparent Race-Insured association. Let’s add a few things likely to be involved (Age and Income), and something that’s probably irrelevant (hours slept at night).

fit <- glm(Insured ~ Age+Income+SleepHrsNight+Race, data=nha, family="binomial")
summary(fit)
## 
## Call:
## glm(formula = Insured ~ Age + Income + SleepHrsNight + Race, 
##     family = "binomial", data = nha)
## 
## Deviance Residuals: 
##    Min      1Q  Median      3Q     Max  
## -2.482   0.302   0.437   0.625   1.687  
## 
## Coefficients:
##                Estimate Std. Error z value Pr(>|z|)
## (Intercept)   -3.50e-01   2.92e-01   -1.20    0.230
## Age            3.37e-02   2.95e-03   11.43  < 2e-16
## Income         1.53e-05   1.54e-06    9.98  < 2e-16
## SleepHrsNight -1.76e-02   3.52e-02   -0.50    0.616
## RaceAsian     -4.55e-01   2.03e-01   -2.24    0.025
## RaceBlack     -2.39e-01   1.54e-01   -1.55    0.120
## RaceHispanic  -1.01e+00   1.64e-01   -6.18  6.6e-10
## RaceMexican   -1.40e+00   1.48e-01   -9.47  < 2e-16
## RaceOther     -9.89e-01   2.42e-01   -4.08  4.5e-05
## 
## (Dispersion parameter for binomial family taken to be 1)
## 
##     Null deviance: 3284.3  on 3395  degrees of freedom
## Residual deviance: 2815.0  on 3387  degrees of freedom
##   (311 observations deleted due to missingness)
## AIC: 2833
## 
## Number of Fisher Scoring iterations: 5

A few things become apparent:

  1. Age and income are both highly associated with whether someone is insured. Both of these variables are highly significant (\(P<2.2 \times 10^{-16}\)), and the coefficient (the Estimate column) is positive, meaning that for each unit increase in one of these variables, the odds of being insured increases by the corresponding amount.
  2. Hours slept per night is not meaningful at all.
  3. After accounting for age and income, several of the race-specific differences are no longer statistically significant, but others remain so.
  4. The absolute value of the test statistic (column called z value) can roughly be taken as an estimate of the “importance” of that variable to the overall model. So, age and income are the most important influences in this model; self-identifying as Hispanic or Mexican are also very highly important, hours slept per night isn’t important at all, and the other race categories fall somewhere in between.

There is much more to go into with logistic regression. This lesson only scratches the surface. Missing from this lesson are things like regression diagnostics, model comparison approaches, penalization, interpretation of model coefficients, fitting interaction effects, and much more. Alan Agresti’s Categorical Data Analysis has long been considered the definitive text on this topic. I also recommend Agresti’s Introduction to Categorical Data Analysis (a.k.a. “Agresti lite”) for a gentler introduction.

Exercise set 3

  1. What’s the relationship between diabetes and participating in rigorous physical activity or sports?
    • Create a contingency table with Diabetes status in rows and physical activity status in columns.
    • Display that table with margins.
    • Show the proportions of diabetics and nondiabetics, separately, who are physically active or not.
    • Is this relationship significant?
    • Create a mosaic plot to visualize the relationship.
  2. Model the same association in a logistic regression framework to assess the risk of diabetes using physical activity as a predictor.
    • Fit a model with just physical activity as a predictor, and display a model summary.
    • Add gender to the model, and show a summary.
    • Continue adding weight and age to the model. What happens to the gender association?
    • Continue and add income to the model. What happens to the original association with physical activity?

Power & sample size

(See slides)

This is a necessarily short introduction to the concept of power and sample size calculations. Statistical power, also sometimes called sensitivity, is defined as the probability that your test correctly rejects the null hypothesis when the alternative hypothesis is true. That is, if there really is an effect (difference in means, association between categorical variables, etc.), how likely are you to be able to detect that effect at a given statistical significance level, given certain assumptions. Generally there are a few moving pieces, and if you know all but one of them, you can calculate what that last one is.

  1. Power: How likely are you to detect the effect? (Usually like to see 80% or greater).
  2. N: What is the sample size you have (or require)?
  3. Effect size: How big is the difference in means, odds ratio, etc?

If we know we want 80% power to detect a certain magnitude of difference between groups, we can calculate our required sample size. Or, if we know we can only collect 5 samples, we can calculate how likely we are to detect a particular effect. Or, we can work to solve the last one - if we want 80% power and we have 5 samples, what’s the smallest effect we can hope to detect?

All of these questions require certain assumptions about the data and the testing procedure. Which kind of test is being performed? What’s the true effect size (often unknown, or estimated from preliminary data), what’s the standard deviation of samples that will be collected (often unknown, or estimated from preliminary data), what’s the level of statistical significance needed (traditionally p<0.05, but must consider multiple testing corrections).

T-test power/N

The power.t.test() empirically estimates power or sample size of a t-test for differences in means. If we have 20 samples in each of two groups (e.g., control versus treatment), and the standard deviation for whatever we’re measuring is 2.3, and we’re expecting a true difference in means between the groups of 2, what’s the power to detect this effect?

power.t.test(n=20, delta=2, sd=2.3)
## 
##      Two-sample t test power calculation 
## 
##               n = 20
##           delta = 2
##              sd = 2.3
##       sig.level = 0.05
##           power = 0.764
##     alternative = two.sided
## 
## NOTE: n is number in *each* group

What’s the sample size we’d need to detect a difference of 0.8 given a standard deviation of 1.5, assuming we want 80% power?

power.t.test(power=.80, delta=.8, sd=1.5)
## 
##      Two-sample t test power calculation 
## 
##               n = 56.2
##           delta = 0.8
##              sd = 1.5
##       sig.level = 0.05
##           power = 0.8
##     alternative = two.sided
## 
## NOTE: n is number in *each* group

Proportions power/N

What about a two-sample proportion test (e.g., chi-square test)? If we have two groups (control and treatment), and we’re measuring some outcome (e.g., infected yes/no), and we know that the proportion of infected controls is 80% but 20% in treated, what’s the power to detect this effect in 5 samples per group?

power.prop.test(n=5, p1=0.8, p2=0.2)
## 
##      Two-sample comparison of proportions power calculation 
## 
##               n = 5
##              p1 = 0.8
##              p2 = 0.2
##       sig.level = 0.05
##           power = 0.469
##     alternative = two.sided
## 
## NOTE: n is number in *each* group

How many samples would we need for 90% power?

power.prop.test(power=0.9, p1=0.8, p2=0.2)
## 
##      Two-sample comparison of proportions power calculation 
## 
##               n = 12.4
##              p1 = 0.8
##              p2 = 0.2
##       sig.level = 0.05
##           power = 0.9
##     alternative = two.sided
## 
## NOTE: n is number in *each* group

Also check out the pwr package which has power calculation functions for other statistical tests.

Function Power calculations for
pwr.2p.test() Two proportions (equal n)
pwr.2p2n.test() Two proportions (unequal n)
pwr.anova.test() Balanced one way ANOVA
pwr.chisq.test() Chi-square test
pwr.f2.test() General linear model
pwr.p.test() Proportion (one sample)
pwr.r.test() Correlation
pwr.t.test() T-tests (one sample, 2 sample, paired)
pwr.t2n.test() T-test (two samples with unequal n)

Exercise set 4

  1. You’re doing a gene expression experiment. What’s your power to detect a 2-fold change in a gene with a standard deviation of 0.7, given 3 samples? (Note - fold change is usually given on the \(log_2\) scale, so a 2-fold change would be a delta of 1. That is, if the fold change is 2x, then \(log_2(2)=1\), and you should use 1 in the calculation, not 2).
## [1] 0.271
  1. How many samples would you need to have 80% power to detect this effect?
## [1] 8.76
  1. You’re doing a population genome-wide association study (GWAS) looking at the effect of a SNP on disease X. Disease X has a baseline prevalence of 5% in the population, but you suspect the SNP might increase the risk of disease X by 10% (this is typical for SNP effects on common, complex diseases). Calculate the number of samples do you need to have 80% power to detect this effect, given that you want a genome-wide statistical significance of \(p<5\times10^{-8}\) to account for multiple testing.1 (Hint, you can expressed \(5\times10^{-8}\) in R using 5e-8 instead of .00000005).
## [1] 157589

Tidying models

(See slides)

We spent a lot of time in other lessons on tidy data, where each column is a variable and each row is an observation. Tidy data is easy to filter observations based on values in a column (e.g., we could get just adult males with filter(nha, Gender=="male" & Age>=18), and easy to select particular variables/features of interest by their column name.

Even when we start with tidy data, we don’t end up with tidy models. The output from tests like t.test or lm are not data.frames, and it’s difficult to get the information out of the model object that we want. The broom package bridges this gap.

Depending on the type of model object you’re using, broom provides three methods that do different kinds of tidying:

  1. tidy: constructs a data frame that summarizes the model’s statistical findings like coefficients and p-values.
  2. augment: add columns to the original data that was modeled, like predictions and residuals.
  3. glance: construct a concise one-row summary of the model with information like \(R^2\) that are computed once for the entire model.

Let’s go back to our linear model example.

# Try modeling Testosterone against Physical Activity, Age, and Gender.
fit <- lm(Testosterone~PhysActive+Age+Gender, data=nha)

# See what that model looks like:
summary(fit)
## 
## Call:
## lm(formula = Testosterone ~ PhysActive + Age + Gender, data = nha)
## 
## Residuals:
##    Min     1Q Median     3Q    Max 
## -397.9  -31.0   -4.4   20.5 1400.9 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)
## (Intercept)     46.693      7.573    6.17  7.8e-10
## PhysActiveYes    9.275      4.462    2.08    0.038
## Age             -0.590      0.128   -4.60  4.3e-06
## Gendermale     385.199      4.351   88.53  < 2e-16
## 
## Residual standard error: 128 on 3434 degrees of freedom
##   (269 observations deleted due to missingness)
## Multiple R-squared:  0.697,  Adjusted R-squared:  0.697 
## F-statistic: 2.63e+03 on 3 and 3434 DF,  p-value: <2e-16

What if we wanted to pull out the coefficient for Age, or the P-value for PhysActive? It gets pretty gross. We first have to coef(summary(lmfit)) to get a matrix of coefficients, the terms are still stored in row names, and the column names are inconsistent with other packages (e.g. Pr(>|t|) compared to p.value). Yuck!

coef(summary(fit))["Age", "Estimate"]
## [1] -0.59
coef(summary(fit))["PhysActiveYes", "Pr(>|t|)"]
## [1] 0.0377

Instead, you can use the tidy function, from the broom package, on the fit:

# Install the package if you don't have it
# install.packages("broom")

library(broom)
tidy(fit)
## # A tibble: 4 × 5
##   term          estimate std.error statistic  p.value
##   <chr>            <dbl>     <dbl>     <dbl>    <dbl>
## 1 (Intercept)     46.7       7.57       6.17 7.83e-10
## 2 PhysActiveYes    9.27      4.46       2.08 3.77e- 2
## 3 Age             -0.590     0.128     -4.60 4.28e- 6
## 4 Gendermale     385.        4.35      88.5  0

This gives you a data.frame with all your model results. The row names have been moved into a column called term, and the column names are simple and consistent (and can be accessed using $). These can be manipulated with dplyr just like any other data frame.

tidy(fit) %>% 
  filter(term!="(Intercept)") %>% 
  select(term, p.value) %>% 
  arrange(p.value)
## # A tibble: 3 × 2
##   term             p.value
##   <chr>              <dbl>
## 1 Gendermale    0         
## 2 Age           0.00000428
## 3 PhysActiveYes 0.0377

Instead of viewing the coefficients, you might be interested in the fitted values and residuals for each of the original points in the regression. For this, use augment, which augments the original data with information from the model. New columns begins with a . (to avoid overwriting any of the original columns).

# Augment the original data
# IF you get a warning about deprecated... purrr..., ignore. It's a bug that'll be fixed soon.
augment(fit) %>% head
## # A tibble: 6 × 11
##   .rownames Testosterone PhysActive   Age Gender .fitted .resid     .hat .sigma
##   <chr>            <dbl> <fct>      <dbl> <fct>    <dbl>  <dbl>    <dbl>  <dbl>
## 1 1                 47.5 No            43 female    21.3  26.2  0.000989   128.
## 2 2                643.  No            80 male     385.  258.   0.00185    127.
## 3 3                643.  No            80 male     385.  258.   0.00185    127.
## 4 4                 21.1 Yes           34 female    35.9 -14.8  0.000928   128.
## 5 5                563.  No            80 male     385.  178.   0.00185    128.
## 6 6                402.  No            35 male     411.   -9.45 0.00117    128.
## # … with 2 more variables: .cooksd <dbl>, .std.resid <dbl>
# Plot residuals vs fitted values for males, 
# colored by Physical Activity, size scaled by age
augment(fit) %>% 
  filter(Gender=="male") %>% 
  ggplot(aes(.fitted, .resid, col=PhysActive, size=Age)) + geom_point()

Finally, several summary statistics are computed for the entire regression, such as \(R^2\) and the F-statistic. These can be accessed with glance:

glance(fit)
## # A tibble: 1 × 12
##   r.squared adj.r.squared sigma statistic p.value    df  logLik    AIC    BIC
##       <dbl>         <dbl> <dbl>     <dbl>   <dbl> <dbl>   <dbl>  <dbl>  <dbl>
## 1     0.697         0.697  128.     2632.       0     3 -21545. 43100. 43130.
## # … with 3 more variables: deviance <dbl>, df.residual <int>, nobs <int>

The broom functions work on a pipe, so you can %>% your model directly to any of the functions like tidy(). Let’s tidy up our t-test:

t.test(AlcoholYear~RelationshipStatus, data=nha)
## 
##  Welch Two Sample t-test
## 
## data:  AlcoholYear by RelationshipStatus
## t = 5, df = 2675, p-value = 6e-08
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  13.1 27.8
## sample estimates:
## mean in group Committed    mean in group Single 
##                    83.9                    63.5
t.test(AlcoholYear~RelationshipStatus, data=nha) %>% tidy()
## # A tibble: 1 × 10
##   estimate estimate1 estimate2 statistic    p.value parameter conf.low conf.high
##      <dbl>     <dbl>     <dbl>     <dbl>      <dbl>     <dbl>    <dbl>     <dbl>
## 1     20.4      83.9      63.5      5.43    6.09e-8     2675.     13.1      27.8
## # … with 2 more variables: method <chr>, alternative <chr>

…and our Mann-Whitney U test / Wilcoxon rank-sum test:

wilcox.test(AlcoholYear~RelationshipStatus, data=nha)
## 
##  Wilcoxon rank sum test with continuity correction
## 
## data:  AlcoholYear by RelationshipStatus
## W = 1e+06, p-value = 2e-04
## alternative hypothesis: true location shift is not equal to 0
wilcox.test(AlcoholYear~RelationshipStatus, data=nha) %>% tidy()
## # A tibble: 1 × 4
##   statistic  p.value method                                          alternative
##       <dbl>    <dbl> <chr>                                           <chr>      
## 1  1067954. 0.000166 Wilcoxon rank sum test with continuity correct… two.sided

…and our Fisher’s exact test on the cross-tabulated data:

xtabs(~Gender+Diabetes, data=nha) %>% fisher.test()
## 
##  Fisher's Exact Test for Count Data
## 
## data:  .
## p-value = 0.06
## alternative hypothesis: true odds ratio is not equal to 1
## 95 percent confidence interval:
##  0.988 1.547
## sample estimates:
## odds ratio 
##       1.24
xtabs(~Gender+Diabetes, data=nha) %>% fisher.test() %>% tidy()
## # A tibble: 1 × 6
##   estimate p.value conf.low conf.high method                         alternative
##      <dbl>   <dbl>    <dbl>     <dbl> <chr>                          <chr>      
## 1     1.24  0.0599    0.988      1.55 Fisher's Exact Test for Count… two.sided

…and finally, a logistic regression model:

# fit the model and summarize it the usual way
glmfit <- glm(Insured~Race, data=nha, family=binomial)
summary(glmfit)
## 
## Call:
## glm(formula = Insured ~ Race, family = binomial, data = nha)
## 
## Deviance Residuals: 
##    Min      1Q  Median      3Q     Max  
## -2.038   0.518   0.518   0.518   1.195  
## 
## Coefficients:
##              Estimate Std. Error z value Pr(>|z|)
## (Intercept)     1.942      0.061   31.82  < 2e-16
## RaceAsian      -0.641      0.177   -3.62    3e-04
## RaceBlack      -0.597      0.136   -4.41  1.1e-05
## RaceHispanic   -1.413      0.147   -9.62  < 2e-16
## RaceMexican    -1.984      0.133  -14.95  < 2e-16
## RaceOther      -1.264      0.222   -5.69  1.3e-08
## 
## (Dispersion parameter for binomial family taken to be 1)
## 
##     Null deviance: 3614.6  on 3704  degrees of freedom
## Residual deviance: 3336.6  on 3699  degrees of freedom
##   (2 observations deleted due to missingness)
## AIC: 3349
## 
## Number of Fisher Scoring iterations: 4
# tidy it up!
tidy(glmfit)
## # A tibble: 6 × 5
##   term         estimate std.error statistic   p.value
##   <chr>           <dbl>     <dbl>     <dbl>     <dbl>
## 1 (Intercept)     1.94     0.0610     31.8  2.96e-222
## 2 RaceAsian      -0.641    0.177      -3.62 2.97e-  4
## 3 RaceBlack      -0.597    0.136      -4.41 1.05e-  5
## 4 RaceHispanic   -1.41     0.147      -9.62 6.47e- 22
## 5 RaceMexican    -1.98     0.133     -14.9  1.66e- 50
## 6 RaceOther      -1.26     0.222      -5.69 1.29e-  8
# do whatever you want now
tidy(glmfit) %>% 
  filter(term!="(Intercept)") %>% 
  mutate(logp=-1*log10(p.value)) %>% 
  ggplot(aes(term, logp)) + geom_bar(stat="identity") + coord_flip()

Check out some of the other broom vignettes on CRAN, and also check out the biobroom package on bioconductor for turning bioconductor objects and analytical results into tidy data frames.

Homework

Stress tests & muscular dystrophy genetics

Try this homework assignment.

There are two parts to this assignment, each using data curated and hosted by the Vanderbilt Department of Biostatistics. The first part looks at the effects of different doses of a drug used during echocardiograms called dobutamine. The second uses data collected to examine several blood serum markers believed to be associated with genetics for a specific kind of muscular dystrophy (DMD).

  1. https://www.quora.com/Why-is-P-value-5x10-8-chosen-as-a-threshold-to-reach-genome-wide-significance↩︎

This work is licensed under the CC BY-NC-SA 4.0 Creative Commons License.