Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Question: Grey Code Corporation(GCC) is a media and marketing company involved in magazine and book publishing and television broadcasting. GCC's portfolio of home and family magazines have been a long running strength, but the company 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 customers. 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 the magazines contain. They will mail a subscribing customer the version with the print ads that the GCC database has determined will most interest that customer.

A problem facing GCC is how to boost the customer response rate to the renewal offers that it mails to its magazine subscribers. The industry response rate is about 2 percent, but GCC has historically had a higher response rate. GCC's director of database marketing, Chris Grey, wants to ensure that GCC maintains its place as one of the top achievers in targeted marketing. In one effort directed at maintaining this position, GCC is currently considering the development of a targeted marketing strategy for a hobby-based magazine. The file GCC contains 38 columns (each corresponding to a distinct variable) and over 40,000 rows (each corresponding to a distinct customer). The Description worksheet contains a description of each variable in the file GCC. The Data worksheet contains the data to be used to train, validate, and test a classification method. The New Data To Predict worksheet contains data on a new set of former subscribers to the hobby-based magazine whom GCC would like to classify as likely or not likely to respond to a targeted renewal offer.

Managerial Report: Play the role of Chris Gray and construct a classification model to identify customers who are likely to respond to a mailing. your report should include the following analyses:

1. The data provided is still relatively raw. Prepare the date for data mining by addressing missing data entries and transforming variables. you may want to use XLMiner's Missing Data Handling utility and Transform Categorical Data utility.

2. Explore the data. Due to the large number of variables, you may want to identify means of reducing the dimensions of the data. In particular, analyze relationships between variables using correlation and pivot tables.

3. Experiment with various classification methods and propose a final model for identifying customers who will respond to the targeted marketing.

a. Provide a summary of the classification model that you select.

b. Provide a decile-wise lift chart and analysis of your model's performance on the test set.

c. Provide a chart of the Class 1 and Class 0 error rates on the test set for various values of the cutoff probability.

d. Classify the customers in the New Data To Predict worksheet.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M92477430
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Basic Finance

A bmw dealership is charging a financing rate of 350 apr on

A BMW dealership is charging a financing rate of 3.50% APR on its M3 car. The payments are to be made bi-weekly (i.e., every two weeks). Alternatively, you can get a loan from a bank to buy the car. The bank asks you to ...

The common stock of the burger hut is selling for 1827 a

The common stock of The Burger Hut is selling for $18.27 a share. The company has earnings per share of $0.73 and a book value per share of $5.03. What is the market-to-book ratio? Round your answer to the nearest hundre ...

A check cashing company will give you 101 in cash and you

A check cashing company will give you $101 in cash and you repay them $120 in two weeks. What is the effective annual rate of interest for this arrangement?

A stock is trading at 78 per share the stock is expected to

A stock is trading at $78 per share. The stock is expected to have a year-end dividend of $5 per share (D1=$5), which is expected to grow at some constant rate g throughout time. The stock's required rate of return is 15 ...

On january 11998 the total assets of the mccue company were

On January 1,1998, the total assets of the McCue company were $270 million. The first present capital structure, which follows, is considered optimal. Assume that they have no short-term debt. Long-term debt              ...

Section a objective type amp short questionspart one

Section A: Objective Type & Short Questions Part One Multiple Choices: 1. It is a concept where goods are produced without taking into consideration the choices or tastes of customers. a. Marketing mix b. Production conc ...

Supposenbspintels stock has an expected return of 220 and a

Suppose? Intel's stock has an expected return of 22.0% and a volatility of 23.0%?, while? Coca-Cola's has an expected return of 8.0% and volatility of 15.0%. If these two stocks were perfectly negatively correlated?(i.e. ...

Question - gamma energy is an oil producing company that

Question - Gamma Energy is an oil producing company that owns an oil field from which it can deliver 10 mln barrels of oil per year for the next four years. The current oil price is USD 75 per barrel. Extraction costs ar ...

Why should investors who identify positive-npv trades be

Why should investors who identify positive-NPV trades be skeptical about their findings if they don't inside information or a competitive advantage? What return should the average investor expect to receive?

Would you pay 23 for a share of common stock that just paid

Would you pay $23 for a share of common stock that just paid a $1.65 dividend, its expected growth rate is 4% and your required return is 11%?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As