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

The stock of company tyk pays dividends annually with next

The stock of company TYK pays dividends annually, with next year's dividend expected to be $1 a share. For the next seven years, dividends are expected to grow at a rate of 6% a year. Thereafter, dividends are expected t ...

Abc company writes 39 checks a day for an average amount of

ABC Company writes 39 checks a day for an average amount of $1438 each. These checks generally clear the bank in 3 days. In addition, the firm generally receives an average of $5636 a day in checks that are deposited imm ...

Skyco corporation is considering a project with the

SkyCo Corporation is considering a project with the following expected NOCF's: Year   NOCFt 1 $390,000 2 $410,000 3 $385,000 A)  If the firm's WACC is 12.1%, and the project costs $850,000, what is the NPV? B)  What is t ...

Under what circumstances will the irr and npv rules lead to

Under what circumstances will the IRR and NPV rules lead to the same decision (accept/reject)? When might they conflict?

You invested 12000 in a stock that has an expected return

You invested $12,000 in a stock that has an expected return of 18% and $21,000 in a stock with an expected return of 10%. What is the portfolio's expected return?

A project currently generates sales of 20 million variable

A project currently generates sales of $20 million, variable costs equal 50% of sales, and fixed costs are $4.0 million. The firm's tax rate is 35%. Assume all sales and expenses are cash items. a.  What are the effects ...

Walmart has issued a dividend for the past five years in

Walmart has issued a dividend for the past five years. In 2013 it issued a $1.00 dividend. This year it is expected to issue a $1.50 annual dividend. Please calculate the rate the dividend has grown (two decimals please)

If sheel inc has 7 percent coupon compounded semiannually

If Sheel Inc. has 7 percent coupon (compounded semiannually) bonds on the market with 10 years to maturity, and the par value of $1,000. AT what price should the bonds be selling for if the YTM is 5%? If the bond had bee ...

Financial statement analysis for comcastprepare an eight-

Financial Statement Analysis for Comcast Prepare an eight- to ten-page fundamental financial analysis (excluding appendices, title page, abstract, and references page) that will cover each of the following broad areas ba ...

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 ...

  • 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