Association Rule analysis

profilemeimeijiejie
AssociationRuleExcelBook-Complete1.xlsx
Home>Computer Science homework help>Association Rule analysis

Sheet1

PC Purchase Data
Processor Screen Size Memory Hard Drive
Record Intel Core i3 Intel Core i5 Intel Core i7 10 inch screen 12 inch screen 15 inch screen 2 GB 4 GB 8 GB 320 GB 500 GB 750 GB
1 0 1 0 0 1 0 0 1 0 0 1 0
2 0 1 0 0 0 1 0 0 1 0 0 1
3 0 1 0 0 1 0 0 1 0 1 0 0
4 1 0 0 0 1 0 0 0 1 0 1 0
5 0 0 1 0 0 1 0 0 1 0 0 1
6 0 0 1 0 1 0 0 1 0 0 0 1
7 0 0 1 0 0 1 0 0 1 0 0 1
8 1 0 0 0 1 0 0 1 0 0 1 0
9 0 1 0 1 0 0 1 0 0 0 1 0
10 0 1 0 0 1 0 0 0 1 0 1 0
11 0 1 0 0 0 1 1 0 0 0 0 1
12 0 1 0 0 0 1 0 1 0 0 0 1
13 0 1 0 1 0 0 0 1 0 0 1 0
14 0 1 0 0 1 0 1 0 0 0 1 0
15 0 1 0 1 0 0 1 0 0 0 1 0
16 0 0 1 0 0 1 0 0 1 0 0 1
17 1 0 0 1 0 0 1 0 0 0 1 0
18 1 0 0 0 1 0 0 1 0 0 0 1
19 0 1 0 0 0 1 1 0 0 0 1 0
20 1 0 0 0 1 0 0 1 0 0 0 1
21 0 1 0 0 1 0 0 0 1 0 0 1
22 0 1 0 0 1 0 0 1 0 0 1 0
23 0 1 0 0 0 1 0 1 0 1 0 0
24 0 1 0 0 1 0 0 1 0 0 1 0
25 0 1 0 0 0 1 1 0 0 0 1 0
26 1 0 0 0 1 0 0 1 0 1 0 0
27 1 0 0 0 1 0 1 0 0 0 0 1
28 1 0 0 1 0 0 0 1 0 1 0 0
29 0 0 1 0 1 0 0 0 1 0 1 0
30 1 0 0 1 0 0 0 1 0 1 0 0
31 1 0 0 1 0 0 1 0 0 0 1 0
32 1 0 0 1 0 0 1 0 0 1 0 0
33 0 1 0 0 1 0 0 0 1 0 1 0
34 0 1 0 0 0 1 0 1 0 0 1 0
35 0 0 1 0 1 0 0 1 0 0 0 1
36 1 0 0 0 1 0 1 0 0 1 0 0
37 1 0 0 1 0 0 0 0 1 0 0 1
38 0 1 0 1 0 0 0 1 0 1 0 0
39 0 1 0 0 0 1 0 0 1 0 1 0
40 0 0 1 0 1 0 0 0 1 0 1 0
41 1 0 0 1 0 0 0 1 0 1 0 0
42 0 1 0 0 0 1 0 1 0 1 0 0
43 0 0 1 0 0 1 0 0 1 0 0 1
44 0 0 1 0 1 0 0 1 0 0 1 0
45 0 1 0 0 0 1 0 1 0 1 0 0
46 0 1 0 0 0 1 0 1 0 1 0 0
47 0 1 0 0 1 0 0 1 0 0 1 0
48 0 1 0 0 1 0 1 0 0 0 1 0
49 1 0 0 0 1 0 0 1 0 0 1 0
50 0 1 0 1 0 0 0 1 0 1 0 0
51 1 0 0 0 0 1 0 1 0 1 0 0
52 0 1 0 0 0 1 0 1 0 0 1 0
53 1 0 0 0 1 0 0 1 0 0 1 0
54 0 1 0 1 0 0 0 1 0 1 0 0
55 0 0 1 0 1 0 0 1 0 0 1 0
56 1 0 0 0 1 0 1 0 0 0 0 1
57 1 0 0 1 0 0 0 1 0 0 1 0
58 0 1 0 0 1 0 1 0 0 0 1 0
59 0 1 0 0 1 0 1 0 0 1 0 0
60 1 0 0 1 0 0 0 1 0 0 1 0
61 0 0 1 0 0 1 0 1 0 0 0 1
62 0 1 0 1 0 0 0 1 0 0 1 0
63 0 1 0 0 1 0 1 0 0 1 0 0
64 0 1 0 0 1 0 0 1 0 0 1 0
65 0 0 1 0 1 0 0 1 0 0 0 1
66 1 0 0 0 1 0 1 1 0 1 0 0
67 1 0 0 0 0 1 0 1 0 1 0 0

