# Question: Refer to the scenario described in Problem 13 and the

Refer to the scenario described in Problem 13 and the file Cellphone. In XLMiner's Partition with Oversampling procedure, partition the data so there is 50 percent successes (churners) in the training set and 40 percent of the validation data are taken away as test data. Construct a logistic regression model using Churn as the output variable and all the other variables as input variables. Perform an exhaustive-search best subset selection with the number of best subsets equal to 2. Generate lift charts for both the validation data and test data.

a. Why is partitioning with oversampling advised in this case?

b. From the generated set of logistic regression models, select one that you believe is a good fit. Express the model as a mathematical equation relating the output variable to the input variables. Do the relationships suggested by the model make sense? Try to explain them.

c. Using the default cutoff value of 0.5 for your logistic regression model, what is the overall error rate on the test data?

d. Examine the decile wise lift chart for your model on the test data. What is the first decile lift? Interpret this value.

a. Why is partitioning with oversampling advised in this case?

b. From the generated set of logistic regression models, select one that you believe is a good fit. Express the model as a mathematical equation relating the output variable to the input variables. Do the relationships suggested by the model make sense? Try to explain them.

c. Using the default cutoff value of 0.5 for your logistic regression model, what is the overall error rate on the test data?

d. Examine the decile wise lift chart for your model on the test data. What is the first decile lift? Interpret this value.

**View Solution:**## Answer to relevant Questions

A consumer advocacy agency, Equitable Ernest, is interested in providing a service in which an individual can estimate their own credit score (a continuous measure used by banks, insurance companies, and other businesses ...Refer to the scenario described in Problem 19 and the file HousingBubble. a. For the following substeps, consider the Pre-Crisis worksheet data. Partition the data into training (50 percent), validation (30 percent), and ...Cookie Monster Inc. is a company that specializes in the development of software that tracks Web browsing history of individuals. A sample of browser histories is provided in the file CookieMonster. Using binary matrix ...Consider again Problem 13. The point of purchasing a European option is to limit the risk of a decrease in the per-share price of the stock. Suppose you purchased 200 shares of the stock at $28 per share and 75 six-month ...Consider again the scenario described in Problem 4. a. The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but nonmembers who do not attend ...Post your question