This problem set involves market basket analysis as learned in class. Complete the? market-basket analysis for sales data of ice cream and related? items, for a sales volume of 400 transactions.??Complete the tables below and answer the subsequent questions. Not that some values are placed in each table to help you get started.

Complete the Base Market Basket Analysis Table? The values in each cell

represent the number of orders that contain two items in the same order. Cells on the

diagonal? (shaded) represent all orders that have a specific item. Remember that values

above the diagonal and below the diagonal are? mirror images of each other.

Complete the Support Table? The values in this table represent? support, which is the

percentage of orders that include the items designated at the? cross-section. Remember

that values above the diagonal and below the diagonal are? mirror images of each

other.

Complete the Confidence Table? The values in this table represent? confidence,

which is the probability that a customer will buy a? product, given that? s/he has

purchased another product. Remember that values above the diagonal and below the

diagonal are NOT? mirror images of each other.

Complete the Lift Table? The values in this table represent? lift, which quantifies how

much the probability of a customer buying a product increases or decreases when? s/he

purchases another product. Remember that values above the diagonal and below the

diagonal are? mirror images of each other.

1/ How many transactions out of the total 400 transactions include BOTH Peanuts and Whipped? Cream?

A.

200

B.

210

C.

260

D.

180

E.

250

2/ Using the Market Basket? Analysis, if a customer purchases Hot? Fudge, what is the probability that they will purchase Whipped? Cream?

A.

?90%

B.

?81.82%

C.

?45.45%

D.

?76.2%

E.

?72%

3/ Which product is the best? crss-selling opportunity for? peanuts?

A.

Whipped Cream

B.

Peanut

C.

Hot Fudge

D.

Ice Cream

E.

Maraschino Cherry

4/ What is the highest lift? value? What does it? mean?

A.

?106.1%. If a customer purchases Whipped? Cream, the probability that the

customer purchases Hot Fudge becomes? 106.1%

B.

?106.1%. If a customer purchases Hot? Fudge, the probability that the customer

purchases Ice Cream increases by? 123.1%

C.

?144.0%. If a customer purchases Whipped? Cream, the probability that the

customer purchases Maraschino Cherries increases by? 144.0%

D.

?123.1%. If a customer purchases? Peanuts, the probability that customer

purchases Whipped Cream increases by? 123.1%

E.

?144.0%. If a customer purchases Whipped? Cream, the probability that the customer

purchases Peanuts becomes? 123.1%

BASE MaraschinoWhipped Peanuts Ice Cream Hot Fudge Cherry Cream 200 180 250 200 260 Peanuts Maraschino Cherry Whipped Cream ce Cream Hot Fudge 250 100 10 200 200 360 210 180 150 100 220