Reference no: EM132295090

One of the local hospitals wants to assure that they have enough nurses for incoming patients needing assistance, especially in the emergency room. To insure there are enough nurses on duty, but not an overage which would waste hospital resources, the following data regarding the number of patients entering the hospital over the last several weeks has been gathered. The data does not include weekend patient traffic, as the hospital has previously done a similar study and staffed weekends appropriately. You are to analyze the data using ANOVA methodology and determine if there are any differences in the number of patients served by the day of the week. If you find there are differences, which days seem to be the busiest? You are to write a report to the hospital nursing manager of your findings. Be sure to include the problem statement (what you were asked to do), your analysis (include the statistical methodology used with graphs, charts, formulas, etc.), and your findings, along with a recommendation for staffing.

DATE                     DAY                  #PATIENTS

10/30/14                 Monday                     38

10/31/14                 Tuesday                     29

11/1/14                   Wednesday                28

11/2/14                   Thursday                   30

11/3/14                   Friday                        36

11/6/14                   Monday                     29

11/7/14                   Tuesday                     25

11/8/14                   Wednesday                23

11/9/14                   Thursday                   26

11/10/14                  Friday                       36

11/13/14                  Monday                    38

11/14/14                  Tuesday                    29

11/15/14                  Wednesday               24

11/16/14                   Thursday                  20

11/17/14                   Friday                       33

11/20/14                   Monday                    28

11/21/14                   Tuesday                    29

11/22/14                   Wednesday               28

11/23/14                   Thursday                   25

11/24/14                   Friday                        34