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

State the definition of association, State the definition of association ...

State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso

Explain the log based recovery method, Explain the Log Based Recovery Metho...

Explain the Log Based Recovery Method? The system log that is generally written on stable storage consists of the redundant data required to recover from volatile storage failu

C PROBLEMS, how to solve the C type problems?

how to solve the C type problems?

Developer competent in data cleansing-data scrubbing, Data Scrubbing 70,000...

Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

Define thomas write rule, Define Thomas write rule Thomas' write rule: ...

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

Determine bcnf-dcnf and key relation, (A) For the relation; CarSales (R...

(A) For the relation; CarSales (RegNo, BuyerName, Address, SalesPerson, Make, Model, Commission) The following functional dependences hold, RegNo _ID à Make, Model Reg

Determine the objectives of object oriented design, Determine the Objective...

Determine the Objectives of object oriented design provide an overview of object oriented design; partitioning system to subsystems; describe how a software desig

ER diagram, sir we want er diagram of bank management system in this main m...

sir we want er diagram of bank management system in this main menu option as new account,deposit amount,withdraw amount,all acount holder list,modify account,close account

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