Question: Please solve in EXCEL using solver tool and any other tools needed and provide screenshots and explainations The term churn in marketing means that a
Please solve in EXCEL using solver tool and any other tools needed and provide screenshots and explainations The term churn in marketing means that a customer switches loyalty to another company. The file CustomerChurn.xlsx contains data on over 3000 customers of a cell phone provider. Columns B through N provide information about the account and usage of each customer, and column O indicates whether the customer churned during the given period of time. The Discriminant Analysis assigns a weight vector to the data (features), and then computes the weighted combination of the data for each customer. The customers weighted combination is called the customers discriminant score. The method then classifies a customer into group 1 or group 2 depending on which side of a cutoff score the customers discriminant score falls. computes the weighted combination of the data for each customer. The problem is to find the optimal weight vector and cutoff score that maximize the percentage of correct classifications in the training data. Use the Discriminant Analysis, the enclosed data, and the Excel Solver to develop a classification model for predicting whether a customer will churn.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
