Public Health Emergency Preparedness
This resource was part of AHRQ's Public Health Emergency Preparedness program, which was discontinued on June 30, 2011, in a realignment of Federal efforts.
This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: https://info.ahrq.gov. Let us know the nature of the problem, the Web address of what you want, and your contact information.
Please go to www.ahrq.gov for current information.
2.3. How to Download and Import Data
The individual who is responsible for downloading and analyzing the data may be either
the Questionnaire Administrator or a data analyst. For convenience, we will use
the term "analyst" here.
There are two distinct steps associated with downloading and importing data. First,
the data must be downloaded from the Web site onto the analyst's hard drive.
Second, that downloaded data must be imported into a tool for analysis. The downloaded
questionnaire response data can be imported into three tools. These include
Microsoft® (MS) Excel, MS Access, or various statistical analysis packages, such
as SPSS®. Because of the large amount of data collected from the questionnaire,
MS Excel and MS Access will not accommodate the data export in one file; the
analyst will need to import the data into two separate files. Most statistical
packages, including SPSS, will accept the volume of data in one file. Instructions
for these three options are included in the sections below. For those using a
statistical analysis package, we provide import instructions only for SPSS,
which is one of the most common analysis packages. If another analysis package
will be used, the analyst should consult the help function of that tool for
instructions on importing data.
2.3.1. Downloading and Importing Data into MS Excel
As described above, the large volume of data will not import into one Excel
spreadsheet. For that reason, the data is divided into two comma separated
values (.csv) files. To use MS Excel, simply select "Download Data Part 1,"
and save the .csv file to your hard drive. This file will contain data for the
unique ID number, all the demographic questions, and questionnaire questions 1
through 20. To view and manipulate this data in MS Excel, double click the .csv
file, and it will open in MS Excel. Next, select "Download Data Part 2," and
save the .csv file to your hard drive. Open the saved .csv file in MS Excel. The file
will provide the data for the unique ID number and questionnaire questions 21 through 43.
Return to Contents
Proceed to Next Section