Assessment item 3 Assessment Item 3 Value: 20% Due date: 08-Oct-2017 Return date: 30-Oct-2017 Submission method options Alternative submission method Task Business Case Analysis 2 1. Association Rules (10%) This item requires the dataset Cosmetics-small.xls which can be found on the subject Interact site. Using XLMiner, apply association rules to the file Cosmetics-small.xls. Note: Do NOT include the Transaction # column in the XLMiner Data Range and accept the default Minimum Confidence (%) of 50. i. Interpret the first three rules in the output (in your own words). ii. Reviewing the first couple of dozen rules, comment on the rulesâ€™ redundancy and how you would assess the rulesâ€™ utility. iii. What would be the impact to the resulting rules if the Minimum Confidence (%) was raised to 75? Discuss why this occurs. 2. Cluster Analysis (10%) This item requires the dataset EastWestAirlinesCluster.xls which can be found on the subject Interact site. The dataset EastWestAirlinesCluster.xls contains informati************ pass************ belong to an airlineâ€™s frequent flier program************ pass************data include information on their mileage history and on different ways they accrued or spent miles in the last year. The goal is to try to identify c************ pass************t have similar characteristics for the purpose of targeting different segments for different types of mileage offers. a) Apply hierarchical clustering with Euclidean distance and Ward’s method. Make sure to normalize the data first. How many clusters appear? b) What would happen if the data were not normalized? c) Compare the cluster centroid to characterize the different clusters, and try to give each cluster a label. d) Use K-means clustering with the number of clusters that you found above. Does the same picture emerge? e) Which clusters would you target for offers, and what types of offers would you target to customers in that cluster? Rationale This task assesses your progress towards meeting Learning Outcomes 3, 4 and 5. 3. Be able to compare and evaluate output patterns 4. Be able to explore and critically analyse data sets and evaluate their data quality, integrity and security requirements 5. Be able to compare and evaluate appropriate techniques for detecting and evaluating patterns in a given data set It also partly addresses Learning Outcomes 1 and 2. Marking criteria Questions HD DI CR PS FL 1 & 2 The answers are correct and complete, demonstrating that the student has thoroughly understood the specified dataset and the usage of XLMiner. The student supplies insightful observations. The answers are correct and complete, demonstrating that the student understood the specified dataset and the usage of XLMiner. The answers are correct and complete, demonstrating that the student understood the specified dataset and the usage of XLMiner. Answers are correct and complete, demonstrating that student understood the specified dataset. Answers are correct and complete Answers are not correct and partially complete. Presentation Assignments are required to be submitted in either Word format (.doc, or .docx), Open Office format (.odf), Rich Text File format (.rtf) or .pdf format. Each assignment must be submitted as a single document. Assignments should be typed using 10 or 12 point font. APA referencing style should be used. A reference list should be included with each assessment item. All screenshots that are required should be inserted into the document in the appropriate position for each question. Screenshots that are submitted in addition to the assignment document will not be marked.