Select Excel Range for the Analysis

The Select Excel Range for the Analysis dialog box is displayed when you select a command from the Statistics, Data Mining, or Graphs menu the first time after you have opened an Excel worksheet in the Statistica window. If you have previously opened and saved Excel files, you can access the Select Excel Range for the Analysis dialog box by selecting Properties from the File menu.

Note that Statistica has determined the logical option specifications, but these options can be changed if necessary.

When variable names are not included with the Excel worksheet, Statistica will assign variable names: Var1, Var2, Var3, etc. As with Statistica Spreadsheets, all values in a column will be used for the selected analysis unless case selection conditions are specified.

See also, Opening Document Objects in Statistica.

First data row. Enter the number of the row in the Excel file that you want to be the first row for the analysis.

Last data row. Enter the number of the row in the Excel file that you want to be the last row for the analysis.

First data column. Enter the title of the column in the Excel file that you want to be the first column for the analysis.

Last data column. Enter the title of the column in the Excel file that you want to be the last column for the analysis.

Read variable names from row. Enter the number of the row in the Excel file that you want to use as the variable names for the analysis.

Read case names from column. Enter the name of the column in the Excel file that you want to use as the case names for the analysis. This field can be left blank, and the case names will be numbered consecutively.

Ignore text in numeric columns. Select this check box to specify that text found in numeric columns be treated as missing data instead of text labels. This is useful when a text file column is mostly numeric, but also has some textual comments.

Create text variables for text. When this check box is selected, any columns that are determined to contain mostly text will use a text type variable instead of a numeric variable with a text label. Determination of numeric vs. text is accomplished by examining each row of the column, ignoring missing data. If there is less than 10% numeric, the column is considered to be text.

Review/Modify column types before importing. Select this check box, and after clicking the OK button, the Review/Edit Column Types dialog box is displayed, where you can review the column types and change them if desired.

OK. After entering/selecting options, click this button to close the Select Excel Range for the Analysis dialog box.

Cancel. Click the Cancel button to close the Select Excel Range for the Analysis dialog box. Any specified options will be disregarded.

Use Selection. Click the Use Selection button to display the Excel Variable and Case Names dialog box.