Reference no: EM131139488

The term churn is very important to managers in the cellular phones business. Churning occurs when a customer stops using one company's services and switches to another company's services. Obviously managers try to keep churning to a minimum, not only by offering the best possible services, but by taking step to stop churning before it occurs. For example, if a company learn that customers tend to churn at the end of their two-year contract, they could offer customer incentive to stay a month or two before the end of their two-year contract. The file C03_or.xlsx contains data on over 2000 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 in this chapter (and possibly the previous chapter) to learn (1) how these variables are distributed (2) How the variables in Column B-R are related to each other and (3) how the variable in column B-R are related to the churn variable in column S. write a short report of your finding, including and recommendation you would make to the company to reduce churn.