View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default how do I create a histogram with gaussian curve

iornbear78 -

Histogram
Excel | Tools | Data Analysis | Histogram
with instructions at http://peltiertech.com/Excel/Charts/Histograms.html
or
Better Histogram free add-in download from http://www.treeplan.com

Gaussian curve
http://www.tushar-mehta.com/excel/ch..._distribution/

Combination chart example of a histogram (Column chart type) with normal
density function (XY Scatter chart type)
http://www.mikemiddleton.com/Histogr...ormalCurve.xls

- Mike
http://www.mikemiddleton.com


"iornbear78" wrote in message
...
I need help using excel to create histograms with gaussian curves. I need
to
know how to get CPK data from that as well with 6 sigma deviation. I would
also like to have the min and max values displayed as well.