Data File Layout

The file layout used is a rectangular grid in which each column represents a Variable or measure. These variables data can be text or numbers. You can highlight these data sets and paste them into the Data Editor.

To Include Variable Names

As on option, the first line of the data file may be used for Variable names. Variable names may contain any characters except spaces. See Editing Column Names. First a check is performed one the first line to see if nonnumeric text is found. If so, you will be asked if you wish to use the first line as Variable Names. These variables names will be assigned to their respective columns.

To Include Specifications and Titles

Specifications and titles may be entered as follows (name: value).

TITLE:Temperature
USL:1.35
TARGET:1.28
LSL:1.21

Data Configurations

There are multiple configurations that may be use for the layout of the data. Here are three alternative cases and the layout methods that may be used.

Case #1: Single Variable

The data is set up in a single column as follows.

Measure
99.01
99.78
99.61
100.83
99.81
100.26

Case #2: Multiple Variables in Columns

In this case three variables are entered in separate columns.

TempPressureSpeed
15387.312.0
18387.511.1
17585.111.8
19086.110.9
15185.811.6
15085.310.8

Case #3: Variables with a Reference Column

This case uses an index or reference variable. This reference variable groups the data for analysis. In this case, we are using a text variable named "fruit."

FruitMeasure
apple15.3
apple18.3
apple17.5
apple19.0
apple15.1
apple15.0
banana17.3
banana17.5
banana15.1
banana16.1
banana15.8
banana15.3
orange16.0
orange17.1
orange15.8
orange18.9
orange12.6
orange12.8

Case #4: Variables with Multiple Reference Columns

This case uses multiple reference variables. A column for each reference variable must be created. Two reference variables this would be done as follows.

PressCavityMeasure
1141.35
1241.45
1340.35
2141.45
2241.75
2341.55
3141.45
3241.55
3341.80

Case #5: Variables Charts with Subgroups each in a Single Row

Variables Control charts can be set up with a number of different configurations. Subgroups can be placed each in a single row as follows;

m1m2m3m4m5
1.0401.0431.0411.0471.040
1.0431.0411.0401.0451.043
1.0421.0421.0411.0401.050
1.0401.0431.0431.0401.041
1.0421.0361.0361.0361.041
1.0421.0431.0421.0361.040
1.0411.0331.0451.0451.038
1.0421.0441.0391.0411.038
1.0401.0451.0421.0421.043
1.0421.0381.0441.0381.042

Note that this file could also have been created with a single column for the data and a second column or variable representing the sample number.