• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Analysis Factor

The Analysis Factor

Statistical Consulting, Resources, and Statistics Workshops for Researchers

  • Home
  • Our Programs
    • Membership
    • Online Workshops
    • Free Webinars
    • Consulting Services
  • About
    • Our Team
    • Our Core Values
    • Our Privacy Policy
    • Employment
    • Collaborate with Us
  • Statistical Resources
  • Contact
  • Blog
  • Login

Missing Data Diagnosis in Stata: Investigating Missing Data in Regression Models

by Jeff Meyer Leave a Comment

by Jeff Meyer

In the last post, we examined how to use the same sample when running a set of regression models with different predictors.

Adding a predictor with missing data causes cases that had been included in previous models to be dropped from the new model.

Using different samples in different models can lead to very different conclusions when interpreting results.

Let’s look at how to investigate the effect of the missing data on the regression models in Stata.

The coefficient for the variable “frequent religious attendance” was negative 58 in model 3 and then rose to a positive 6 in model 4 when income was included. Results of model 3 alone, which didn’t control for income, leads us to conclude that frequent religious attendance is related to a lower mental health composite score (MHCS).

stata001

Recall that when we controlled for income our sample size decreased from 2,067 to 1,683.

So models 3 and 4 differ in two important ways: model 4 includes an additional covariate, but it also uses 384 fewer cases.

Is there a big difference between the 1,683 observations used in both models 3 and 4 and the 384 observations that were not used in model 4 but were included in model 3?

To examine the differences between the two samples I ran model 3 once more and generated a new dummy variable “in_model_3”.

gen in_model_3=e(sample)

I then created another dummy variable, which equals one if the observation is used in model 3 but not in model 4.

gen not_in_model4 =1 if in_model_3==1 & in_model_4==0

I then re-ran model 3 separately for these two groups:

  • the 384 subjects who have missing income data, so are not in model 4 (titled model_3d) and
  • the 1676 subjects who have full data, so were originally in both models (titled model_3e).

quietly reg MCS2000 UnemployedWksPastCal2000cont NumberBioStepAdoptChildHH2000 i.Mar_Status high_rel_attend if not_in_model4 ==1
estimates store model_3d

quietly reg MCS2000 UnemployedWksPastCal2000cont NumberBioStepAdoptChildHH2000 i.Mar_Status high_rel_attend if not_in_model4 ==0
estimates store model_3e

Below are the results of the two models:

stata002

The mean MHCS for the two groups are:

stat003

The mean MHCS for the two groups are very similar.

However, the coefficients for the variables used in the model, except for weeks jobless, are considerably different between the two groups.

That tells us that something is different between people who didn’t report their income and those who did. So we can’t just compare the coefficients across our original models—they don’t mean the same thing.

In another post, we’ll dig a little deeper into what might be going on here.

Jeff Meyer is a statistical consultant with The Analysis Factor, a stats mentor for Statistically Speaking membership, and a workshop instructor. Read more about Jeff here.

Bookmark and Share

Approaches to Missing Data: the Good, the Bad, and the Unthinkable
Learn the different methods for dealing with missing data and how they work in different missing data situations.

Tagged With: dummy variable, Linear Regression Model, Missing Data, regression coefficients, Stata

Related Posts

  • Linear Regression in Stata: Missing Data and the Stories it Might Tell
  • Multiple Imputation for Missing Data: Indicator Variables versus Categorical Variables
  • EM Imputation and Missing Data: Is Mean Imputation Really so Terrible?
  • Multiple Imputation in a Nutshell

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Please note that, due to the large number of comments submitted, any questions on problems related to a personal study/project will not be answered. We suggest joining Statistically Speaking, where you have access to a private forum and more resources 24/7.

Primary Sidebar

This Month’s Statistically Speaking Live Training

  • Member Training: Analyzing Pre-Post Data

Upcoming Free Webinars

Poisson and Negative Binomial Regression Models for Count Data

Upcoming Workshops

  • Analyzing Count Data: Poisson, Negative Binomial, and Other Essential Models (Jul 2022)
  • Introduction to Generalized Linear Mixed Models (Jul 2022)

Copyright © 2008–2022 The Analysis Factor, LLC. All rights reserved.
877-272-8096   Contact Us

The Analysis Factor uses cookies to ensure that we give you the best experience of our website. If you continue we assume that you consent to receive cookies on all websites from The Analysis Factor.
Continue Privacy Policy
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT