Defining statistics calculations

These steps are part of the larger task of Calculating common descriptive statistics. When you complete these steps, click the link at the bottom of the panel to return to the main task.

To define statistics calculations:

1. Right-click anywhere on the Transformer definition table and click Add. A row is added to the table.

2. Under the Data column heading in the row that you just created, click and select a column for which to you want to calculate statistics.

3. Double-click the Statistics field. The button is displayed.

4. Click the button. The Calculate Statistics - Select Statistics window opens.

5. From the Available statistics list, click one or more statistics to run on the selected column. Then, click >. The type of statistics that you can select from will depend on the data type of the input column. For character data types, only the Count function is available.

6. Repeat steps 1-5, as appropriate.

7. Click OK. The Elementary Statistics - Select Statistics window closes. After you define a statistics calculation, it cannot be changed. You must delete unwanted definitions and redefine them.

The Calculate Statistics transformer supports partial data. For example, if you select a column to define statistics for but don't select the statistics for it, the Calculate Statistics transformer will save your column selection. However, you cannot map columns for a row that has a partial data selection, nor can you successfully run a step that has a partial data selection.

Return to Calculate common descriptive statistics.