software

I have collected a large amount of data (approx 400 data points) and I need
to represent the statistical date graphically, namely the Normal
Distribution. I understand the concept mathematically but I would like some
direction on how to accomplish this within Excel. (I have to do this in Excel
due to different groups, engineering and non-engineering, need to view the
data and graphs.

John F. -

You could start by using Excel's Histogram tool (part of the Analysis
ToolPak add-in that comes with Excel) that automatically prepares a
frequency distribution and histogram (column chart).

Or, you could use my free Better Histogram add-in, available for download
from www.treeplan.com.

If you also need to show the bell-shaped normal curve with the histogram,
the process is much more complicated, usually involving the NORMDIST
worksheet function and a combination chart (XY(Scatter) and Column chart
types).

- Mike
www.mikemiddleton.com

quot;John F.quot; gt; wrote in message
...
gt;I have collected a large amount of data (approx 400 data points) and I need
gt; to represent the statistical date graphically, namely the Normal
gt; Distribution. I understand the concept mathematically but I would like
gt; some
gt; direction on how to accomplish this within Excel. (I have to do this in
gt; Excel
gt; due to different groups, engineering and non-engineering, need to view the
gt; data and graphs.
Thanks that was helpful

quot;Mike Middletonquot; wrote:

gt; John F. -
gt;
gt; You could start by using Excel's Histogram tool (part of the Analysis
gt; ToolPak add-in that comes with Excel) that automatically prepares a
gt; frequency distribution and histogram (column chart).
gt;
gt; Or, you could use my free Better Histogram add-in, available for download
gt; from www.treeplan.com.
gt;
gt; If you also need to show the bell-shaped normal curve with the histogram,
gt; the process is much more complicated, usually involving the NORMDIST
gt; worksheet function and a combination chart (XY(Scatter) and Column chart
gt; types).
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;John F.quot; gt; wrote in message
gt; ...
gt; gt;I have collected a large amount of data (approx 400 data points) and I need
gt; gt; to represent the statistical date graphically, namely the Normal
gt; gt; Distribution. I understand the concept mathematically but I would like
gt; gt; some
gt; gt; direction on how to accomplish this within Excel. (I have to do this in
gt; gt; Excel
gt; gt; due to different groups, engineering and non-engineering, need to view the
gt; gt; data and graphs.
gt;
gt;
gt;