• 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

  • our programs
    • Membership
    • Online Workshops
    • Free Webinars
    • Consulting Services
  • statistical resources
  • blog
  • about
    • Our Team
    • Our Core Values
    • Our Privacy Policy
    • Employment
    • Collaborate with Us
  • contact
  • login

Missing Data

Confusing Statistical Term #13: Missing at Random and Missing Completely at Random

by Karen Grace-Martin  4 Comments

Stage 2One of the important issues with missing data is the missing data mechanism. You may have heard of these: Missing Completely at Random (MCAR), Missing at Random (MAR), and Missing Not at Random (MNAR).

The mechanism is important because it affects how much the missing data bias your results. This has a big impact on what is a reasonable approach to dealing with the missing data.  So you have to take it into account in choosing an approach.

The concepts of these mechanisms can be a bit abstract.missing data

And to top it off, two of these mechanisms have really confusing names: Missing Completely at Random and Missing at Random.

Missing Completely at Random (MCAR)

Missing Completely at Random is pretty straightforward.  What it means is what is [Read more…] about Confusing Statistical Term #13: Missing at Random and Missing Completely at Random

Tagged With: MAR, MCAR, missing at random, missing completely at random, Missing Data

Related Posts

  • Missing Data Mechanisms: A Primer
  • When Listwise Deletion works for Missing Data
  • How to Diagnose the Missing Data Mechanism
  • Multiple Imputation in a Nutshell

Best Practices for Data Preparation

by Audrey Schnell  1 Comment

If you’ve been doing data analysis for long, you’ve probably had the ‘AHA’ moment where you realized statistical practice is a craft and not just a science. As with any craft, there are best practices that will save you a lot of pain and suffering and elevate the quality of your work. And yet, it’s likely that no one may have taught you these. I know I never had a class on this. [Read more…] about Best Practices for Data Preparation

Tagged With: best practices, data cleaning, data preparation, Missing Data, syntax

Related Posts

  • Best Practices for Organizing your Data Analysis
  • Preparing Data for Analysis is (more than) Half the Battle
  • Three Habits in Data Analysis That Feel Efficient, Yet are Not
  • Member Training: Data Cleaning

Multiple Imputation in a Nutshell

by Karen Grace-Martin  1 Comment

Updated 9/20/2021

Imputation as an approach to missing data has been around for decades.

You probably learned about mean imputation in methods classes, only to be told to never do it for a variety of very good reasons. Mean imputation, in which each missing value is replaced, or imputed, with the mean of observed values of that variable, is not the only type of imputation, however.

Two Criteria for Better Imputations

Better, although still problematic, imputation methods have two qualities. They use other variables in the data set to predict the missing value, and they contain a random component.

Using other variables preserves the relationships among variables in the imputations. It feels like cheating, but it isn’t. It ensures that any estimates of relationships using the imputed variable are not too low. Sure, underestimates are conservatively biased, but they’re still biased.

The random component is important so that all missing values of a single variable are not exactly equal. Why is that important? If all imputed values are equal, standard errors for statistics using that variable will be artificially low.

There are a few different ways to meet these criteria. One example would be to use a regression equation to predict missing values, then add a random error term.

Although this approach solves many of the problems inherent in mean imputation, one problem remains. Because the imputed value is an estimate–a predicted value–there is uncertainty about its true value. Every statistic has uncertainty, measured by its standard error. Statistics computed using imputed data have even more uncertainty than their standard errors measure.

Your statistical package cannot distinguish between an imputed value and a real value.

Since the standard errors of statistics based on imputed values are too small, corresponding p-values are also too small. P-values that are reported as smaller than they actually are? Those lead to Type I errors.

How Multiple Imputation Works

Multiple imputation solves this problem by incorporating the uncertainty inherent in imputation. It has four steps:

  1. Create m sets of imputations for the missing values using a good imputation process. This means it uses information from other variables and has a random component.
  2. The result is m full data sets. Each data set will have slightly different values for the imputed data because of the random component.
  3. Analyze each completed data set. Each set of parameter estimates will differ slightly because the data differs slightly.
  4. Combine results, calculating the variation in parameter estimates.

Remarkably, m, the number of sufficient imputations, can be only 5 to 10 imputations, although it depends on the percentage of data that are missing. A good multiple imputation model results in unbiased parameter estimates and a full sample size.

Doing multiple imputation well, however, is not always quick or easy. First, it requires that the missing data be missing at random. Second, it requires a very good imputation model. Creating a good imputation model requires knowing your data very well and having variables that will predict missing values.

Tagged With: mean imputation, Missing Data, missing data mechanism, Multiple Imputation, S-Plus, SAS, SPSS

Related Posts

  • Two Recommended Solutions for Missing Data: Multiple Imputation and Maximum Likelihood
  • EM Imputation and Missing Data: Is Mean Imputation Really so Terrible?
  • SPSS, SAS, R, Stata, JMP? Choosing a Statistical Software Package or Two
  • Statistical Software Access From Home

Member Training: A (Gentle) Introduction to k-Nearest Neighbor

by TAF Support 

Missing data is a common problem in data analysis. One of the successful approaches is k-Nearest Neighbor (kNN), a simple approach that leverages known information to impute unknown values with a relatively high degree of accuracy. [Read more…] about Member Training: A (Gentle) Introduction to k-Nearest Neighbor

Tagged With: k-nearest neighbor, machine learning, Missing Data

Related Posts

  • Member Training: Multiple Imputation for Missing Data
  • Member Training: Data Cleaning
  • Seven Ways to Make up Data: Common Methods to Imputing Missing Data
  • Confusing Statistical Term #13: Missing at Random and Missing Completely at Random

