Missing Data

Today we will take a look at methods of dealing with missing data. SPSS offers pairwise deletion, which means only those cases with complete data are included in the analysis. It the missing data are few and a result of randomness, then such a plan may be acceptable. However, if they are not randomly missing, you could introduce biases.

A second commonly used method is substituting the overall sample's mean for the missing data. The logic of this is that in absence of any other information, the sample's mean is the best representation of an individual's score. If only a few scores are missing, then this may be an acceptable alternative. However, keep in mind that the more scores that are replaced, the more you are biasing the sample to the mean.

A third alternative is given by Osborne (2000, 2013) in which a prediction equation is developed through multiple regression. If you have quite a few missing scores, you may want to explore this alternative.

Osborn, J. W. (2013). Best practices in data cleaning. DC: Sage.

Osborn, J. W. (2000). Prediction in multiple regression. Practical Assessment, Research, & Evaluation, 7(2).

Next time we will consider missing data as a variable and best practices. Do you have an issue or a question that you would like me to discuss in a future post? Would you like to be a guest writer? Send me your ideas! leann.stadtlander@waldenu.edu

Categories of Missing Data

There are two categories of missing data, data that are missing at random (MAR) and data that are missing not at random (MNAR). If data are missing randomly, we can assume that they will not bias not the results. However, data missing not at random may be a strong biasing influence.

Let's use an example from Osborn (2013), of an employee satisfaction survey give to school teachers. The teachers are surveyed twice- once in September and once in June. Missing at random data would mean that data that were missing in June had no relationship to any variable from the September survey (such as satisfaction in Sept., age, years of teaching). An example, might be if we randomly selected 50% of the people who responded in September to again complete the survey in June- we would legitimately be missing half of the data in June (the 50% of people we did not ask). The missing data would be random and not related to a specific variable such as satisfaction, age, years teaching).

On the other hand, suppose only teachers that were satisfied responded to the survey in June (people who were dissatisfied were less likely to respond to the survey). Then the missing data are considered missing not at random (MNAR) and may substantially bias the results. Thus, the June survey would show a higher than expected satisfaction score (because unsatisfied people did not participate).

Next time we will consider how do deal with the missing data. Do you have an issue or a question that you would like me to discuss in a future post? Would you like to be a guest writer? Send me your ideas! leann.stadtlander@waldenu.edu

Osborn, J. W. (2013). Best practices in data cleaning. DC: Sage.

Making Data Make Sense- missing data

In almost any research study, there will be missing or incomplete data. Missing data can happen for a number of reasons: participants fail to respond to questions, subjects withdraw (or quit) studies before they are completed, and data entry errors.

The problem with missing data is that nearly all statistical techniques assume or require complete data. There can be legitimately missing data; an example might be a survey in which one is asked if he or she married, and if so how long. If you are not married, than you would be correct in leaving the "how long" portion of the question blank.

It is also important to realize that legitimately missing data can be meaningful. The missing data allows a validity check and may inform the status of an individual. Osborn (2013) proves a great example. In cleaning the data from an adolescent health risk survey, he noticed that some individuals indicated on one question that they had never used illegal drugs, but later in the survey when asked how many times they used marijuana, indicated an answer greater than 0. Therefore, an answer they should have skipped (or missing), showed an unexpected number. The author suggests several possible explanations, such as the subject was not paying attention and answered in error. However, a more intriguing possibility is that some subjects did not view marijuana as an illegal drug, which is an interesting possibility that could be examined in future search.

One way of dealing with legitimately missing data is making the missing and present data two separate groups. Using the marriage survey example, we could eliminate non-married individuals from a specific analysis when looking at issues related to being married vs. not married. So instead of asking the silly research question- "How long, on average, do all people, even unmarried people, stay married- we can ask two more refined questions: "What are the predictors of whether someone is currently married?" and "Of those who are currently married, how long on average have they been married?"

Next time we will consider categories of missing data. Do you have an issue or a question that you would like me to discuss in a future post? Would you like to be a guest writer? Send me your ideas! leann.stadtlander@waldenu.edu

Osborn, J. W. (2013). Best practices in data cleaning. DC: Sage.

Rewriting your dissertation into an article: Results section

Check out the new post on rewriting your dissertation into an article: http://jsbhseditorblog.blogspot.com/

Making Data Make Sense- data cleaning

What do I mean by data cleaning? There are many definitions, but I am talking about a two-step process. First, double-checking that all data points (cells) are filled, you will probably discover some are not and decisions will need to be on this.  The second step is carefully checking the statistical assumptions of your variables and looking for extreme scores.

Why are these steps necessary? Because the results of your study will only be as accurate as the data you analyze. Therefore, it is very important to take the time to check your data carefully, so that you know that your results are valid and accurate.

I want to refer you to a great book that much of my advice over the next few posts will be based:

Osborn, J. W. (2013). Best practices in data cleaning. DC: Sage. 

Next time we will look at the issue of missing data.  Do you have an issue or a question that you would like me to discuss in a future post? Would you like to be a guest writer? Send me your ideas! leann.stadtlander@waldenu.edu

Welcome to Summer Quarter!

Summer comes late to where I live, in Montana. By the first of June the trees are still leafing out, making us cherish these beautiful days when they come. What are you plans for the summer quarter related to your dissertation? It can be hard to set aside time for writing when there are so many other things clamoring for attention. My suggestion is to carefully make out a weekly plan, leading to your final quarter goal. Write in any family plans or commitments and realistically set weekly goals for yourself.

Another suggestion, if you have not yet done it, is to get my book on Amazon, Finding Your Way to a Ph.D.: Advice from the Dissertation Mentor, that guides you through the dissertation process. It discusses dealing with committee members, tips on writing each chapter and getting through the IRB process. I also include many motivational sections for those times when you need a little extra encouragement. The book has been selected for several courses to be taught at Walden, so get a jump on your peers and check it out. 

Make this quarter the one in which you make great progress and move ahead! Next time, we will begin a discussion on data cleaning. Do you have an issue or a question that you would like me to discuss in a future post? Send me an email with your ideas. leann.stadtlander@waldenu.edu

New Researcher Interview!

Check out the Researcher Interview with Walden's own Dr. Donna Heretick! http://jsbhseditorblog.blogspot.com/