Question: Use the patient log data and find an efficient method to calculate patient time in clinic for all patients. Build an histogram for the patient
Use the patient log data and find an efficient method to calculate patient time in clinic for all patients. Build an histogram for the patient time in clinic and report statistics ie average, min, max, std dev. Submit your excel file and insert relevant comments for a discussion of how you solved the problem. No discussion, no points!!!
Note: Patient time in clinic includes both time spent in the individual locations and transfer time between the locations. Use Arrival ID as the unique patient identifier. There should be patients in total and patient with Arrival ID spents about minutes in the clinic.
Optional part: Can you suggest a distribution for the patient time in clinic data?
PatientLocationLog.txt PatientLocationLog.txt
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
