Calculate the joint probability, Database Management System

Assignment Help:

Consider the following frequency counts of some itemsets in a transaction database r:

freq({A}, r) = 0.405

freq({B}, r) = 0.510

freq({C}, r) = 0.303

freq({A,B}, r) = 0.380

freq({A,C}, r) = 0.256

freq({B,C}, r) = 0.197

freq({A,B,C}, r) = 0.095

Based on this information, you can use them to compute the following probabilities. (e.g. P(X) = freq(X, r).)

a)  What is the joint probability P(A and B)? What is P(A) ? P(B)?

b) What are the confidence and lift ratio of the association rules generated from the following itemsets: {A, B, C} and { ¯A, B}?

c) Compare the results of a) and b) with the frequencies freq({A}, r) and freq({B}, r). What observations can you made about the relationship of A and B in terms of independence and possible causal relationship? Please explain your answer.


Related Discussions:- Calculate the joint probability

Deadlock and its prevention, Deadlock And Its Prevention: As seen earlier,...

Deadlock And Its Prevention: As seen earlier, though two phase locking protocol handles the trouble of serialisability, but it causes some troubles also. For instance, consider th

FIELDS, 4. Describe three ways to handle missing field values

4. Describe three ways to handle missing field values

Which operations need the participating relations to union, Which operation...

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

What are decision support systems, Question: (a) What are decision sup...

Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr

Locking, define locking in simple language and decribed it

define locking in simple language and decribed it

Determine the term- active values, Determine the term- Active values An...

Determine the term- Active values An active value is that has dependent values. Every dependent value registers itself with active value that contains a set of dependent values

Software engineering, Critically evaluate the bulleted list of information-...

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Ddl compiler-database management system, DDL Compiler The DDL compile...

DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

What is average response time, What is average response time? The avera...

What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd