Following are descriptions of the options available on the Association Rule dialog.

Input Data Format

Select Data in binary matrix format if each column in the data represents a distinct item. If this option is selected, XLMiner treats the data as a matrix of two entities -- zeros and non-zeros. All non-zeros are treated as 1s. Effectively, the data set is converted to a binary matrix that contains 0s and 1s. A 0 indicates that the item is absent in the transaction, and a 1 indicates it is present.

Select Data in item list format if each row of data consists of item codes or names that are present in that transaction.

Minimum support (# transactions)

Specify the minimum number of transactions in which a particular item set must appear for it to qualify for inclusion in an association rule. The default setting is 10% of the total number of rows.

Minimum confidence (%)

A value entered for this option specifies the minimum confidence threshold for rule generation. If A is the set of Antecedents and C the set of Consequents, then only those A =>C (Antecedent implies Consequent) rules will qualify, for which the ratio (support of A U C) / (support of A) is greater than or equal to. The default setting is 50.