Hello all
1st time user of this forum. I will freely admit I am not very adept with statistics and this is really the 1st part of my question please bear with me.
I work in a health system and I am trying to figure out probability or likelihood of an event being able to occur
I have attached a PDF copy of my spreadsheet to help illustrate what I am trying to get across. The spreadsheet reflects typical appointment times for a provider on any given day. In scenario 26 I am pointing out that there are times set aside on a providers schedule for what we call TELEMED visits ( which mean no on site appts will be seen)
Relative to medical providers, a typical schedule in an office would consist of 15 minute time slots for 4 hours per session ( AM and PM) for each provider
Appointments are structured with a 15 min common denominator: i.e. office visit = 15 min, a physical or new patient visit are typically 30 mins, and in some cases providers may use 45 mins for consults.
What I am trying to calculate is what is the likelihood or probability ( not sure if these are the right terms) of being able to schedule an elongated appt ( Physical, New Patient, Consults ) as the schedule fills up with 15 min visits ( office visit) as the day progresses in a session
Thank you in advance
1st time user of this forum. I will freely admit I am not very adept with statistics and this is really the 1st part of my question please bear with me.
I work in a health system and I am trying to figure out probability or likelihood of an event being able to occur
I have attached a PDF copy of my spreadsheet to help illustrate what I am trying to get across. The spreadsheet reflects typical appointment times for a provider on any given day. In scenario 26 I am pointing out that there are times set aside on a providers schedule for what we call TELEMED visits ( which mean no on site appts will be seen)
Relative to medical providers, a typical schedule in an office would consist of 15 minute time slots for 4 hours per session ( AM and PM) for each provider
Appointments are structured with a 15 min common denominator: i.e. office visit = 15 min, a physical or new patient visit are typically 30 mins, and in some cases providers may use 45 mins for consults.
What I am trying to calculate is what is the likelihood or probability ( not sure if these are the right terms) of being able to schedule an elongated appt ( Physical, New Patient, Consults ) as the schedule fills up with 15 min visits ( office visit) as the day progresses in a session
Thank you in advance
Attachments

170.9 KB Views: 2
Last edited: