View Single Post
  #3   Report Post  
Michael R Middleton
 
Posts: n/a
Default

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