1. 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