AssocRules_Output

XLMiner : Association Rules
Output Navigator Elapsed Times in Milliseconds
Inputs List of Rules AssocRules Time Report Time Total
16 0 16
Inputs
Data
# Transactions in Input Data 67
# Columns in Input Data 12
# Items in Input Data 12
# Association Rules 40
Minimum Support 7
Minimum Confidence 50.00%
List of Rules
Rule: If all Antecedent items are purchased, then with Confidence percentage Consequent items will also be purchased.
Row ID Confidence % Antecedent (A) Consequent (C) Support for A Support for C Support for A & C Lift Ratio
1 66.6666666667 Intel Core i7 750 GB 12 17 8 2.6274509804
2 53.8461538462 8 GB 750 GB 13 17 7 2.1221719457
3 50 Intel Core i3 & 4 GB 320 GB 14 19 7 1.7631578947
4 56.25 10 inch screen Intel Core i3 16 22 9 1.7130681818
5 77.7777777778 2 GB & 500 GB Intel Core i5 9 33 7 1.5791245791
6 71.4285714286 Intel Core i5 & 12 inch screen 500 GB 14 31 10 1.5437788018
7 70 Intel Core i5 & 2 GB 500 GB 10 31 7 1.5129032258
8 70 15 inch screen & 4 GB Intel Core i5 10 33 7 1.4212121212
9 80 Intel Core i5 & 320 GB 4 GB 10 38 8 1.4105263158
10 78.9473684211 320 GB 4 GB 19 38 15 1.391966759
11 77.7777777778 Intel Core i3 & 320 GB 4 GB 9 38 7 1.3713450292
12 62.5 4 GB & 500 GB 12 inch screen 16 32 10 1.30859375
13 63.1578947368 15 inch screen Intel Core i5 19 33 12 1.2822966507
14 61.2903225806 500 GB Intel Core i5 31 33 19 1.2443792766
15 57.5757575758 Intel Core i5 500 GB 33 31 19 1.2443792766
16 58.3333333333 Intel Core i7 12 inch screen 12 32 7 1.2213541667
17 58.064516129 500 GB 12 inch screen 31 32 18 1.2157258065
18 56.25 12 inch screen 500 GB 32 31 18 1.2157258065
19 55.5555555556 12 inch screen & 4 GB 500 GB 18 31 10 1.2007168459
20 58.8235294118 2 GB Intel Core i5 17 33 10 1.1942959002
21 52.9411764706 2 GB 500 GB 17 31 9 1.1442125237
22 56.25 4 GB & 500 GB Intel Core i5 16 33 9 1.1420454545
23 55.5555555556 12 inch screen & 500 GB Intel Core i5 18 33 10 1.1279461279
24 63.6363636364 Intel Core i3 4 GB 22 38 14 1.1220095694
25 63.6363636364 Intel Core i3 & 12 inch screen 4 GB 11 38 7 1.1220095694
26 52.9411764706 2 GB 12 inch screen 17 32 9 1.1084558824
27 62.5 10 inch screen 4 GB 16 38 10 1.1019736842
28 52.6315789474 Intel Core i5 & 500 GB 12 inch screen 19 32 10 1.1019736842
29 53.3333333333 4 GB & 320 GB Intel Core i5 15 33 8 1.0828282828
30 50 10 inch screen 500 GB 16 31 8 1.0806451613
31 50 Intel Core i5 & 4 GB 500 GB 18 31 9 1.0806451613
32 52.6315789474 320 GB Intel Core i5 19 33 10 1.0685805423
33 50 Intel Core i3 12 inch screen 22 32 11 1.046875
34 50 Intel Core i3 & 4 GB 12 inch screen 14 32 7 1.046875
35 58.3333333333 Intel Core i5 & 15 inch screen 4 GB 12 38 7 1.0285087719
36 56.25 12 inch screen 4 GB 32 38 18 0.9917763158
37 55.5555555556 12 inch screen & 500 GB 4 GB 18 38 10 0.9795321637
38 54.5454545455 Intel Core i5 4 GB 33 38 18 0.961722488
39 52.6315789474 15 inch screen 4 GB 19 38 10 0.9279778393
40 51.6129032258 500 GB 4 GB 31 38 16 0.9100169779