PC Datasets
Macintosh Datasets
Unix Datasets
Datasets from the Introduction to the Practice of Statistics, Second Edition
- Windows ASCII format (Zip archive)
- MacIntosh ASCII format (StuffIt archive)
Texas Instruments Calculators
TI-GRAPH LINK for both PC and Macintosh computers is an integrated communications
link, program editor, and data viewer for Texas Instruments Calculators (e.g., TI-83).
TI-GRAPH LINK software can be downloaded here.
Converting ASCII text files to SPSS
- Open the data set you wish to convert into SPSS in a text editor of your choice, notice the number of columns in the data file, one space or number in the SPSS conversion equals one column.
- Start SPSS, be sure a new Data file is open. If you are not sure a Data File is open, select File in the menu bar, select New, and then select Data.
- Select File on the menu bar, point to Read ASCII Data, then select Fixed Columns. The Define Fixed Variables dialog box should open.
- Select the file you wish to convert to SPSS by clicking the Browse button in the File section. The Define Fixed Variables: Browse dialog window should open.
- Select the file you wish to convert and click open. The file name and path should appear in the File section.
- There should be no variables defined in the Defined Variables text box, if there are click to select each variable and click the Remove button to remove the variable in question.
- Click the Name text box and enter a name of your choice for the title of the first column of data to be transferred.
- Click TAB to move to the Record text box. The numeral one should be entered, enter '1' if it is not.
- Click TAB to move to the Start Column text box and enter 1 as the first column of numerals is to be added.
- Click TAB to move to the End Column text box and enter the numeral for the column for the first group of numbers, remember SPSS reads each space as a column (i.e. the numeral 345 contains three SPSS columns, it would begin on column 1 and end on column 3).
- Select the Data Type for the variable, the default, Numeric as is, should be sufficient.
- Click the Add button, the defined variable should be listed, record number first, start column second, followed by the end column and the variable name.
- Click Name to enter the name of the second SPSS column, enter a name of your choice.
- Click TAB to move to the Record field and enter the numeral '1', if it is not set as the default.
- Click TAB to move to the Start Column field. Enter the numeral for the column for the next set of ASCII numerals, include all spaces. (i.e., if the first column of ASCII numbers is three spaces long equaling (three SPSS columns) and there are two spaces between the first and second number (two more SPSS columns) the second group of numbers would start on the sixth column). The list of numerals below illustrates this point.
Col
1 | Col
2 | Col
3 | Col
4 | Col
5 | Col
6 | Col
7 | Col
8 | Col
9 | Col
10 | Col
11 | Col
12 | Col
13 | Col
14 | Col
15 | Col
16 | Col
17 | Col
18 |
| 1 | 2 | 3 | | | | 5 | 6 | | | | 9 | 0 | | | 7 | 6 | 5 |
| | 3 | 4 | | | 5 | 6 | 7 | | | 2 | 3 | 4 | | | 9 | 0 | 8 |
The first space occupied or numeral '1' in the numeral '123' occupies column one to SPSS conversion. The '3' occupies column three. The next ASCII column, numeral '56' begins in SPSS column six since there are two spaces between the numbers. ASCII column begins in an empty space for the first row because the second contains a three digit numeral. The second ASCII column would then end on SPSS column 8. (Hint: Use the arrow keys to determine how many spaces separate the numerals in the ASCII columns)
- Click TAB to move to the End Column and add the number of spaces operated by that numeral. This will yield the End Column figure.
- Select the default data type if applicable and click the add button to enter the new defined variable. It should be listed beneath the previous variable defined in the Defined Variables text box.
- Continue to enter each set of numerals in this fashion until all ASCII columns are defined.
- Click OK in the Define Fixed Variables dialog. The data should then be entered into the SPSS spreadsheet.
- Click File and choose the Save As option to save your SPSS file.
Extra Note: Decimal numbers will round to the nearest whole number using this conversion method. The easiest way to expand these numerals to their full decimal notation is to manipulate the format after transfer. Select the column of numerals in question by clicking the column header in the SPSS spreadsheet. Click Data on the menu bar and select Define Variable. The Define Variable dialog will open. Select the Type button in the Change Settings section. The Define Variable Type dialog box will open. Be sure Numeric is the variable type selected and enter the number of decimal places desired in the Decimal Places text box. Click the Continue button and Click OK. The numeral should expand to the amount of decimal places set.
[TOP]
Moore & McCabe, Introduction to Practice of Statistics, 3rd Edition, 1998
W. H. Freeman & Co. and Sumanas, Inc.