Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DATA file JMP: Grey.xlsx R/Rattle: Grey.csv Case Problem: Grey Code Corporation CASE PROBLEM: GREY CODE CORPORATION 505 Grey Code Corporation (GCC) is a media

image text in transcribed

DATA file JMP: Grey.xlsx R/Rattle: Grey.csv Case Problem: Grey Code Corporation CASE PROBLEM: GREY CODE CORPORATION 505 Grey Code Corporation (GCC) is a media and marketing company involved in magazine and book publishing and in television broadcasting. GCC's portfolio of home and family magazines has been a long-running strength, but it has expanded to become a provider of a spectrum of services (market research, communications planning, web site advertising. etc.) that can enhance its clients' brands. GCC's relational database contains over a terabyte of data encompassing 75 million cus tomers, GCC uses the data in its database to develop campaigns for new customer acquisition, customer reactivation, and identification of cross-selling opportunities for products. For example, GCC will generate separate versions of a monthly issue of a magazine that will differ only by the advertisements they contain. It will mail a subscribing customer the version with the print ads identified by its database as being of most interest to that customer. One particular problem facing GCC is how to boost the customer response rate to renewal offers that it mails to its magazine subscribers. The industry response rate is about 2%, but GCC has historically performed better than that. However, GCC must update its model to correspond to recent changes, GCC's director of database marketing, Chris Grey, wants to make sure that GCC maintains its place as one of the top achievers in targeted marketing. The file Grey contains 38 variables (columns) and over 40,000 rows (distinct cus- tomers). The table appended to the end of this case provides a list of the variables and their descriptions. Play the role of Chris Grey and construct a classification model to identify customers who are likely to respond to a mailing. Write a report that documents the following steps: 1. Explore the data. Because of the large number of variables, it may be helpful to fil- ter out unnecessary and redundant variables. 2. Appropriately partition the data set into training, validation, and test sets. Experi- ment with various classification methods and propose a final model for identifying customers who will respond to the targeted marketing. 3. Your report should include appropriate charts (ROC curves, lift charts, etc.) and include a recommendation on how to apply the results of your proposed model. For example, if GCC sends the targeted marketing to the top 10% of the test set that the model believes is most likely to renew, what is the expected response rate? How does that compare to the industry's average response rate?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Financial Accounting

Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald

1st Canadian Edition

1118849388, 9781119048572, 978-1118849385

More Books

Students also viewed these Accounting questions

Question

Prepare a business case. AppendixLO1

Answered: 1 week ago

Question

Distinguish between financial and scoring models. AppendixLO1

Answered: 1 week ago