Identify best and one worst customers

Assignment Help Management Information Sys
Reference no: EM132191495

Ques #1 Lazy boy is using data analytics RFM technique to identify its best and worst customers. This will help them customize their marketing strategy.

Lazyboy sales files is available on the course website, called Lazyboy sales

- Perform RFM analysis (show all calculations in EXCEL, submit this excel file)

Submit following in WORD FILE

- provide the RFM score table in the word file also

- Identify three best and one worst customers

- Discus marketing strategies that would be appropriate for them

Ques#2.

Given the following ownership data for Tractors based on income level and lot size
(similar to example that we did in class but NOT the same; source shemuli etc)

Revised tractor data file is available on class website as tractor data

Develop a two level split decision tree using

First level split at lot size = 19

Second level split follow following rule

If lot size > 19 AND income <= 75.5 etc..
If lot size<=19 AND income <= 65.8 etc..

Do not worry about other splits

- Based on first and second level draw the partial tree

Gini index

- Before the split

- After the first split (lot size =19)

- After the second level splits

Q3 Given the following

Given the following Table with training Records with their actual class and the probability of them being class 1 members estimated by a classifier. Where 1 denotes a customer will buy washer/dryer combination and 0 implies they will not.

(source Shmueli etc)

- Draw a "lift" chart for a person buying a washer and dryer (1) using the above model. Draw it in EXCEL and submit excel file. ( 3 points)
- and provide the lift value for 10 cases of 1(success)

Q 4. Using Tableau

Hint: You can change the name of worksheet by double clicking on it

Using tractor data (ques #2)

- Worksheet 1: put your name on worksheet in title
Create 2 clusters and discuss
Between and within sum of square
Change the name of worksheet to your name_cluster

- Worksheet 2: Create the following worksheet in tableau, call it part 2

Save it in Tableau public server and submit the url

Given the clusters below (note they maybe different from part a) develop a confusion matrix for cluster 1 (note cluster1 implies ownership)

Attachment:- Final Take.zip

Verified Expert

In this assignment we have studied for excel operation and here we have create application in excel for the solution .Here we have to done operation on the tableau .Here I have download excel sheet and observe the result in the tableau. There are observe the result of regression in the excel

Reference no: EM132191495

Questions Cloud

How do you see the actions of the national government : How do you see the actions of the national government affecting your everyday life?
Evaluate the findings from your research : The ability to present one's findings from an evaluation or research study in a concise and persuasive manner is a requirement for any successful manager.
Talk about our implemented policy : Our policy is education and we have to use two peer reviewed sources to talk about our implemented policy (Education).
Difference between a population and a sample in research : Explain the difference between a population and a sample in research. Discuss at least 2 populations and 2 samples that X may be interested.
Identify best and one worst customers : INSS 422 - Business Intelligence - Identify best and one worst customers - Discus marketing strategies that would be appropriate
Explain hofstede cultural dimensions : Explain Hofstede's cultural dimensions. Discuss the implications for your initial communications within each country. For example, what is the impact.
Describe the purpose and hypothesis of the experiment : Describe the procedure. Describe the steps of the experiment and what you did so that a classmate could replicate if they wanted.
What are the implications of the cultural variables : What are the implications of the cultural variables for your communication with the team representative from each country in the face to face meeting?
Which of these do you personally find most useful : Which of these do you personally find most useful and why? Do you have any prior experience using the selected feature of Excel?

Reviews

len2191495

12/11/2018 11:58:44 PM

Note: You can use EXCEL, ACCESS or ORACLE for these problems. Must show all intermediate and final tables, spreadsheets etc.. must show queries and their outputs--If ACCESS or ORACLE is used Ques #1 Lazy boy is using data analytics RFM technique to identify its best and worst customers. This will help them customize their marketing strategy. (12 points) Lazyboy sales files is available on the course website, called Lazyboy sales

len2191495

12/11/2018 11:58:30 PM

I have attach three files for you to be able to do the assignment for me. Please kindly follow the instructions step by step. Thanks. Please DO NOT write any comments with your submission. • This is an EXAM, I can NOT answer any questions. • Read the questions carefully • Email me for any GENERAL clarifications • Exam is to be done individually • Honesty and integrity is expected, any dishonesty will result in 0 for the EXAM • All work should be done on the exam itself. • Submit following files: • word file (ONE word file with everything in it)

Write a Review

 

Management Information Sys Questions & Answers

  Explain why you have chosen to put them in the order

you will be given 5 types of insurance fraud and a short definition of each.YouI would like for you to rank them according to degree of severity. In other words, start with the crime you think is the worst and work your way down to the crime you ..

  What services should be restored first

Describe the minimum services that must be maintained for that company after the disaster. What services should be restored first ?

  Strategic supply chain managementcohen and roussels fourth

strategic supply chain managementcohen and roussels fourth core discipline - build the right collaborative model. refer

  What distinguishes a histogram from a bar chart

Why are graphs and charts used to represent information and What distinguishes a histogram from a bar chart

  The purpose of the system and the problem

In an organization that you are familiar with, identify the systems being used in terms of the purpose of the system and the problem it helped in solving

  How were the digital media followers handled

How were the digital media followers handled? Is there something that could have been done differently to make that experience more efficient?

  What conditions is each type appropriate

Explain the differences between the various types of purchasing organizations. Under what conditions is each type appropriate. Please ensure that your original response is at least 200 words and is supported with references.

  What onus does this place on the individual programmer

Prepare a 300-word Group discussion post in response to the following: The current CAE ethics Knowledge Unit covers multiple legal requirements.

  What are protective barriers and what should they entail

What are protective barriers and what should they entail? What mitigation procedures can be used to ensure the resiliency of protective barriers?

  Information sharing with global partnersmost global

information sharing with global partnersmost global organizations are intricately involved with other businesses and

  Develop a complete disaster recovery plan

Develop a Complete Disaster Recovery Plan to be submitted to the executive board of your company.

  Supply chain selection of vendorsscenariothe time frame for

supply chain selection of vendorsscenariothe time frame for receiving proposals passed yesterday. you received 10

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