Introduction

Through our research discoveries and analysis of current customer data for Regork, we have uncovered a few reasons why our customers may leave our telecommunications services and after analysis have created solutions to retain these customers that may be prone to leave in the future. We understand that it’s important to keep these existing customers and believe that our analysis of the risks of retention problems and mitigations to them are even more important.

Analysis

Tenure vs. Monthly Charges

ggplot(CustRet, aes(x = Tenure, y = MonthlyCharges)) +
  geom_point() +
  ggtitle("Scatterplot of Tenure vs Monthly Charges") +
  xlab("Tenure") +
  ylab("Monthly Charges")

Contract Distribution by Type

ggplot(CustRet, aes(x = Contract)) +
  geom_bar(fill = "lightgreen") +
  ggtitle("Contract Distribution") +
  xlab("Contract Type") +
  ylab("Count")

Monthly Charges by Contract Type

ggplot(CustRet, aes(x = Contract, y = MonthlyCharges)) +
  geom_boxplot(fill = "lightblue") +
  ggtitle("Boxplot of Monthly Charges by Contract Type") +
  xlab("Contract Type") +
  ylab("Monthly Charges")

Count of Senior Citizens vs. Non-Senior Citizens

ggplot(CustRet, aes(x = SeniorCitizen, fill = factor(SeniorCitizen))) +
  geom_bar() +
  ggtitle("Total Count of Senior Citizens vs. Non-Senior Citizens") +
  xlab("Senior Citizen (1: Yes, 0: No)") +
  ylab("Count") +
  scale_fill_manual(values = c("lightblue", "lightgreen")) +
  theme_minimal()

Conclusion and Recomendations

Regork should focus their efforts on current month-to-month contracts and aim to sign them to a one-year or two-year contracts. People who are on month-to-month contracts are much more likely to leave when they see a better offer rather than a year or two year contract that the customer would only think about their telecomunications plan once a year or every other year. There are significantly more month-to-month contracts, and on average the monthly charge is roughly the same for all types of contracts as well. We should also target dependents as they will be looking for a provider after they leave their household and become independent. We also recomend that we we do not target senior citizens as they are less likely to switch providers.