Missing Data Mechanisms: A Primer

by Karen Grace-Martin  3 Comments

Missing data are a widespread problem, as most researchers can attest. Whether data are from surveys, experiments, or secondary sources, missing data abounds.

But what’s the impact on the results of statistical analysis? That depends on two things: the mechanism that led the data to be missing and the way in which the data analyst deals with it.

Here are a few common situations:

Subjects in longitudinal studies often start, but drop out before the study is completed. There are many reasons for this:   they have moved out of the area (nothing related to the study), died (hopefully not related to the study), no longer see personal benefit to participating, or do not like the effects of the treatment.

Surveys suffer missing data in many ways. When participants refuse to answer the entire survey or parts of it; do not know the answer to, or accidentally skip an item. Some survey researchers even design the study so that some questions are asked of only a subset of participants.

Experimental studies have missing data when a researcher is simply unable to collect an observation. Bad weather conditions may render observation impossible in field experiments. A researcher becomes sick or equipment fails. Data may be missing in any type of study due to accidental or data entry error. A researcher drops a tray of test tubes. A data file becomes corrupt.

Most researchers are very familiar with one (or more) of these situations.

Why Missing Data Matters

Missing data cause problems because most statistical procedures require a value for each variable. When a data set is incomplete, the data analyst has to decide how to deal with it.

The most common decision is to use complete case analysis (also called listwise deletion). This means analyzing only the cases with complete data. Individuals with data missing on any variables are dropped from the analysis.

It has advantages–it is easy to use, is very simple, and is the default in most statistical packages. But it has limitations.

It can substantially lower the sample size, leading to a severe lack of power. This is especially true if there are many variables involved in the analysis, each with data missing for a few cases.

Possibly worse, it can also lead to biased results, depending on why and in which patterns the data are missing.

Missing Data Mechanisms

The types of missing data fit into three classes, which are based on the relationship between the missing data mechanism and the missing and observed values. These badly-named classes are important to understand because the problems caused by missing data and the solutions to these problems are different for the three classes.

Missing Completely at Random

The first is Missing Completely at Random (MCAR). MCAR means that the missing data mechanism is unrelated to the values of any variables, whether missing or observed.

Data that are missing because a researcher dropped the test tubes or survey participants accidentally skipped questions are likely to be MCAR.

If the observed values are essentially a random sample of the full data set, complete case analysis gives the same results as the full data set would have. Unfortunately, most missing data are not MCAR.

Missing Not at Random

At the opposite end of the spectrum is Missing Not at Random. Although you’ll most often see it called this, I prefer the term Non-Ignorable (NI). NI is a name that is not so easy to confuse with the other types, but it also tells you its primary feature. It means that the missing data mechanism is related to the missing values.

And this is something you, the data analyst, can’t ignore without biasing results.

It occurs sometimes when people do not want to reveal something very personal or unpopular about themselves. For example, if individuals with higher incomes are less likely to reveal them on a survey than are individuals with lower incomes, the missing data mechanism for income is non-ignorable. Whether income is missing or observed is related to its value.

But that’s not the only example. When the sickest patients drop out of a longitudinal study testing a drug that’s supposed to make them healthy, that’s non-ignorable.

Or an instrument can’t detect low readings, so gives you an error, also non-ignorable.

Complete case analysis can give highly biased results for NI missing data. If proportionally more low and moderate income individuals are left in the sample because high income people are missing, an estimate of the mean income will be lower than the actual population mean.

Missing at Random

In between these two extremes is Missing at Random (MAR). MAR requires that the cause of the missing data is unrelated to the missing values but may be related to the observed values of other variables.

MAR means that the missing values are related to observed values on other variables. As an example of CD missing data, missing income data may be unrelated to the actual income values but are related to education. Perhaps people with more education are less likely to reveal their income than those with less education.

A key distinction is whether the mechanism is ignorable (i.e., MCAR or MAR) or non-ignorable. There are excellent techniques for handling ignorable missing data. Non-ignorable missing data are more challenging and require a different approach.

 

First Published 2/24/2014;
Updated 5/11/21 to give more detail.

Tagged With: listwise deletion, MAR, MCAR, missing at random, missing completely at random, Missing Data

Related Posts

  • Confusing Statistical Term #13: Missing at Random and Missing Completely at Random
  • When Listwise Deletion works for Missing Data
  • How to Diagnose the Missing Data Mechanism
  • Do Top Journals Require Reporting on Missing Data Techniques?

Member Training: Missing Data

by TAF Support 

Missing data causes a lot of problems in data analysis. Unfortunately, some of the “solutions” for missing data cause more problems than they solve.

[Read more…] about Member Training: Missing Data

Tagged With: data issues, listwise deletion, mean imputation, Missing Data, Multiple Imputation

Related Posts

  • Member Training: Elements of Experimental Design
  • Member Training: Hierarchical Regressions
  • Member Training: Centering
  • Member Training: Multiple Imputation for Missing Data

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 6
  • Go to Next Page »

Primary Sidebar

This Month’s Statistically Speaking Live Training

  • Member Training: Multinomial Logistic Regression

Upcoming Workshops

    No Events

Upcoming Free Webinars

TBA

Quick links

Our Programs Statistical Resources Blog/News About Contact Log in

Contact

Upcoming

Free Webinars Membership Trainings Workshops

Privacy Policy

Search

Copyright © 2008–2023 The Analysis Factor, LLC.
All rights reserved.

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