Wizards / Transformations Wizard |
Selecting Transformations from the Data/Graphics menu brings up the following dialog box:
Create
Enter the name of the series you want to create here. You can type in a new name (here, we put in LOGPRICE), or click on the arrow to select from a list of all the existing series. If you select an existing series, you can overwrite that series with the new transformation, or edit the selected name to create a new series.
By/As
Choose the transformation you want to create. You can choose from: "Log" (what we are doing here), "Square Root", "Difference", "Growth Rate", "Remove Mean", "Partial Sums (Accumulate)", and "General-Input Formula". The Filter/Smooth and Differencing Wizards can do more specific types of transformation and the Trend/Seasonal/Dummies Wizard can create series which don't use another series as input.
From
The source series for the transformation.
Sample Start and End
Use these fields if you want to specify the start and/or end of the sample range. Leave these blank if you want to use the default range.
Formula for Transformation
This field is only visible if the "General-Input Formula" transformation is selected. You use this field to enter an expression (using series names, other variables, functions, and operators) that returns the desired result.
Copyright © 2025 Thomas A. Doan