Data Viewer
Data Viewer
Data Viewer
6/18/2009
Data Viewer
Summary
The STATGRAPHICS Data Viewer allows the user to create a table showing all or part of the
currently loaded data. The data may be sorted based on up to 3 columns. The Select field may
also be used to display only a subset of the rows.
Sample Data:
The file 93cars.sgd contains information on 26 variables for n = 93 makes and models of
automobiles, taken from Lock (1993).
Data Input
To run the procedure, select Data Viewer from the Tools menu. Then complete the dialog box
shown below. If the 93cars.sgd file has been loaded into the first datasheet, you can display
several columns using the following input:
Primary, Secondary, Tertiary sort: optional columns on which to sort the data.
Select: subset selection used to display a subset of the rows in the datasheet.
For example, the dialog box above asks to display 6 columns of data, sorting the data first by
automobile Type, then by number of Passengers, and then by Mid Price. Only cars rated to
obtain at least 25 miles per gallon in city driving are listed.
Analysis Summary
The Analysis Summary summarizes the data that has been selected.
The top section shows the number of columns and rows that have been selected. The number of
complete cases (rows without any missing data in any of the selected columns) is also displayed.
The bottom section of the output displays a summary of each of the columns. Shown under
Unique Values is the number of different values that occur in the column.
Data Table
The Data Table pane displays the selected data:
Data Table
Row Make Model Type Passengers Mid Price MPG City
13 Chevrolet Corsica Compact 5 11.4 25
12 Chevrolet Cavalier Compact 5 13.4 25
55 Mazda 626 Compact 5 16.5 26
31 Ford Festiva Small 4 7.4 31
53 Mazda 323 Small 4 8.3 29
39 Geo Metro Small 4 8.4 46
80 Subaru Justy Small 4 8.4 33
83 Suzuki Swift Small 4 8.6 39
73 Pontiac LeMans Small 4 9 31
88 Volkswagen Fox Small 4 9.1 25
42 Honda Civic Small 4 12.1 42
44 Hyundai Excel Small 5 8 29
23 Dodge Colt Small 5 9.2 29
84 Toyota Tercel Small 5 9.8 32
62 Mitsubishi Mirage Small 5 10.3 29
81 Subaru Loyale Small 5 10.9 25
79 Saturn SL Small 5 11.1 28
54 Mazda Protege Small 5 11.6 28
64 Nissan Sentra Small 5 11.8 29
29 Eagle Summit Small 5 12.2 29
1 Acura Integra Small 5 15.9 25
46 Hyundai Scoupe Sporty 4 10 26
40 Geo Storm Sporty 4 12.5 30
85 Toyota Celica Sporty 4 18.4 25
Note that the rows have been sorted first by Type, then by Passengers within Type, and then by
Mid Price. All of the cars have a value of at least 25 for MPG City.
You can then paste the data into a STATGRAPHICS datasheet, an Excel worksheet, or another
application.