What is the difference between listwise and pairwise deletion?
PICTURE THIS: RAG CHATBOT
Simple meaning
Listwise deletion drops a whole row if any analysis variable is missing.
WHY — Missing Data instead of guessing?
Why interviewers care about Missing Data:
contrast on Missing Data, not two memorised paragraphs.
the developer, then one case where picking wrong hurts.
Name the idea, why it exists, then one short example.
End with when you use it and one common pitfall.
STEPS — What happens step by step?
Before you speak the answer, walk the interviewer through these steps:
- 1Listwise deletion drops a
whole row if any analysis variable is missing.
- 2Pairwise deletion uses all
rows that have the two variables needed for each correlation, so sample size varies by pair.
- 3Pairwise matrices can be
non-positive-definite and inconsistent, which is a hidden modeling hazard.
- 4Give an example
One tiny concrete case you can say aloud.
- 5Common mistake
What juniors usually get wrong.
- 6Close
When you pick this over the alternative.
EXAMPLE — See it in action
Here's a short line you can speak, broken into clear beats:
Note: Adapt this scaffold to your own project — keep it under 60–90 seconds.
Key takeaway
Listwise deletion drops a whole row if any analysis variable is missing. Pairwise deletion uses all rows that have the two variables needed for each correlation, so sample size varies by pair.