The spreadsheet contains data on the number of visits to the Emergency Department (ED) of a hospital in our region for the last three weeks. The data excludes arrivals by ambulance and provides breakdown of the total number of patient visits by day of the week and 6-hours shifts. Based on this last three weeks of data, the ED manager is seeking help to forecast ED demand in terms of the number of patient visits for each day of the week and shifts over the next week. To help the ED manager achieve his goal, perform the following analyses, and assume the effect of seasonality to be a multiplicative effect.

a) Explore the data, create graphs and comment on the seasonality patterns in the data.

Explore the seasonality patterns by "day and the week" as well as by "day of the week and shifts." 

Transcribed Image Text:

Shift Week Day of Week 12 AM - 06 AM 06 AM - 12 PM 12 PM - 06 PM 12 PM - 12 AM 1 Monday 53 74 85 53 1 Tuesday Wednesday Thursday 52 70 86 52 1 46 66 87 56 1 52 73 84 52 1 Friday 53 77 82 53 1 Saturday 46 62 70 42 Sunday Monday Tuesday Wednesday Thursday 51 77 77 51 58 81 93 58 2 45 70 80 55 44 67 67 44 48 62 76 44 Friday Saturday 2 51 79 96 56 42 59 68 42 Sunday Monday 2 47 60 69 39 56 78 81 64 3 Tuesday Wednesday Thursday 52 76 84 50 46 64 74 46 46 65 72 58 Friday Saturday 54 76 87 54 47 65 74 38 3 Sunday 46 64 73 46 Shift Week Day of Week 12 AM - 06 AM 06 AM - 12 PM 12 PM - 06 PM 12 PM - 12 AM 1 Monday 53 74 85 53 1 Tuesday Wednesday Thursday 52 70 86 52 1 46 66 87 56 1 52 73 84 52 1 Friday 53 77 82 53 1 Saturday 46 62 70 42 Sunday Monday Tuesday Wednesday Thursday 51 77 77 51 58 81 93 58 2 45 70 80 55 44 67 67 44 48 62 76 44 Friday Saturday 2 51 79 96 56 42 59 68 42 Sunday Monday 2 47 60 69 39 56 78 81 64 3 Tuesday Wednesday Thursday 52 76 84 50 46 64 74 46 46 65 72 58 Friday Saturday 54 76 87 54 47 65 74 38 3 Sunday 46 64 73 46