- 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.
Select one National Patient Safety Goal or another external benchmark to address within this assignment. Use a minimum of 4 current scholarly sources to support your work. Create a 3-5 page written pa
Select one National Patient Safety Goal or another external benchmark to address within this assignment. Use a minimum of 4 current scholarly sources to support your work. Create a 3-5 page written paper to address the following elements: Provide an introduction to the paper. Identify and describe the selected National