Calculator for working with data files

NOTE: The calculator begins by loading data from a comma-delimited text file in either "Vertical" or "Horizontal" format (see descriptions below). After loading the file, the calculator displays a menu of descriptive and inferential statistics options. Once an option is chosen and any needed additional data is provided, clicking the Computations button carries out the calculations for that option.

  Data file calculator: Calculator for data files

File layout description (Vertical format) . The file consists of the variables for the file, with the variables in columns. For each variable, the first entry is either N or C, indicating either a Numerical or a Categorical variable; the second entry is the variable name; the remaining entries are the individual values for that variable. For example, here is a file with 4 variables and 3 entries:
   C,C,C,N
   Name,Class year,Major,Current credits
   Joe,SR,MAT,17
   Sue,JR,BIS,15
   Mary,SO,ENG,15
These values are taken to be case-insensitive - for example, in the "Class year" variable the values "SR" and "sr" would be taken to be the same.

File layout description (Horizontal format) . Same as vertical format, but the variables are in rows. For example, here is the same file with 4 variables and 3 entries:
   C,Name,Joe,Sue,Mary
   C,Class year,SR,JR,SO
   C,Major,MAT,BIS,ENG
   N,Current credits,17,15,15

Optional first line.In either format, you may put a "comment" line before the first line of the data. If you do, that line will be ignored by the calculator. You could use that line to document any information about the file that you wish to include.