National Cancer Institute Home at the National Institutes of Health | www.cancer.gov

Diet History Questionnaire: Analyze the Questionnaire Data

Announcements

Alternate Version Available

You are viewing the Web site for the DHQ II, which is the latest version of the DHQ. You may want to see the original version of this information.

In Diet*Calc, once you have specified the questionnaire data file, data dictionary, and names and locations of the results files to be created by Diet*Calc, you can execute the session. Diet*Calc will calculate the food and nutrient estimates. Results are written to the Analysis Results File and to one or more optional results files.

Analysis Results File

The nutrient estimates calculated by Diet*Calc are written to the Analysis Results File in CSV (Comma Separated Values) format. The first row contains the column headers. Each subsequent row is one record for each questionnaire analyzed. These are data columns included in the Analysis Results File:

  • Respondent ID
  • Record Number
  • Sex
  • Age
  • Birth Date
  • Questionnaire Date
  • Num Missing Frequencies
  • Num Frequency Scanning Errors
  • Num Missing Sizes
  • Nutrient Estimates (a column of data per nutrient in the Nutrient Database)
  • Percent of Energy
  • Food Group Variables
  • Other Questions (optional - values from questionnaire data fields not analyzed by Diet*Calc)

View Sample Analysis Results File

Respondent Reports

The Respondent Reports file contains one report for each questionnaire respondent. Each Respondent Report may contain the following sections, which can be edited by selecting Report Options from the Options menu.

  • Personal Information
  • Introduction
  • Nutrient Intake
  • Percent of Energy
  • Food Pyramid Servings
  • Information sources

View Sample Respondent's Report

Detailed Results File

The Detailed Results File is a CSV file. This file contains the intermediate calculations of the analysis. You may use the data in this file to determine the contribution of a particular food item to the daily estimate of any or all nutrients. These columns are included in the Detailed Analysis File:

  • Respondent ID
  • Sex
  • Question Type
  • Question ID
  • Food ID
  • Size
  • Freq
  • Nutrient Estimates

View Sample Detailed Results File

Back to the Steps

Last Modified: 18 Oct 2013