Data Analytics Problem DAP6.1 Clothing Manufacturers Limited (CML) is a public company that sells clothing on a wholesale basis to retail stores. During the past year, the company has adopted IFRS 15 and is looking to estimate sales revenues and refunds. The company has a fair bit of data, including monthly sales and returns for the past five years. As the controller, you have asked your assistant to do the following: a. Create pivot tables (using Excel) showing the following: i. Year, number of items sold in the year, and number of items returned in the year. Calculate average returns for each year. ii. Percentage returns by year and month. b. Create a bar chart showing percentage returns each January for the past five years. c. What information does this visualization tell you about returns in January over the past five years? d. Create a line chart showing percentage returns by month and by year. e. What information does this visualization tell you about year-over-year and month-over-month returns