Variable AccountWeeks ContractRenewal DataPlan DataUsage Cu...

Variable AccountWeeks ContractRenewal DataPlan DataUsage CustServCalls DayMins DayCalls MonthlyCharge OverageFee RoamMins Churn Description number of weeks customer has had active account 1 if customer recently renewed contract, 0 if not 1 if customer has data plan, 0 if not gigabytes of monthly data usage number of calls into customer service average daytime minutes per month average number of daytime calls average monthly bill largest overage fee in last 12 months average number of roaming minutes "Yes" if customer cancelled service, "No" if not

Thanks for your feedback!

I NEED THIS ASSIGNMENT CODED IN R STUDIO WITH R PROGRAMMING LANGUAGE Problem 3: You will need Cellphone.csv file to solve this problem. For this problem, please insert your answer at the corresponding place after each question. In addition, you also need to submit your R code with the name YourLastName_P3.R. Please provide as many comments as possible in your code. 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 the customer is considering cancellation and retain the customer. Data on past customers (some of whom churned and some who did not) has been collected. The variables in this data are listed in the following table. Classify the data using k-nearest neighbors for a range of values of k. Use Churn as the target (or response) variable and all the other variables as input variables. Standardize the input variables to adjust for the different magnitudes of the variables. For a default cutoff value of 0.5, what value of k minimizes the overall error rate on the static validation set or through a 10-fold cross-validation procedure? Hint: please check if the data is imbalanced. If so, you may need to consider oversampling. What is the overall error rate, the Class 1 error rate, and the Class 0 error rate on the test set? Compute and interpret the sensitivity and specificity for the test set. How many false positives and false negatives did the model commit on the test set? What percentage of predicted churners were false positives? What percentage of predicted non-churners were false negatives? Variable Description AccountWeeks: number of weeks the customer has had an active account ContractRenewal: 1 if the customer recently renewed the contract, 0 if not DataPlan: 1 if the customer has a data plan, 0 if not DataUsage: gigabytes of monthly data usage CustServCalls: number of calls into customer service DayMins: average daytime minutes per month DayCalls: average number of daytime calls MonthlyCharge: average monthly bill OverageFee: largest overage fee in the last 12 months RoamMins: average number of roaming minutes Churn: "Yes" if the customer cancelled service, "No" if not

Play audio

Feedback

Question

Please give Ace some feedback