Page 1 of 1

Telecommunications companies providing cell phone service are interested in customer retention. In particular, identifyi

Posted: Wed May 11, 2022 11:16 am
by answerhappygod
Telecommunications companies providing cell phone service are
interested in customer retention. In particular,
identifying customers who are about to churn (cancel their service)
is potentially worth millions of dollars
if the company can proactively address the reason that customer is
considering cancellation and retain the
customer. The datafile is called Cellphone.csv and it contains
n=3,333 customer data to be used to classify
a customer as a churner or not.
(a) Using GGPlot, provide a bar chart for how Monthly charge is
distributed by Churn Status. Comment on
what you see.
(b) Create a model in where you are predicting whether a customer
will Churn vs not Churn when you
consider: Accountweeks, Contract Renewal, Data Plan, Data Usage,
Customer Service Calls, Day Minutes,
Day calls, Monthly Charge, Overage Fee, and Roaming Minutes as
the independent variables in the model.
Discuss the model’s Pseudo Rˆ2,
Interpret the significant predictors by outputting Odds Ratios,
Confidence Intervals, and your interpretation
of each.
Run the analysis in Excel and include the main results from excel n
the knitted documented,
I am using Rstudio to code and Microsoft Excel for this!!!
Not another way!
I have Cellphone.csv file but now sure how to post it. Any help
if possible if needed?
Thank you!!