Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Scenario: You are working for our non - profit arm, as a Data Scientist. We have volunteered to assist a charity to develop a tool

Scenario: You are working for our non-profit arm, as a Data Scientist. We have volunteered to assist a charity to develop a tool to optimize their outreach efforts. Your objective is to determine which set of potential donors the charity should contact to maximize the profitability of a marketing campaign to solicit donations for the charity.
1. The cost of marketing to a particular potential donor varies per zip code. This cost is paid regardless of whether the potential donor responds to our marketing or not. This cost is specified in the file zipCodeMarketingCosts.csv.
2. Only if a customer responds to our request, do we receive the donation amount.
3. The amount variable does not include the marketing cost.
4. Profitability of campaign = sum of all amounts received sum of all marketing costs for customers to whom you marketed.
Files You Are Provided:
1. data.7z/train.csv: Historical data of potential donors. This data set contains a huge amount of data about the donors and that is defined in the dataDictionary.txt file. However, especially important fields are:
a. id: A unique identifier for a given potential donor.
b. amount: The dollar amount that was given by the donor for that donation only.
c. responded: Whether or not the potential donor responded to the previous solicitation.
2. data.7z/test.csv: The company has also provided you with a list of potential customers to whom to solicit donations. From this list of potential donors, you need to determine yes/no whether you wish to solicit to them. As mentioned, the cost to solicit to a particular donor depends on their zip code. Further, since we do not know whether or not they will respond, this file does not contain the variables amount or responded. The column market initially contains all NA values. You will populate your results here in accordance with the instructions in the Output You Are To Provide section of the instructions.
3. zipCodeMarketingCosts.csv: The cost to market to a given zip code.
4. dataDictionary.txt: A list of all of the columns and their intuitive explanations.
Output You Are To Provide:
At the end of the 3 days window, please email back the following files:
1. All associated notebooks you used to complete your analysis.
2. IMPORTANT: Email back the test.csv, with the market column populated with a 1 if you wish to solicit a donation from that customer and 0 if you do not wish to solicit a donation from that customer. We recommend that you save a few minutes to make sure that you:
a. Did not add or remove any columns from this data set.
b. Did not add or remove any rows from this data set.
c. That you entered a 1 to the market column if you wish to solicit the potential donor and a 0 if you do not wish to solicit that potential donor.
3. Please prepare a presentation to show to us during the second round of interview. The presentation should be written as if you were presenting your results to a non-technical audience from the non-profit that we are working with. Plan on this presentation lasting no more than 10-15 minutes.
If you wish to make any additional changes after submission, wed be happy to look at them.

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

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

3rd Edition

978-1119907466

More Books

Students also viewed these Databases questions

Question

Explain the chemical properties of acids with examples.

Answered: 1 week ago

Question

Write the properties of Group theory.

Answered: 1 week ago