## Microsoft Excel Coursework

There are 7 questions that need to be analyzed on Microsoft Excel. After completing the assignment/exam on Excel, on a word document, can you please guide me through how you got to the answers. Step by step instructions on how you answered the questions. I want to be able to mimic your steps and get to your answers.

The Instructions can be found in the Instructions Tab.

Instructions:
– Please put any analysis in tab titled &amp;amp;amp;amp;quot;Work up&amp;amp;amp;amp;quot;. All final graphs should go in the &amp;amp;amp;amp;quot;Final&amp;amp;amp;amp;quot; tab. Please give all graphs titles and provide a legend where necessary.
– Please do the following using the data in the tab &amp;amp;amp;amp;quot;raw data&amp;amp;amp;amp;quot;. The following analysis is requested for this data set :

Graph #1:
– The number of orders performed in each location (East Wing, West Wing, North Wing, SouthWing, ED).

Graph #2:
– The number of orders performed by each role (RN, Radiology Tech, PA, NP, Resident Physician).

Graph #3:
– The number of orders by hour of day (how many orders occurred each hour).
– The number of &amp;amp;amp;amp;quot;performed start time&amp;amp;amp;amp;quot; by hour of day (how many orders performance started each hour).
– The number of &amp;amp;amp;amp;quot;performed end time&amp;amp;amp;amp;quot; by hour of day (how many orders performance ended each hour).

Graph #4:
– The average number of minutes from &amp;amp;amp;amp;quot;Order Time&amp;amp;amp;amp;quot; to &amp;amp;amp;amp;quot;Performed End Time&amp;amp;amp;amp;quot; .
– The average number of minutes from &amp;amp;amp;amp;quot;Performed Start Time&amp;amp;amp;amp;quot; to &amp;amp;amp;amp;quot;Performed End Time&amp;amp;amp;amp;quot;.

Graph #5:
– Please calculate, for each hour of performed start time, the average number of minutes from performed start time to performed end time for patient’s who had their order done in the East Wing or West Wing.

Graph #6:
– Please calculate the average number of minutes for each role (RN, Radiology Tech, PA, NP, Resident Physician) from Performed Start Time to Performed End Time. Please plot an additional datapoint for each role to represent a goal of 30 minutes.

– Please use the &amp;amp;amp;amp;quot;vlookup&amp;amp;amp;amp;quot; function to display the fake patient names from &amp;amp;amp;amp;quot;raw data #2&amp;amp;amp;amp;quot; on the&amp;amp;amp;amp;quot;raw data #1&amp;amp;amp;amp;quot; tab.

Graph #7:
– Please graph the time in minutes for each patient (patient name on the x axis) from &amp;amp;amp;amp;quot;Performed Start Time&amp;amp;amp;amp;quot; to &amp;amp;amp;amp;quot;Performed End Time&amp;amp;amp;amp;quot;