SPSS runs each analysis on all cases it can use for it. So how does SPSS analyze data if they contain missing values? Well, in most situations, The right way to do so is using a FILTER. Perhaps we'd better exclude it from the analyses over q1 to q9. We may doubt if this respondent filled out the questionnaire seriously. This is the Valid N (listwise) we saw in the descriptives table earlier on.Īlso note that 1 case has 8 missing values out of 9 variables. In this table, 0 means zero missing values over q1 to q9. *Inspect frequency distribution missing values. variable labels mis_1 'Missing values over q1 to q9'. *Set description of mis_1 as variable label. *Create new variable holding number of missing values over q1 to q9. Just make sure you add a description of what's in it -the number of missing.- as a variable label. We'll use a short and simple variable name: mis_1 is fine. In the example below, that'll be q1 to q9. This variable holds the number of missing values over a set of variables that we'd like to analyze together. Inspecting Missing Values per Caseįor inspecting if any cases have many missing values, we'll create a new variable. Let's now see if any cases -rows of cells in data view- have many missing values. Some procedures will use only those 309 cases -known as listwise exclusion of missing values in SPSS.Ĭonclusion: none of our variables -columns of cells in data view- have huge percentages of missingness. These are the cases without any missing values on all variables in this table. Importantly, note that Valid N (listwise) = 309. If any variables have high percentages of missingness, you may want to exclude them from -especially- multivariate analyses. Since we've 464 cases in total, (464 - N) is the number of missing values per variable. The N column shows the number of non missing values per variable. *Note: (464 - N) = number of missing values. The easiest way for doing so is running the syntax below. Make sure the output tables show both values and value labels. User Missing Values for Categorical VariablesĪ quick way for inspecting categorical variables is running frequency distributions and corresponding bar charts. Let's now see if any values should be set as user missing and how to do so.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |