Microsoft Excel is an important tool for a healthcare data analyst because of its widespread availability to prepare them, intuitive interface, and general functionality. Data (particularly financial data) is often provided in an Excel file, and for small datasets, availability and Data (particularly financial data) is often provided in an Excel file, and for small datasets, it is also available and used for data entry . It is also used for data entry. It also provides an easy way to modify datasets without programming and prepare those datasets for analysis.
- 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.
