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 (i.e. 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 77 patients in total and patient with Arrival ID 1 spents about 34.56 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!