The excel file "customer data set" includes customer subscription data for a digital product company which provides financial advisory services. This company offers an annual and monthly subscription. Customer support services, including product-related questions and signup/cancellation-related queries, are provided via email and phone. This database includes the following variables: Customer demographic - Gender and age of the customer Start and end date of the subscription (to reduce the complexity of the calculations for you, we selected Aug 16, 2022, as the end date of the current active customers) Customer support reach-out method - Email or Phone Type of service - sign-up/cancellation or Support Product type - annual or monthly Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following: 1- (10 points) Percentage frequency distribution (Table & Histogram chart) for key variables a. Age (select bin width of 5 years) b. Subscription duration (select bin width of 12 months) Hint: Use the Histogram option in the Data Analysis ToolPack. 2- (16 points) Bar or Pie chart to show: a. Gender of customers b. Type of Service c. Product Type d. Customer support reach-out method 3- (8 points) For each product, plot the number of newly registered subscriptions (based on sign-up date) since 2017. 4- (6 points) Cross tabulation of gender and customer service reach out method. 5- (6 points) Scatter diagram to explore the subscription duration and age (separate charts for each gender).

case_id	date_time	customer_id	channel	reason	age	gender	product	signup_date_time	cancel_date_time
CC151056	10-06-2020 13:08	C78560	phone	signup	64	male	prd_2	08-01-2018	16-08-2022
CC247610	05-06-2021 13:46	C97794	phone	support	53	male	prd_1	12-08-2019	16-08-2022
CC80868	20-06-2019 12:54	C236704	phone	support	53	female	prd_1	26-07-2020	16-08-2022
CC242946	25-05-2021 11:23	C424686	phone	support	53	male	prd_1	22-07-2019	16-08-2022
CC59825	21-02-2019 08:25	C34687	phone	signup	41	female	prd_1	20-01-2020	11-11-2021
CC238631	14-05-2021 12:09	C112123	phone	signup	53	male	prd_1	04-07-2019	16-08-2022
CC97515	19-09-2019 07:01	C53824	phone	signup	65	male	prd_2	12-02-2021	16-08-2022
CC15925	05-11-2017 14:16	C12202	phone	support	65	female	prd_1	29-03-2018	16-08-2022
CC91577	17-08-2019 09:36	C217982	phone	support	62	female	prd_1	22-12-2020	16-08-2022
CC84669	10-07-2019 13:29	C48191	phone	signup	58	female	prd_1	05-09-2020	16-08-2022