2. The Mecy Hosptal HIM Department has produced the folowing average daily inpe

Question

2. The Mecy Hosptal HIM Department has produced the folowing average daily inpe tient census data for each day of the week for a one-year period. Enter the data into a spreadsheet and do the folowing: Day of Week Inpatient Average 107.5 102.2 96.4 90.7 89.1 93.4 Wednesday Friday Saturday Sunday a. Use Excel to construct a histogram (chart with vertical bars) of the average inpatient census for each day of the week. b. Insert the days as labels for the axis. . Use Excel to give the chart an appropriate title. d. Use Excel to indicate that the chart should go on a new worksheet. e. Interpret the chart and gst any kind of pattern in inpatient census for Mercy Hospital

Explanation / Answer

Here is the link to my drive, of the excel file. If you need step by step explanation, let me know below, I will make you a flowchart.

https://drive.google.com/open?id=1sRCsfzJSdqhk0vioZ76GgpM2ZRs32Mj-

There is a slight circular pattern. Like, teh average value increases in the beginning of the week, and then decreases gradually upto the weekends and increases again.

If you have doubts, let me know below.Let me know if it helps. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.