Eliminating High Date to Appointment times to Get Average

Hi there,
I am trying to figure out how to come up with an average time to appointment for each Provider and appointment type. There is a lot of noise in the data which is giving me some really high averages. Those maybe some anomalies due to patient preference. Ultimately what I would like to report, in a pivot table that shows me average appointment wait time for each category by physician by type of appointment and their respective practice. The table I have is lengthy because it contains a number of practices and many physicians in each practice. I don't want to cut data up to eliminate these high appointment wait times.

Does anyone have any ideas on how can I accomplish this?

Thank you kindly.

I can imagine Annual Physicals having a year for time to appointment ... but how can there be 366 days for Acute visit appointments? I'm trying to work out what rules to apply for which appointments to eliminate ... please advise if you have any rules already.

Well that is fictitious data. You are 100 percent, we would have a problem if that was the case. It was just for the purpose of illustration.

Ideally I wanted a normal distribution curve that would give us a spread of times it takes to book an appointment for various appointment types. I tried messing with creating a bell curve but excel crashed on me.

I dont know if its possible to eliminate the top 20 percent and the bottom 20 percent of data?

Take a look at using mean and a multiple of standard deviation to eliminate outliers from a group. I doubt I would be able to generate anything without realistic data, to be able to do testing.