Sample script file: RDBTables.mrs

This example script is based on the Short Drinks sample data set. See Running the sample table scripts for information on running the example scripts.

Displaying a mean based on factors provides an example of basing a mean on the factor values stored for the elements in the metadata. This example shows you how to specify factor values in the axis specification.

This example defines factors for the elements in the Household Size (hhsize) variable and creates a special mean element based on the factors we have defined.

Here is a table that has this axis on the side:

You can specify factors for elements you define in your script using custom expressions. This example shows you how to specify factor values for elements used to band a numeric variable.

This example bands the numeric income variable into three elements, defines a factor for each element, and creates a special mean element based on the factors. Notice that the factor value has been included in the element labels. This is useful for understanding the tabulated results when you use arbitrary values.

Here is a table that has this axis on the side:

However, when banding numeric variables, it is more usual to base the mean on the raw numeric values. When you do this, you do not need to define factors. For example:

Notice that when you want to base the statistical element on the raw numeric values, you must specify the name of the variable inside the parentheses that follow the keyword that defines the special element (mean in this example).

Here is a table that has this axis on the side:

For more information, see Factor in Table Object Model reference.