Calculate confidence and support of rule

Assignment Help Database Management System

Reference no: EM1371819

Consider Association rule below, which was mined from the student database at Big-University:
Major(X,"science) => status(X,"undergrad")

Suppose that the number of students at the university (i.e. the number of task relevant data tuples) is 5000, that 56% of undergraduates at the university major is science, that 64% of the students are registered in programs leading to undergraduate degrees, and that 70% of the students are majoring in science.

a) Compute the confidence & support of rule

b) Consider rule below:
major(X, "biology") => status(X, "undergrad") [17%, 80%]

Suppose that 30% of science students are majoring in biology. Would you consider to be novel with respect to rule? Explain.

Reference no: EM1371819

Questions Cloud

Find the holding company beta : ABC corporation is a holding company with three subsidiaries. The following information pertains to these subsidiaries:

Explain queue crawl through memory in direction of its head : Does queue crawl through memory in direction of its head or its tail? Describe your answer. Describe how lack of metrics for measuring certain software properties affects software engineering discipline.

Find out which data from database to archive : Find out which data from database to archive; that is, for each table, Write down whether data requires to be archived.

Determine sales : David Ding advertises on a local radio station. For last 6-weeks, the manager has kept records of the number of minutes of advertising that were bought, and the sales for that week.

Calculate confidence and support of rule : Assume that 30% of science students are majoring in biology. Would you consider to be novel with respect to rule? Describe. Calculate confidence and support of rule.

Explain barriers to entry and limit pricing : Assume that, prior to other company's entering the market, the maker of a new smartphone earns $100 million per year. By reducing its price by 50%,

Determine economically efficient move : Business Week, in an article dealing with management, wrote, "When he took over furniture factory three years ago. Realized almost immediately that it was throwing away at least $100,000 a year worth of wood scrap.

Write down differences in company policies of firm : For Firm ABC, each of the relations is in 3NF. Write down two differences should exist in company policies of Firm ABC? Explain your answer.

System of fixed wages : American Linen is a company that has multiple salespersons. In 2008, it changed the compensation method for its sales force, moving from a system of fixed wages to one of base wage plus charge.

User Account

All Pages