Business Case Analysis: Association Rulez, Cluster Analysis, Require XLMiner

In Progress Posted 6 years ago Paid on delivery
In Progress Paid on delivery

Business Case Analysis:

1. Association Rules

This item requires the dataset [url removed, login to view] which can be found in attachments.

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 on the resulting rules if the Minimum Confidence (%) was raised to 75? Discuss why this occurs.

2. Cluster Analysis (10%)

This item requires the dataset [url removed, login to view] which can be found in attachments

.

The dataset [url removed, login to view] 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?

Business Analysis Data Analytics Data Mining Data Processing Statistical Analysis

Project ID: #15318540

About the project

8 proposals Remote project Active 6 years ago

Awarded to:

chrisvwn

I can assist you to analyze the business data using association rules and clustering. Relevant Skills and Experience I have experience using association rules and clustering for business data analysis. Proposed Miles More

$200 AUD in 3 days
(0 Reviews)
0.0

8 freelancers are bidding on average $267 for this job

SwellAccounting

I will take your ideas and thoughts and incorporate them into a functional and realistic business plan free from errors, with the attention to detail that ensures your plan’s quality will be first. Relevant Skills and More

$555 AUD in 10 days
(25 Reviews)
6.1
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d More

$250 AUD in 3 days
(52 Reviews)
6.0
Freelancersedo

Dear client? I have read and understood what the business case analysis project needs. I have excellent writing skills and i will do it well and deliver within your deadline. Contact me for more. Relevant Skills and E More

$30 AUD in 3 days
(5 Reviews)
3.1