A B D E Nm + 1 Transaction 2 2 1 3 3 2 4 3 5 4 6 5 7 6 8 7 9 8 10 9 11 10 12 Red White White Red Red White Red Red Red Shopping Cart White Green Orange Blue White Orange Blue Blue Blue White Blue White Blue 9 Green Yellow Problem - 1: Association Rules (data set: Phone Faceplate.xlsx) [ 50 Points] Tool: Use either Excel or a calculator to solve this problem. 1. Convert the data into (Binary Format) - 4 points 2. How many transactions with the item set {Yellow}? 4 points 3. How many transactions with the item set {White, Blue}? 4 points 4. How many transactions with the item set {Red, White, Green}? 4 points 5. What is the "Support" for item set {Red, White, Green} ? 4 points 6. What is the "Confidence" for the rule: IF {Green, Red} THEN {Whte}? - 5 points 7. What is the "Confidence" for the rule: IF {Red, White} THEN {Green} - 5 points 6. What is the "Lift Ratio" for the rule: IF {Green, Red} THEN (Whte}? - 5 points 7. What is the "Lift Ratio" for the rule: IF {Red, White} THEN {Green} - 5 points 8. Provide a summary of results in a word document: (10 points) - A B D E Nm + 1 Transaction 2 2 1 3 3 2 4 3 5 4 6 5 7 6 8 7 9 8 10 9 11 10 12 Red White White Red Red White Red Red Red Shopping Cart White Green Orange Blue White Orange Blue Blue Blue White Blue White Blue 9 Green Yellow Problem - 1: Association Rules (data set: Phone Faceplate.xlsx) [ 50 Points] Tool: Use either Excel or a calculator to solve this problem. 1. Convert the data into (Binary Format) - 4 points 2. How many transactions with the item set {Yellow}? 4 points 3. How many transactions with the item set {White, Blue}? 4 points 4. How many transactions with the item set {Red, White, Green}? 4 points 5. What is the "Support" for item set {Red, White, Green} ? 4 points 6. What is the "Confidence" for the rule: IF {Green, Red} THEN {Whte}? - 5 points 7. What is the "Confidence" for the rule: IF {Red, White} THEN {Green} - 5 points 6. What is the "Lift Ratio" for the rule: IF {Green, Red} THEN (Whte}? - 5 points 7. What is the "Lift Ratio" for the rule: IF {Red, White} THEN {Green} - 5 points 8. Provide a summary of results in a word document: (10 points)