Phil Hageman
15 supervisors submit estimates of time to complete a task. I would like
to
plot the values, and, a normal distribution curve - then, using the chart,
draw a consensus as to the most accurate time for the task. What would
comprise such a chart and, would there be a way to model the estimated
times
to produce the consensus (formulas, functions, VBA, etc)?

Thanks,
Phil

Hi Phil,

I am not sure that you will necessarily get a "normal curve". I might be
inclined just to plot a histogram.

Tools | Data Analysis | Histogram.

Just food for thought.

Regards,
Kevin