Information Technology Reference
In-Depth Information
A.8 DATA VIEWOF THE DATA FILE
To display the DataView of the data file, click that choice in the bottom left
portion of the data file window (see Figure A4). You are now presented
with a spreadsheet. The rows are the cases or the participants and the
columns (now with names) are the variables. Now you are ready to type
your data into the cells. Use the arrow keys or the Ta b key to change the
location of the cursor. When you are finished, save the data file.
A.9 READING DATA FROM AN EXCEL WORKSHEET
Letusassumethatwehaveobtainedsomedatafromacolleaguethatis
in a Microsoft Excel file named sample data.xls . Assume that we want to
bring this data set into SPSS. The contents of the Excel file are shown in
Figure A9. This very small file contains four cases and four variables for
the sake of illustration; the variable names are contained in the first row
of the Excel Worksheet.
To import a file from Microsoft Excel (or other spreadsheets) from the
main SPSS menu, select File
Data .Thiswillopenanavigation
window to allow you to select the file containing the data. Choose the
file format on the drop-down menu for Excel (
Open
.xls) files to be read (see
Figure A10), navigate to your file, and click it Open .Verifyyourpathand,
if appropriate, check the box indicating that the variable names are in the
first row of the Excel file as shown in Figure A11 (it is a very convenient
feature to be able to obtain the variable names from the top row if they are
present in the Excel spreadsheet). Click OK and the data will now appear
in your SPSS data file (see Figure A12).
Figure A9
The Excel file that we want to bring into SPSS.
Search WWH ::




Custom Search