Please work through chapter 10 to complete four labs: Lab 1: descriptive data analysis (accounts receivable aging) ** Lab 2: diagnostic data analysis (segregation of duties) ** Lab 3: predictive data analysis (predicting bankruptcy) ** Lab 4: prescriptive data analysis (estimating breakeven point) ** if you ended up creating your pivot table/histogram for labs 1-3 on a new worksheet, please copy it onto the worksheet beside all the data so that everything is on one worksheet. You may have to adjust column widths after it has been copied ** Once you have completed all four of these labs, copy them into one Excel file that contains four worksheets (one for each lab). HINT: right-click on the worksheet tab you wish to copy and you can choose to copy to another "book" (Excel files are workbooks). If the file you are copying to is open, it will appear on the dropdown list. We work smart, not hard! SAVE the file containing all four labs using LASTNAME_A5.XLSX where lastname is your last name Part 2: Open your Excel assignment 4 file and copy the original Sales worksheet into your new Excel assignment 5 file -- it should look like this: Part 3: Please watch this video for a quick lesson on Pivot tables (both for Windows and Mac users) Create a pivot table based on the Sales data that shows the dollar amount of returns by type of channel. You can create it in a new worksheet or on the same worksheet beside the existing data. Edit the labels used for all the headings, format amounts appropriately and enhance the design. Make your own design choices, I'm just providing an example below. Your work does not need to look like my example. BEFORE: AFTER: Part 4: Please watch this video for a quick lesson on pivot charts (Windows and Mac users) Next, create a pivot chart using the data in your pivot table to display the same information graphically. You can create it in a new worksheet or on the same worksheet just below the pivot table. Add a title to your chart and enhance the design. Make your own design choices, I'm just providing an example below. Your work does not need to look like my example. BEFORE: AFTER: