ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do I create a histogram with gaussian curve (https://www.excelbanter.com/charts-charting-excel/123050-how-do-i-create-histogram-gaussian-curve.html)

iornbear78

how do I create a histogram with gaussian curve
 
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.

Mike Middleton

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.





All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com