Question: Conduct a time series analysis on the data - both the calls received and the urgent calls. That's all the instructions I am going to
Conduct a time series analysis on the data - both the calls received and the urgent calls. That's all the instructions I am going to give you (imagine I am a bad stakeholder).
Think about these things: What time series analysis can you conduct on this sheet by using EXCEL 
Month/YearCallsReceivedJan-14Feb-14Mar-14Apr-14May-14Jun-14Jul-14Aug-14Sep-14Oct-14Nov-14Dec-14Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16UrgentCallsReceived2,0152,0682,0772,1552,3572,4892,6682,7792,8582,1332,0442,0192,0162,1212,2372,5202,6002,8003,0113,0503,1302,5712,2542,2722,2182,3402525453465467485530560600625643480460454454477503567585630677686704578507511499527568 Month/YearCallsReceivedJan-14Feb-14Mar-14Apr-14May-14Jun-14Jul-14Aug-14Sep-14Oct-14Nov-14Dec-14Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16UrgentCallsReceived2,0152,0682,0772,1552,3572,4892,6682,7792,8582,1332,0442,0192,0162,1212,2372,5202,6002,8003,0113,0503,1302,5712,2542,2722,2182,3402525453465467485530560600625643480460454454477503567585630677686704578507511499527568
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
