D
davy
Dear All,
I need to calculate the average time for a deliveries but without the
exceptional data points. For an example ,typically I will receive my
order in 7 days, but if I pay for express delivery costs , I receive
my order in 2 days. If there is a delay in the postal service or my
supplier has no stock then delivery could be in 14 days.
My question, is how do I calculate the average delivery time (via
excel) but remove the early deliveries. As I deliberately requested a
short delivery time and these deliveries seem to weight the average
delivery time unfairly. (The data set is very small, typically less
that 10 data points).
regards
Davy
I need to calculate the average time for a deliveries but without the
exceptional data points. For an example ,typically I will receive my
order in 7 days, but if I pay for express delivery costs , I receive
my order in 2 days. If there is a delay in the postal service or my
supplier has no stock then delivery could be in 14 days.
My question, is how do I calculate the average delivery time (via
excel) but remove the early deliveries. As I deliberately requested a
short delivery time and these deliveries seem to weight the average
delivery time unfairly. (The data set is very small, typically less
that 10 data points).
regards
Davy