Cold Deck and Hot Deck Imputation

Only available on StudyMode
  • Download(s) : 279
  • Published : January 29, 2013
Open Document
Text Preview
Hhld NoLine NoAgeSexRelationship to HeadMarital Status
11x112
1245222
1317131
1413131
15x274
2150112
22x222
2321111
2416111
3144112
3246222
33x231
3412231
4153211
4214231
43x244

ItemCodeDescription
Sex
1Male
2Female
Relationship to Head
1Head
2Spouse
3Child
4Parent
5Brother/Sister
6Other Relative
7Non Relative
Marital Status
1Single
2Married
3Divorced/Separated
4Widowed/Widower
5Others

Cold Deck for Age
HeadSpouseChildParentBrother/SisterOther RelativeNon Relative Male38351261292624
Female39411065313048

1.Show how missing values for age could be imputed using COLD deck imputation technique 2.Show how missing values for age could be imputed using HOT deck imputation technique.

Imputation using Cold Deck
-Imputation of missing values using a constant value from an external source

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
11x112

1st Missing Value – Base on the cold-deck data above the missing value will be imputed with the Cold-Deck age for Male and Head of Household which is 38

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112
1245222
1317131
1413131
15x274

2nd Missing Value – Missing value will be imputed with the Cold-Deck age for Non Relative Female member of the household which is 48 years old.

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112
1245222
1317131
1413131
1548274
2150112
22x222

3rd Missing Value – Missing value will be imputed with Cold-Deck age for Female Spouse which is 41.

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112
1245222
1317131
1413131
1548274
2150112
2241222
2321111
2416111
3144112
3246222
33x231

4th Missing Value – Missing Value will be imputed with cold-deck age for Female Child which is 10 years old.

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112
1245222
1317131
1413131
1548274
2150112
2241222
2321111
2416111
3144112
3246222
3310231
3412231
4153211
4214231
43x244

5th Missing Value – Missing Value will be imputed with cold-deck value for female parent which is 65 years old

COLD-DECK IMPUTED DATA
Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112
1245222
1317131
1413131
1548274
2150112
2241222
2321111
2416111
3144112
3246222
3310231
3412231
4153211
4214231
4365244

Imputation using Hot Deck
-Imputation of missing values using a continuously updated value from previously encoded data set

Cold Deck for Age
HeadSpouseChildParentBrother/SisterOther RelativeNon Relative Male38351261292624
Female39411065313048

1st Value
Hhld NoLine NoAgeSexRelationship to HeadMarital Status
11x112

Since value is missing, use the current value from the existing cold-deck. Age for Male Household which is 38

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112

Cold-deck value is retained

2nd Value

Cold Deck for Age
HeadSpouseChildParentBrother/SisterOther RelativeNon Relative Male38351261292624
Female39411065313048

Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112
1245222

With valid value for female spouse Cold Deck value will be replaced

Cold Deck for Age
HeadSpouseChildParentBrother/SisterOther RelativeNon Relative Male38351261292624
Female3941 => 451065313048

3rd Value
Hhld NoLine NoAgeSexRelationship to HeadMarital Status
1138112...
tracking img