Hiding non-significant rows

If you have added a minimum p value column to a column proportions or column means test, you can hide rows based on the value in this column. This means that you can carry out a test on all the rows in the table and then hide any rows that contain no significant results, as determined by the minimum p value.

This enables you to carry out a test on all the rows in the table and then hide any rows that contain no significant results, as shown by the minimum p value.

Method 1

1 Click Tables > Properties.

2 In the Hide tab of the Table Properties dialog, select Hide rows.

3 In the list, select greater than.

4 Enter the significance level expressed as a percentage; for example, if you are using a significance level of 5, enter 0.05.

5 In the based on list, select variablename{MinPval}.

Method 2

Use the syntax:

Set R = TableDoc.Table1.Rules.AddNew()

R.Type = 0 ' hide

R.Target = 0 ' row

R.CellItemRef = 0 ' if cellitem 0 (counts)

R.Operator = 4 ' is greater than

R.Value = 0.10 ' required significance level

R.ElementRef = "variablename{MinPVal}" ' for MinPVal column

R.IgnoreSpecialElements = False ' hide special elements

R.Type = 0 ' hide

R.Target = 0 ' row

R.CellItemRef = 0 ' if cellitem 0 (counts)

R.Operator = 4 ' is greater than

R.Value = 0.10 ' required significance level

R.ElementRef = "variablename{MinPVal}" ' for MinPVal column

R.IgnoreSpecialElements = False ' hide special elements

See also