Data Analytics problem DA P6.1 Clothing manufactures 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 years. -Creat pivot tables(using exel) showing the following Year, number of items sold in the year, and number of items returned in the year. Calculate average returns for each yar. -percentage returns by year and month -Create a bar chart showing percentage returns each January for the past five years. -what information does this visualization tell you about returns in January over the past five years? - create a line chart showing percentage returns by month and by year What information does this visualization tell you about year-over-year and month-over-month returns? Month # of Items Sold # of Items Returned Jan-14 1000 500 Feb-14 1500 120 Mar-14 4500 300 Apr-14 6000 120 May-14 7500 160 Jun-14 9000 120 Jul-14 7000 100 Aug-14 8000 150 Sep-14 8500 500 Oct-14 2000 100 Nov-14 500 200 Dec-14 3500 750 Jan-15 3000 600 Feb-15 2000 200 Mar-15 1500 90 Apr-15 6500 600 May-15 7500 750 Jun-15 8000 350 Jul-15 10000 650 Aug-15 10500 750 Sep-15 9000 200 Oct-15 3500 120 Nov-15 1000 10 Dec-15 4500 1000 Jan-16 3000 950 Feb-16 2000 150 Mar-16 2500 250 Apr-16 6000 650 May-16 8500 600 Jun-16 9000 150 Jul-16 11500 10 Aug-16 10000 250 Sep-16 10000 120 Oct-16 6000 300 Nov-16 2000 450 Dec-16 6000 750 Jan-17 4500 800 Feb-17 2500 1000 Mar-17 3000 750 Apr-17 7000 450 May-17 9000 500 Jun-17 9500 200 Jul-17 12000 500 Aug-17 11500 600 Sep-17 11000 200 Oct-17 4000 90 Nov-17 3500 600 Dec-17 7000 750 Jan-18 5500 750 Feb-18 3000 650 Mar-18 4500 450 Apr-18 7500 300 May-18 8000 500 Jun-18 13500 250 Jul-18 15000 450 Aug-18 14000 1400 Sep-18 16000 750 Oct-18 7000 1500 Nov-18 5500 900 Dec-18 8000 1500