Z-Transform Scrollsheet command
How to z-transform a scrollsheet...
- Select Z-Transform Scrollsheet from the Options Menu.
- A dialog box appears. Press the Help button if you need instructions on how to fill in the dialog box fields. Fill in the fields that are not grayed or accept defaults and press Ok to continue. Or press Cancel to abort.
- Wintrack will z-transform the data of numeric columns in the scrollsheet,
using mean and standard deviation of the data that are to be transformed
or from an external reference table, depending on your choice.
As external reference you can use not only Wintrack scrollsheets, but also tables that have been saved as text files by other Windows™ applications, for example by MS Excel™. Reference columns must have the same names as the ones that are to be transformed. If no standar deviation can be computed for a numeric column or its data have zero variance, the result will be an empty column.
Related commands...
To save transformation results to disk, you use the Save Scrollsheet or Save Scrollsheet As commands. The Save Scrollsheet As command also lets you copy scrollsheets to the Windows™ clipboard, so you can paste their content into other Windows™ applications The Analyze Case and Filter Case commands use scrollsheets to report their results: you may later reopen such a scrollsheet and continue to add results to it. The Run Macro command can use scrollsheets as parameter tables.
Additional information...
- See Z-Transform Scrollsheet dialog for details on the associated dialog box.
- The equivalent macro statement is explained in Z-Transform Scrollsheet statement.
- Inside scrollsheets provides advanced information on scrollsheets.
- See Creating and using macros to learn how to use and create macros.
