This example uses the example data set Aircraft.sta, which is distributed with STATISTICA. From the File menu, select Open Examples. Double-click the Datasets folder, and locate and open Aircraft.sta.
The goal of this example is to perform a Box-Cox transformation of one dependent variable, VISC, and save the transformed values back to the original data set.
1.) With the data set open, add a new variable. This will be where STATISTICA writes the transformed valued for use in analyses. For this example, add the variable after VISC, and name it Visc BoxCox. There are several ways to add a new variable.
a) Data – Variables – Add
b) Or from the Vars menu, select Add
c) Or double-click in the gray space around the data in a spreadsheet.
2. The spreadsheet should now look like this:
3. From the Data menu, select Box-Cox Transformation.
4. In the Box-Cox Transformation dialog, click the Variables button, and the select the variable you want to transform. For this example choose VISC. Click OK in the variable selection dialog.
5. The values used for computations can be adjusted if desired. But for this example, we will leave them as is.
6. Click OK in the Box-Cox Transformation dialog to display the Box-Cox Results dialog.
7. There are several options to display results such as plots and summaries of the estimated values. But, to place the transformed values back to the original data set, click the Write back to input spreadsheet button.
8. The Assign statistics to variables for saving in input data dialog is displayed. Here, we will specify to which variable to write the transformed values back to.
9. Under Statistics, choose the variable that was transformed, VISC. Under Variables, choose the new variable location for the transformed data, Visc BoxCox. Then click Assign.
10. The assignment will be displayed in the bottom box.
11. Click OK. You may see a warning message about an analysis being in progress. That is fine, just click OK. The original spreadsheet will be updated to include the transformed values in the Visc BoxCox variable.