Submit the Excel Spreadsheet using Canvas.
Type your answers in a word processor, if necessary, and convert it to PDF format.
In order to make it easy to give you the marks you deserve, you need to communicate
clearly and concisely. Show your work in order to get full credit!
Medication Errors in Emergency Department [100 marks]
Excel File: HCM 403 - Module 5.XLSX
Samples of 100 medication orders placed in the emergency department (ED) are
checked each day against five potential types of errors. Tab Q1 in the Excel file shows
the number of medication errors recorded during the last 15 days. Develop the
appropriate control chart by conducting your calculations to obtain the values involved in
the control chart in the spreadsheet (70 Marks). Is the process in control? Why or why
not? (30 Marks)
Fig: 1