CAGE User's Guide

Importing Experimental Data

You can import experimental data to a data set, either to validate a calibration or to use it as the basis for a calibration.

You can import data that is stored in the following formats:

• Microsoft Excel spreadsheets
• Comma-separated value files
• MAT files

Importing from Excel or Comma-Separated Value.   When you import data from either a Microsoft Excel spreadsheet or from a comma-separated value file, you must ensure that the data is organized in the following manner:

• The first column can either be row markers (text) or entries (numbers).
• The first row can either be column headers (text) or entries (numbers).
• All the other row and column entries must be numbers.

Importing From MAT-files.   When you import from a MAT-file, you must ensure that the file contains numbers only, that is, a double-array.

To import experimental data:

1. Select File -> Import -> Data.
2. In the file browser, select the correct file to import.

1. This opens the Data Set Import Wizard.

3. Discard any columns of data you do not want to import by selecting the column and clicking the button shown.

   

4. Click Next.

1. The following screen asks you to associate variables in your project with data columns in the data.

5. Highlight the variable in the Project Assignments column and the corresponding data column in the Data Column, then click the assign button, shown.

   

6. Repeat step 5 until you are satisfied that you have associated all the variables and data columns. Any unassigned data columns are treated as output factors.

   

7. Click Finish to close the dialog box.

This imports your data into the data set. When you have imported your data, you can view your data set.

Setting Up Data Sets

Importing Data from a Table in Your Session