Reference no: EM133218137

The term "churn" is very important to managers in the cellular phone business. Churning occurs when a customer stops using one company's service and switches to another company's service. Obviously, managers try to keep churning to a minimum, not only by offering the best possible service, but by trying to identify conditions that lead to churning and taking steps to stop churning before it occurs. For example, if a company learns that customers tend to churn at the end of their two-year contract, they could offer customers an incentive to stay a month or two before the end of their two-year contract. The file churn.xls contains data on over 3000 customers of a particular cellular phone company. Each row contains the activity of a particular customer for a given time period, and the last column indicates whether the customer churned during this time period. Use the tools of Exploratory data analysis to learn how these variables are distributed, how the variables are related to each other and how the variables are related to the churn variable. Write a short report of your findings, including any recommendations you would make to the company to reduce churn.