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 sign- up/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:

3- For each product, plot the number of newly registered subscriptions (based on sign-up

date) since 2017.

4- Cross tabulation of gender and customer service reach out method.

5- Scatter diagram to explore the subscription duration (separate charts for each gender).