Answered step by step
Verified Expert Solution
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 nonprofit 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.
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
Only if a customer responds to our request, do we receive the donation amount.
The amount variable does not include the marketing cost.
Profitability of campaign sum of all amounts received sum of all marketing costs for customers to whom you marketed.
Files You Are Provided:
dataztraincsv: 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.
dataztestcsv: 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 yesno 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.
zipCodeMarketingCosts.csv: The cost to market to a given zip code.
dataDictionary.txt: A list of all of the columns and their intuitive explanations.
Output You Are To Provide:
At the end of the days window, please email back the following files:
All associated notebooks you used to complete your analysis.
IMPORTANT: Email back the test.csv with the market column populated with a if you wish to solicit a donation from that customer and 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 to the market column if you wish to solicit the potential donor and a if you do not wish to solicit that potential donor.
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 nontechnical audience from the nonprofit that we are working with. Plan on this presentation lasting no more than 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started