Defining Data: Additional Variables

Click the Additional variables button under Statistica data file on the Options tab of the Defining Data dialog box to display the Additional variables dialog box.

Additional variables can be added to the data file (spreadsheet). This is useful in cases where more information or variable manipulation is needed prior to performing analyses. Additional variables can be defined from formulas expressed in the Variable Definition dialog box.

OK

Click this button to accept your changes and exit this dialog box.

Cancel

Click this button to close the dialog box without making any changes.

Add

Click this button to display the Variable Definition dialog box and create a new variable.

Remove

Click this button to remove a variable already in the list.

Edit

Click this button to display the Variable Definition dialog box and modify a variable.

Note:

Up/Down The order in which the variables are listed is the order in which the variables will be placed in the Statistica data file. Use the Up and Down buttons to reorder the list as needed. Any additional variables will be created and populated lastly in the resulting spreadsheet. They will appear after all variables created as defined in the Data Configuration, placed on the far right.

For example, if the Data Configuration contains information regarding sales totals, then you may know that due to a pattern in the sales over the year, that you will need to transform the sales figures before analyzing them. Click the Add button and specify LogSales as the Short name and =Log(Sales) as the Long name. Sales is the name of the column which contains the sales totals. When the Analysis Configuration is run and the data appear in the data file, the values of the transformation will appear in the last variable of the data file, LogSales.

See Statistica Spreadsheet Formula Syntax.