Chapter 7: Statistics Application
134
• Clear list variable data from list1 through list6 and initialize Stat Editor
window contents .................................................................................................................. Edit - Clear All
• Convert a mathematical expression in the currently selected cell to a decimal value ................................
9
• Display two, three, or four columns in the Stat Editor window* ...................................................
S
/
D
/
F
* You can also specify the number of display columns using the [Cell Width Pattern] setting on the [Special] tab
of the Graph Format dialog box (page 38).
Using CSV Files
You can import the contents of a CSV file stored with the ClassPad or transferred from a computer into the Stat
Editor. You also can save the contents of all the list data in the Stat Editor as a CSV file.
Import CSV File Requirements
A CSV file that has been output from the Stat Editor or Spreadsheet (Chapter 13), or a CSV file transferred from
a computer to storage memory can be used for import. The following types of CSV files are supported for import.
• A CSV file that uses the comma (,) or semi-colon (;) as its separator, and the period (.) or comma (,) as its
decimal symbol. A CSV file that uses the tab as its separator is not supported.
• CR, LF and CRLF are supported for the line break code.
For information about transferring files from a computer to the calculator, see “19-2 Performing Data
Communication between the ClassPad and a Personal Computer”.
Stat Editor Display and List Data Overwriting Following CSV File Import
When you import a CSV file into Stat Editor, everything displayed on the Stat Editor screen is cleared and
replaced with the imported CSV file data.
The first column of the CSV file data is imported into the Stat Editor column 1 list (list 1), the second column of
file data is imported into Stat Editor column 2 list (list 2), and so on. List data is created for each of the CSV file
columns. Any data previously stored in a list is overwritten by the imported data.
Except for data that is overwritten by the CSV file import, current list data cleared from the Stat Editor screen by
the import operation is retained in ClassPad memory.
u
To import the contents of a CSV file to the Stat Editor
1. Prepare the CSV file you want to import.
• See “Import CSV File Requirements” described above.
2. While the Stat Editor is on the display, tap [Edit] - [CSV] - [Open CSV].
3. On the dialog box that appears, select the CSV file you want to import and then tap [Open].
Important!
• Importing a CSV file that has a large number of rows and/or columns may cause an insufficient memory error.
If this happens, reduce the number of rows and/or columns in the CSV file.
• Following import, the contents of all cells that contain character strings are automatically replaced with 0.
u
To save the contents of all the list data in the Stat Editor as a single CSV file
1. While the Stat Editor is on the display, tap [Edit] - [CSV] - [Save CSV].
2. On the dialog box that appears, specify the export destination folder and then input a name for the export file.
3. Tap [Save].
Important!
The list name line and Cal
'
line are not output to the CSV file.