Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
Using the Excel worksheet named Ch04_Sample Project, run a multi-sheet analysis in Microsoft Excel. The worksheet is available to be downloaded (see attachment below)Rename the first worksheet in the
- Using the Excel worksheet named Ch04_Sample Project, run a multi-sheet analysis in Microsoft Excel.
- Rename the first worksheet in the workbook to “Data” and then add two additional worksheets named “Analysis” and “Chart”.
- On the Analysis worksheet, calculate the total number of beds across all facilities and the average fine amount for the set of facilities.
- Next, use Microsoft Excel functions to calculate the number of beds for each state and determine the number of facilities by ownership type for each state.
- On the third worksheet, create a bar plot displaying the total number of beds by ownership type.
- When finished, save your workbook using your last name followed by “Chapter 4”. Then upload that file to the Assignment 2 Link in the course room.
