Skip to Main Content
An official website of the United States government
Epidemiology and Genomics Research Program

Diet History Questionnaire: Analyze the Questionnaire Data

Alternate Version Available

You are viewing the web site for DHQ II. The latest version for the U.S. is the DHQ III; however, DHQ III does not yet have a Canadian version. The Canadian version of DHQ II is still available.

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 [TXT - 81 KB]

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 [TXT - 534 KB]

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 [TXT - 139 KB]