SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  Help with missing data?

    Posted Mon November 20, 2023 09:52 AM

    Hi Everyone,
    I'm a bit new to SPSS and hit a bit of a barrier with regards to missing data values when attempting to generate a descriptive stats output from coded responses within a study participant survey and was hoping someone might have some insight on what I might be doing wrong. For some reason, SPSS is indicating that I have '20' missing values within the first set of survey questions (see first table, below), though my dataset is telling me I only have 14 missing values which I've indicated as '9999'. I've already specified discrete missing values as '9999' in the variable view for all questions, including this one (Question 1), so I'm not sure why SPSS is picking up an additional 6 missing values to make a total of 20? As you'll see in the second table pasted below, SPSS indicates those 6 'missing' values as 'system', so I'm not quite sure what that means or how to resolve it?     Any help or insight is so appreciated!!

    Thank you,

    Annie

    Statistics

    Question 1 

    N

    Valid

    267

    Missing

    20

    Mean

    2.21

    Median

    2.00

    Mode

    2

    Std. Deviation

    1.058

    Variance

    1.119

    Range

    4

    Minimum

    1

    Maximum

    5

    Question 1

    N

    %

    1

    77

    26.8%

    2

    99

    34.5%

    3

    59

    20.6%

    4

    23

    8.0%

    5

    9

    3.1%

    Missing

    9999

    14

    4.9%

    System

    6

    2.1%



    ------------------------------
    Annie
    ------------------------------


  • 2.  RE: Help with missing data?

    Posted Tue November 21, 2023 05:51 AM

    Hello there.

    You should check your data. Do they come from an Excel file?
    Sometimes, blank lines in Excel are imported in SPSS and count as system missing values.



    ------------------------------
    Patrick Henry-Lucet
    ------------------------------

    Original Message


  • 3.  RE: Help with missing data?

    Posted Tue November 21, 2023 06:02 AM

    Here are a few other possible causes to check...

    https://www.spss-tutorials.com/spss-missing-values/#spss-system-missing-values



    ------------------------------
    Jos Blykers
    ------------------------------

    Original Message


  • 4.  RE: Help with missing data?

    Posted Tue November 21, 2023 11:14 AM

    Hi Everyone,

    Thank you for your responses! I was able to resolve the issue as it looks like I made an oversight on my end by using a duplicate dataset where I had previously coded any missing values within my spreadsheet as '0' before importing it into SPSS. I therefore easily corrected the issue by re-assigning missing values as '0' in my variable view within SPSS.

    Thanks again for your help and insight!

    BW,

    Annie



    ------------------------------
    Annie
    ------------------------------

    Original Message