Comparing methods for handling missing values in food-frequency questionnaires and proposing k nearest neighbours imputation: effects on dietary intake in the Norwegian Women and Cancer study (NOWAC)

• Published in: Public health nutrition Vol. 11; no. 4; pp. 361 - 370
• Main Authors: Parr, Christine L, Hjartåker, Anette, Scheel, Ida, Lund, Eiliv, Laake, Petter, Veierød, Marit B
• Format: Journal Article
• Language: English
• Published: Cambridge, UK Cambridge University Press 01.04.2008
• Subjects: Aged; Bread; Cancer; Cohort Studies; Data Interpretation, Statistical; Diet; Diet - statistics & numerical data; Diet Surveys; Dietary intake; Energy; Energy intake; Epidemiology; Evidence-Based Medicine; Female; Fish oils; Food; Food intake; Humans; Investigations; Median (statistics); Middle Aged; Missing data; Norway; Nutrition; Nutrition research; Outcome Assessment (Health Care) - statistics & numerical data; Public health; Questionnaires; Reproducibility; Research Design - statistics & numerical data; Samples (statistical); Surveys and Questionnaires - standards; Variables; Norway; Food-frequency questionnaire; Imputation; Data quality; Missing values; Non-response; Bias
• ISSN: 1368-9800; 1475-2727
• DOI: 10.1017/S1368980007000365

To investigate item non-response in a postal food-frequency questionnaire (FFQ), and to assess the effect of substituting/imputing missing values on dietary intake levels in the Norwegian Women and Cancer study (NOWAC). We have adapted and probably for the first time applied k nearest neighbours (KNN) imputation to FFQ data. Data from a recent reproducibility study were used. The FFQ was mailed twice (test-retest) about 3 months apart to the same subjects. Missing responses in the test FFQ were imputed using the null value (frequencies = null, amount = smallest), the sample mode, the sample median, KNN, and retest values. A methodological substudy of NOWAC, a national population-based cohort. A random sample of 2000 women aged 46-75 years was drawn from the cohort in 2002 (response 75%). The imputation methods were compared for 1430 women who completed at least 50% of the test FFQ. We imputed 16% missing values in the overall test data matrix. Compared to null value imputation, the largest differences in estimated dietary intake were seen for KNN, and for food items with a high proportion of missing. Imputation with retest values increased total energy intake, indicating that not all missing values are caused by respondents failing to specify no consumption, and that null value imputation may lead to underestimation and misclassification. Missing values in FFQs present a methodological challenge. We encourage the application and evaluation of newer imputation methods, including KNN, which may reduce imputation errors and give more accurate intake estimates.