Find me
The Developmental Aspects of Sexual Health Laboratory
  • Home
  • People
  • Research Projects
  • Blog
  • Publications
  • Presentations

SPSS tip #1: Calculating the mean when some items are missing

1/24/2014

0 Comments

 
This post is NOT about multiple imputations or other types of sophisticated approaches to missing data. If that’s what you’re looking for, move right along. But if you want a simple technique for calculating a mean when you have some missing items from some participants, this syntax will change your life.

When calculating scale means, you almost always have a subset of participants who missed one or more items from the scale, but answered the majority of the questions.  And of course, not everyone is missing the same items, or the same # of items. My grad student a few years ago taught me this syntax, and it makes this situation easy to handle.

Come up with a decision rule for how many missing items are acceptable. Depending on the study/scale, I’ve seen rules of allowing 20% missing or allowing <50% missing. In the example below, we used the <50% rule, so for a 10 item scale, we required data from 6 or more items. With this syntax, SPSS will calculate the means for anyone who has 6 or more of the indicated variables not-missing:

COMPUTE ESTEEM_T=mean.6(ESTEEM1, ESTEEM2, ESTEEM3_R, ESTEEM4, ESTEEM5, ESTEEM6_R, ESTEEM7, ESTEEM8_R, ESTEEM9, ESTEEM10_R).

Done. I’m too embarrassed to share how we used to calculate it before I learned this syntax.

“The post SPSS tip #1: Calculating the mean when some items are missing first appeared on Eva Lefkowitz’s blog on January 24, 2014.”

0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Eva S. Lefkowitz

    I write about professional development issues (in HDFS and other areas), and occasionally sexuality research or other work-related topics. 

    Looking for a post doc? 
    List of HDFS-relevant post docs
    Looking for a fellowship? 
    List of HDFS relevant fellowships, scholarships, and grants
    Looking for an internship?
    List of HDFS-relevant internships
    Looking for a job?
    List of places to search for HDFS-relevant jobs

    Categories

    All
    Adolescent Development
    Being A Grad Student
    Conferences
    Excel
    Gmail
    Grant Proposals
    Job Market
    Mentoring
    Midcareer
    Networking
    PowerPoint
    Publishing
    Research
    Reviewing
    Sexual Health
    Social Media
    SPSS
    Teaching
    Theses & Dissertations
    Transitions
    Undergraduate Advice
    Word
    Work/life Balance
    Writing

    Archives

    February 2022
    May 2021
    January 2021
    July 2019
    June 2019
    May 2019
    January 2019
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    March 2018
    October 2017
    November 2016
    June 2016
    May 2016
    April 2016
    February 2016
    January 2016
    December 2015
    November 2015
    May 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013

    Tweets by @EvaLefkowitz

    RSS Feed

    View my profile on LinkedIn

    Enter your email address:

    Delivered by FeedBurner

    Blogs I Read

    Female Science Professor

    The Professor is in

    APA Style Blog

    Thinking About Kids

    Tenure She Wrote

    Prof Hacker

    Andrew Gelman

    Claire Kamp Dush
Proudly powered by Weebly