- 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 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.
I have a revision of a project with comments from the teacher on how to revise it. I would like Tutor333839 to revise it since its their original work but I’m willing to take other offers if they shou
I have a revision of a project with comments from the teacher on how to revise it. I would like Tutor333839 to revise it since its their original work but I’m willing to take other offers if they should decline. I will attach the powerpoint and word project that was