Jie Xu - Temple University

MIS 2502 Assignment 9

Answer Sheet for Assignment: Association Rules

Name ______Jie Xu__________

Fill in the worksheet below with the answers to the questions on pages 1-2 of the assignment:

Question

Answer

Confidence, rule 580 has 0.29 and rule 538 has 0.19 confidence, meaning that rule 580 has a stronger association.

3.37230365331597, rule 517

415	{ citrus fruit} => { soda}	0.012811	0.154791	0.88768
416	{ soda} => { citrus fruit}	0.012811	0.073469	0.88768

No, its not. Based on rule 415 and 416, these two have confidence of 0.15 and 0.07, which means they have very weak association. Also, they have only 0.88 lift value which is below 1, meaning that they are not very likely to go together.

285	{ butter} => { whipped/sour cream}	0.010168	0.183486	2.559698
287	{ butter} => { root vegetables}	0.012913	0.233028	2.137897
295	{ butter} => { whole milk}	0.027555	0.497248	1.946053
289	{ butter} => { yogurt}	0.014642	0.26422	1.894027
293	{ butter} => { other vegetables}	0.020031	0.361468	1.868122
291	{ butter} => { rolls/buns}	0.013421	0.242202	1.31678

Whipped/sour cream has the highest predictive power in butter.

Confidence:0.75

Support:0.6

Lift:1.25

Confidence:0.33

Support:0.2

Lift:0.83

Confidence:0.5

Support:0.2

Lift:0.83

Lift({ QuirkyJerky } => { GreenBull }) = 4500/(5300+4500)*25800/(8500+4500) = 0.91

It’s more likely to happen by chance than being predictive.

Bonus Question: 1. The ability to use SQL syntax to manage a database.

2. The ability to view R syntax and summarize the result for analysis.

3. The conceptual perception of data mining and data management.

4. The ability to visualize and materialize disordered data.