I agree that it's usually a good idea to first "look at the data." And, if
you want a better histogram, arrange the fifteen values in a column on a
worksheet, and use my free add-in to obtain the frequency distribution and
histogram. Visit the "Better Histogram" page at
www.treeplan.com.
- Mike
www.mikemiddleton.com
++++++++++++++++++
"Kevin H. Stecyk" wrote in message
...
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