Analytical Assignment

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 comparison
to 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.