Problem 2 (35%) – File: Bank. xlsx Community Bank would like to increase the number of customers who use payroll deposit. Management is considering a new sales campaign that will require each branch manager to call each customer who does not currently use payoff direct deposit. As an incentive to sign up for payroll direct deposit, each customer contacted will be offered free checking for two years. Because of the time and cost associated with the new campaign, management would like to focus their efforts on customers who have the highest probability of signing up for payroll direct deposit. Management believes that the average monthly balance in a customer’s checking account may be useful predictor of whether the customer will sign up for direct payroll deposit. To investigate the relationship between these two variables, Community Bank tried the new campaign using a sample of 50 checking account customers who do not currently use payroll direct deposit. The sample data show the average monthly checking account balance (in hundreds of dollars) and whether the customer contacted signed up for payroll direct deposit (coded 1 if the customer signed up for payroll direct deposit and 0 if not). 1. For the Community Bank data, use SAS to formulate the estimated logistic regression equation. (5 marks) 2. Estimate the probability that customers with an average monthly balance of $1000 will sign up for direct payroll deposit. (5 marks) 3. Suppose Community Bank only wants to contact customers who have a 0.50 or higher probability of signing up for direct payroll deposit. What is the average monthly balance required to achieve this level of probability? (10 marks) 4. What is the estimated odds ratio? What is the interpretation? (15 mar
————
vProblem 2 (35% of the time) – Bank.xlsx The number of customers who use payroll deposit at Community Bank would like to increase. Management is considering launching a new sales campaign in which each branch manager is required to call every customer who does not currently use payoff direct deposit. Each customer contacted will be offered free checking for two years as an incentive to sign up for payroll direct deposit. Due to the time and expense of the new campaign, management would like to concentrate its efforts on customers who are most likely to sign up for payroll direct deposit. The average monthly balance in a customer’s checking account, according to management, may be a useful predictor of whether the customer will sign up for direct payroll deposit.
