^{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). 2 | P a g e The managerial report MUST include discussions on your findings, charts, and tabulated data. You also need to provide recommendations on future action plans for further growth and expansion of the company (e.g. increase in the number of subscriptions). Grading rubric: Key points Grade allocation (%) Format (font type, size, tables and charts) 20 Analysis (grade breakdowns for each question are provided above) 46 Overall content (discussions and recommendations, methodology, professionalism) 24 Creativity in presenting data 10 N.B. Failure to comply with the above would result in low grades. Word limit: 2000 words (excluding tables, graphs and appendix) and top 15 charts. Deliverables: An Excel showing the background calculations and a Word file. Naming convention: Use the following format to name your files: Your name_Student ID_Individual assignment3 (e.g. Alireza Samea_112233_Individual assignment3) Deadline: Deadlines are specified in your course shell. 3 | P a g e How to write a professional business report: A professional business report should be well-structured and easy to read. Here are some general guidelines for formatting a business report: 1. Title page: The title page should include the report title, the name of the author or authors, the name of the organization or company the report is for, and the date the report was completed. 2. Table of contents: Include a table of contents that lists the sections of the report and their page numbers. 3. Executive summary: This section briefly overviews the report's main findings and recommendations. 4. Introduction: In this section, provide some background information about the topic and explain why the report was written. 5. Body: The body of the report should be divided into sections that cover the main points of the report (In this assignment, the Data and discussions on the findings). Use subheadings and bullet points to make the information easy to read and follow. 6. Conclusion: Summarize the main findings and conclusions of the report. 7. Recommendations: Provide specific recommendations based on the findings of the report. 8. Appendices: Include any additional information. When formatting the report, use a professional font such as Times New Roman or Arial, and keep the font size between 10 and 12 points. Use 1.5 or double spacing. Number the pages. When presenting charts in a report, it is important to choose the right type of chart and label it clearly. The chart should be placed in a logical location in the report, and the design should be simple and easy to read. When selecting colours and fonts, it is important to consider the overall style of the report and the audience for whom it is intended. Finally, proofread the report carefully to ensure it is free of errors and typ}