Following are descriptions of the options available on the Association Rule dialog.
Data Source
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 nonzeros. All nonzeros 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.
Parameters

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.