Homework 3<\/p>\n
Background: As a bank, you tested sending credit card offers to you existing customers. You tested sending the offers via mail as a postcard or a letter. You also tested different kinds of rewards (Points, Cash Back, and Air Miles). In addition, you captured a variety of customer characteristics including income (High, Med, Low), Credit Rating (High, Med, Low), and a variety of relationship variables including number of bank accounts and balances. The offers were sent to a random sample of 18,000 of your customers and you captured whether or not each customer responded to the offer (opened the credit card account). All of this information is captured in the file \u201ccreditcardmarketing-bbm.jmp\u201d (field definitions are listed below). Please use that file to complete the following activities and answer the following questions (Notes: you can answer in bullets, short sentences and visualizations; but make sure your answers are complete and Understandable.<\/p>\n
1.\tCreate a distribution of Offer Accepted. Yes means the offer was accepted. What percentage of offers were accepted (5 points)?<\/p>\n
2.\tUse the Make Validation Colum utility to create a training, validation, and test sets. What percentage of offers were accepted in each of the three sets of data (training, validation, and tests)? (5 points)<\/p>\n
3.\tCreate at least three different models, using different modeling techniques (e.g., decision tree, boosting, bagging, logistic) predicting who is likely or not likely to accept the offer. For each model, create what you believe is the best version of that model.<\/p>\n
4.\tUse the model comparison platform to compare the model\u2019s performance. Which model is the best model? Please explain why (30 points).<\/p>\n
5.\tBased on the models you created, what are major insights? What variables are important in predicting which customers are likely to accept the offer? What characteristics of the offer impact the likelihood customers accept the offer? What are the general business insights gleaned from these model builds? (30 points)<\/p>\n
6.\tPlease describe how you might use this model to generate business value in credit card marketing campaigns (30 points).<\/p>\n
Data Description:
\nCustomer Number: A sequential number assigned to the customers (this column is hidden and excluded \u2013 this unique identifier will not be used directly).
\nOffer Accepted: Did the customer accept (Yes) or reject (No) the offer.
\nReward: The type of reward program offered for the card.
\nMailer Type: Letter or postcard.
\nIncome Level: Low, Medium, or High.
\n# Bank Accounts Open: How many non-credit-card accounts are held by the customer.
\nOverdraft Protection: Does the customer have overdraft protection on their checking account(s) (Yes or No).
\nCredit Rating: Low, Medium, or High.
\n# Credit Cards Held: The number of credit cards held at the bank.
\n# Homes Owned: The number of homes owned by the customer.
\nHousehold Size: Number of individuals in the family.
\nOwn Your Home: Does the customer own their home? (Yes or No).
\nAverage Balance: Average account balance (across all accounts over time).
\nQ1, Q2, Q3 and Q4 Balance: Average balance for each quarter in the last year.<\/p>\n","protected":false},"excerpt":{"rendered":"
Homework 3 Background: As a bank, you tested sending credit card offers to you existing customers. You tested sending the offers via mail as a postcard or a letter. You\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6901,6896,6899,6897,6900,6903,6902,6905,6904,6843,6898],"tags":[103,95,83,94,80,86,79,98,93,104,6908,99,92,82,102,85,6907,8,101,97,87,96,91,89,90,88,100,1402,84,6906,81],"class_list":["post-47951","post","type-post","status-publish","format-standard","hentry","category-affordable-dissertation-help-dissertation-help-tutors","category-assessment-brief-assignment-help","category-assessment-task-assignment-help","category-cheap-dissertation-writing-service-uk","category-custom-dissertation-writing-help","category-dissertation-help-services-uk","category-dissertation-proposal-help-uk","category-dissertation-writing-services-reddit","category-dissertation-writing-services-tiktok","category-dissertation-writing-services-uk-reviews","category-writing-dissertation-and-grant-proposals","tag-150-200-words-discussion-with-a-scholarly-reference","tag-200-300-words-response-to-classmate-discussion-question","tag-250-word-analysis-essay","tag-bachelor-of-nursing-assignments","tag-case-study","tag-essay-bishops-website","tag-expert-online-nursing-writing-service","tag-fast-nursing-papers","tag-freelance-case-study-writing-service","tag-health-medicine-assignment-help-australia","tag-health-care-an","tag-health-care-assignment-help-service","tag-healthcare-assignment-writing-services-by-top-writers","tag-healthcare-essay-writing-services-by-medical-academics","tag-healthcare-writing-help-by-certified-medical-academics","tag-i-need-to-submit-this-assignment","tag-in-a-paper","tag-medical-essay-writing-service","tag-nursing-assessment-help","tag-nursing-assignment-help","tag-nursing-assignment-help-australia","tag-nursing-assignment-help-sydney","tag-nursing-assignment-writers","tag-nursing-assignments-examples-assignment-help-nursing","tag-pay-someone-to-do-my-nursing-assignment","tag-professional-case-study-writers","tag-quality-nursing-essay-writing-service","tag-write-a-paper","tag-write-a-review","tag-write-an-essay","tag-writing-assignment"],"_links":{"self":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/posts\/47951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/comments?post=47951"}],"version-history":[{"count":0,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/posts\/47951\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/media?parent=47951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/categories?post=47951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/tags?post=47951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}