Create a pie chart to display the percentage of patients discharged by major service category.
Analytical Assignment
Analyze the Administrator’s Semiannual Reference Report that follows, then prepare the data displays indicated in questions 1 through 4. The data displays should be created and turned in via Excel or some sort of software program. There should only be 1 attached file that holds all data requests.
| 1. Provide Percentage of total patients on each week day. 2. Create a histogram to display the distribution of total discharge days by age. |
| 3. Create a bar graph to display admission by day of week for Medicare patients in comparisonto the admission by day of week for all patients. |
| 4. Create a pie chart to display the percentage of patients discharged by major service category. |
| 5. Create a table for length of stay distribution. |
