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: 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 assigns variable names: Var1, Var2, Var3, etc.

As with Statistica Spreadsheets, all values in a column are used for the selected analysis unless case selection conditions are specified.

See also, Opening Document Objects in Statistica.

Option Description
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 are 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 Select this check box. Any columns that are determined to contain mostly text use a text type variable instead of a numeric variable with a text label. Statistica determines numeric vs. text 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 click the OK button. When the Review/Edit Column Types dialog box displays, 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 Closes the Select Excel Range for the Analysis dialog box. Any specified options are disregarded.
Use Selection Displays the Excel Variable and Case Names dialog box.