Background: Recently, we started offering evening clinic providing telephone visits after 5:30 pm as an alternative to face-to-face visits to improve our services. We thought this would be a more convenient alternative to get our patients medical needs met without bringing them in. Attached is about 7 months worth of visit data, including telephone visits. After we launched the program, we wanted to use this data to determine how to staff for the evening telephone appointments (after 5:30 pm) and evaluate the effectiveness of the program. Please use the attached data to determine the effectiveness of the program by answering the following questions: - How many physicians should we need to staff for the evening after 5:30 pm telephone calls? Assume that 1 physician can take care of 4 telephone calls per hour. - How effective are our telephone appointments after 5:30 pm? An effective telephone appointment is the one where there are no follow-up appointments within the next 7 days after the date of the telephone visit. - Based on the available data, what suggestions would you have to improve the effectiveness of the telephone appointments (defined as reducing the number of telephone appointments that had a follow-up appointment within 7 days)

Please, use the Excel File attached to complete and Word directory for terminology. I would appreciate if you could do it in more presentable way, like with pivot table, advanced excel functions and charts, and provide the steps and reasoning. Would be even fantastic, If you can complete it by today.