What is age and province distributions of active customers

Assignment Help Applied Statistics

Reference no: EM132352725

Assignment - Project of Advanced SAS Course

Part One: Small Project for the Telecom Company - Customer Distribution and Deactivation Analyses

Objective: The attached data is the CRM data of a wireless company for 2 years. The wireless company would like to investigate the customer distribution and business behaviors, and then gain insightful understanding about the customers, and to forecast the deactivation trends for the next 6 months.

Data:

Acctno: account number.

Actdt: account activation date

Deactdt: account deactivation date

DeactReason: reason for deactivation.

GoodCredit: customer's credit is good or not.

RatePlan: rate plan for the customer.

DealerType: dealer type.

Sales: the amount of sales to a customer.

Age: customer age.

Province: province.

Analysis requests:

1.1 Explore and describe the dataset briefly. For example, is the acctno unique? What is the number of accounts activated and deactivated? When is the earliest and latest activation/deactivation dates available? And so on....

1.2 What is the age and province distributions of active and deactivated customers? Use dashboards to present and illustrate.

1.3 Segment the customers based on age, province and sales amount:

Sales segment: < $100, $100---500, $500-$800, $800 and above.

Age segments: < 20, 21-40, 41-60, 60 and above.

Create analysis report by using the attached Excel template.

1.4 Statistical Analysis:

1) Calculate the tenure in days for each account and give its simple statistics.

2) Calculate the number of accounts deactivated for each month.

3) Segment the account, first by account status "Active" and "Deactivated", then by

Tenure: < 30 days, 31---60 days, 61 days-- one year, over one year. Report the number of accounts of percent of all for each segment.

4) Test the general association between the tenure segments and "Good Credit" "RatePlan" and "DealerType"

5) Is there any association between the account status and the tenure segments? Could you find out a better tenure segmentation strategy that is more associated with the account status?

6) Does Sales amount differ among different account status, GoodCredit, and customer age segments?

Attachment:- Advanced SAS Assignment Files.rar

Reference no: EM132352725

Questions Cloud

How to challenge behaviours or actions that may lead : T/504/2202-Support individuals to stay safe from harm or abuse- Explain the relationship between local procedures and guidelines for safeguarding.

What has been done to overcome any issues : Social marketing is the adaptation of marketing practices to programs designed to influence the voluntary behavior of target groups in order to improve.

What is the procedure for treating a human : What is the procedure for treating a human bitten by an animal if the animal cannot be found?

Evolving perspectives and practices institutional security : Address current and evolving perspectives and practices institutional security, executive, and general employee protection.

What is age and province distributions of active customers : Project for the Telecom Company - Customer Distribution and Deactivation Analyses. What is age and province distributions of active customers

Describe the appropriate use of nutritional supplements : T/503/2575-Promote Nutrition and Hydration in Health and Social Care Settings-Explain ways of ensuring foods and drinks have increased nutritional density.

Does clostridium botulinum have glycocalyx and if so where : Does Clostridium botulinum have glycocalyx and if so where? How long can Clostridium botulinum survive without a host?

Future of stuff challenge and review the process : Stanford Design School web page Future of Stuff Challenge and review the process. Stanford's Design School is believed by most to be cutting edge in creativity

How each problem could impact a group productivity : Explanation of how each problem could impact a group's productivity (use examples to illustrate points). Recommendations to resolve each problem.

User Account

All Pages