instructions attached below
Student Name:
HSA 3170: Healthcare Finance
Module Six Assignment1. Using the following information, create graph in excel that best displays the information. Cut and paste your graph from excel on to your submission.
Your graph needs to have Title, Headers, and include a trend line (hint: chose an appropriate format that includes the ability to add a trend line)
| Local General Hospital CT Volume Over Time | |||
| Year | Volume | ||
| 2008 | 14,323 | ||
| 2009 | 15,386 | ||
| 2010 | 16,729 | ||
| 2011 | 18,998 | ||
| 2012 | 19,250 | ||
| 2013 | 21,620 | ||
2. Using the following information, create graph in excel that best displays the information. Cut and paste your graph from excel on to your submission.
Your graph needs to have Title, Headers, and include percentages (hint: chose an appropriate format that includes the ability to add percentages)
| Local General Hospital Imaging Volume for 2013 | |||
| Modality | Volume | ||
| CT | 21,620 | ||
| MRI | 10,243 | ||
| X-Ray | 53,236 | ||
| Ultrasound | 13,231 | ||
| Mammography | 41,378 | ||
| Nuclear Med | 9,390 | ||
8/14
