Following are descriptions of the options available on the Association Rule dialog.
Worksheet: The worksheet name containing the dataset.
Workbook: The workbook name containing the dataset.
Data range: The selected data range.
#Rows: (Read only) The number of rows in the dataset.
#Cols: (Read only) The number of columns in the dataset.
First Row Contains Headers: Select this checkbox if the first row of the dataset contains column headings.
Input Data Format
- Select Data in binary matrix format if each column in the data represents a distinct item. If this option is selected, Analytic Solver Data Mining 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.