Apply hierarchical clustering with euclidean distance

Assignment Help Database Management System
Reference no: EM131668441

Business Case Analysis

1. Association Rules

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

This item requires the dataset EastWestAirlinesCluster.xls which can be found on the subject Interact site.

The dataset EastWestAirlinesCluster.xls contains information on 3999 passengers who belong to an airline's frequent flier program. For each passenger the 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 clusters of passengers that 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.

Attachment:- data files.rar

Reference no: EM131668441

Questions Cloud

Governor regarding the death penalty : Compose a letter to your state governor regarding the death penalty. In this letter, explain your position regarding capital punishment.
Different business functional areas : Which information systems within different business functional areas (Accounting, Finance, HR, etc.) would you use for data analysis in compliance procedures?
Critical issues today regarding the health workforce : What are the critical issues today regarding the health workforce--training, hiring, paying, and building? And, how are these handled by HCOs and insurers?
Trust between leaders and employees important : Why is trust between leaders and employees important? How can a leader build trust?
Apply hierarchical clustering with euclidean distance : Apply hierarchical clustering with Euclidean distance and Ward's method. Make sure to normalize the data first. How many clusters appear?
Construct a clustered column chart with exterior color : An automotive company is considering the introduction of a new model of sports car that will be available in two engine types: four cylinder and six cylinder.
Primary routes to persuading your negotiation opponents : Describe and discuss the two primary routes to persuading your negotiation opponents. (butter them up?)
Provide a scenario for using each topology : In this paper, (a) define each topology, (b) provide a scenario for using each topology, and (c) identify at least one disadvantage of using each topology.
Choose two theories of motivation to compare : Choose two theories of motivation to compare. Explain the theories' concepts and provide examples on how to effectively apply the theories in a working setting.

Reviews

len1668441

10/5/2017 1:14:15 AM

u have to do it in xlminer. if ur interested in doing my assessment. then i will give my login. And it is also having many examples. Thank you 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.

len1668441

10/5/2017 1:13:08 AM

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.

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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