Hi SPSS people, please help a newcomer who is working on simple moderation effect. I have found that my model with the interaction term is insignificant (p=.06), given that the option is exclude cases pairwise. When exclude cases listwise is applied, however, p=.03. Should I report both, or just one of the results, and why? If one, which one should it be, and why? Thank you very much.
Hi Fox
The choice between pairwise and listwise deletion of records is limited. The choice between these two types of deletion is not relevant when only one variable is being analyzed. In other situations, missing values may be treated as a valid category. If a record has a missing value for a crucial dependent variable, it probably cannot be used in the analysis. Pairwise vs. listwise is a different choice from the decision on whether to include or exclude user-defined missing values within a procedure.
Having limited the scope of pairwise vs. listwise deletion of records, the following describes when you may choose between these deletion types:
SPSS procedures will usually perform listwise deletion of records, especially the more advanced modeling procedures. You will not have a choice - the procedure will automatically perform listwise deletion of records.
Pairwise deletion is allowed in the following procedures: CORRELATIONS (pairwise is the default) NONPARR CORR (pairwise is the default) DESCRIPTIVES (pairwise, as subcommand VARIABLE, is the default) PARTIAL CORR (pairwise, as subcommand ANALYSIS, is the default) EXAMINE FACTOR QUICK CLUSTER REGRESSION
SPSS Statistics procedures offer the option INCLUDE on their MISSING sub commands. This option has nothing to do with list wise vs. pairwise deletion. It deals specifically with used defined missing values. If INCLUDE is specified, in effect user defined missing values for appropriate variables are turned off; those values are treated as valid data. This has no effect on system missing values.
I thought listwise was the default, by I see now that @Ajit is right:
https://www-01.ibm.com/support/docview.wss?uid=swg21475199
I suppose it must be because one of your independent variables included in the interaction has missing values. I don't think there is something wrong with the listwise choice. You should check if there is something specific reason for the missing values.
http://www.statisticssolutions.com/missing-data-listwise-vs-pairwise/
best
John-Kåre
Hi dear friend In my opinion, be sure to report both. Both p=0.06 and p=0.03 Note that you have reached the p=0.06 without deleting the data first and when you ignore the data to p=0.03 Writing all the details and reporting solutions can be useful. Both for you and the reader and the scholar who wants to do the same.
Thank you very much for your insight! I have checked the missing value. Both resulted will be reported.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS