One of the local hospitals wants to assure that they have enoughnurses for incoming patients needing assistance, especially in theemergency room. To insure there are enough nurses on duty, but notan overage which would waste hospital resources, the following dataregarding the number of patients entering the hospital over thelast several weeks has been gathered. The data does not includeweekend patient traffic, as the hospital has previously done asimilar study and staffed weekends appropriately. You are toanalyze the data using ANOVA methodology and determine if there areany differences in the number of patients served by the day of theweek. If you find there are differences, which days seem to be thebusiest? You are to write a report to the hospital nursing managerof your findings. Be sure to include the problem statement (whatyou were asked to do), your analysis (include the statisticalmethodology used with graphs, charts, formulas, etc.), and yourfindings, along with a recommendation for staffing. Report length:4-6 pages DATE DAY #PATIENTS 10/30/14 Monday 38 10/31/14 Tuesday 2911/1/14 Wednesday 28 11/2/14 Thursday 30 11/3/14 Friday 36 11/6/14Monday 29 11/7/14 Tuesday 25 11/8/14 Wednesday 23 11/9/14 Thursday26 11/10/14 Friday 36 11/13/14 Monday 38 11/14/14 Tuesday 2911/15/14 Wednesday 24 11/16/14 Thursday 20 11/17/14 Friday 3311/20/14 Monday 28 11/21/14 Tuesday 29 11/22/14 Wednesday 2811/23/14 Thursday 25 11/24/14 Friday 34 You will need to createyour own Excel sheet using the data above in order to run the ANOVAcalculation. To help aid in what should be in your first CaseStudy, you can use this as a quick checklist of the most importantthings. This isn't all inclusive as you are expected to write outwhat you did, why you did it and explain your logic. - hypothesisand null hypothesis - ANOVA - a follow-up statistical test/s toshow where the differences are occurring - graphs/charts/tablesreferencing your analyses and findings - results as well as what wecan conclude and what the next steps/decisions of the hospitalshould be