If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I add a Gaussian curve to a histogram on Excel?
Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
dont know how. Any tips or advice? Thanks |
#2
|
|||
|
|||
This may help
http://www.tushar-mehta.com/excel/ch..._distribution/ "JC1379" wrote in message ... Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I dont know how. Any tips or advice? Thanks |
#3
|
|||
|
|||
JC1379 -
Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I dont know how. Any tips or advice? One way is to use a combination chart, with a Column chart type for the vertical histogram bars and an XY (Scatter) chart type for the normal density curve. You could start with the chart generated by my free Better Histogram add-in, available at www.treeplan.com, which produces a combination chart (so that the horizontal axis is more properly labeled), and then you could change that chart's XY (Scatter) data series to be based on worksheet data using NORMDIST for the curve. You must be careful about scaling so that the Column chart type and the XY (Scatter) chart type are aligned correctly. - Mike www.mikemiddleton.com |
#4
|
|||
|
|||
How can I add a Gaussian curve to a histogram on Excel?
Mike,
I just downloaded your Better Histogram and the PDF. When I tried to overlay a normal curve on the secondary axis (so that I can dispense with the secondary axis line, etc.), it just didn't fit the curve over the entire spectrum of values (those from the histogram on the primary axis)? Any thoughts? Thanks Ariel "Mike Middleton" wrote: JC1379 - Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I dont know how. Any tips or advice? One way is to use a combination chart, with a Column chart type for the vertical histogram bars and an XY (Scatter) chart type for the normal density curve. You could start with the chart generated by my free Better Histogram add-in, available at www.treeplan.com, which produces a combination chart (so that the horizontal axis is more properly labeled), and then you could change that chart's XY (Scatter) data series to be based on worksheet data using NORMDIST for the curve. You must be careful about scaling so that the Column chart type and the XY (Scatter) chart type are aligned correctly. - Mike www.mikemiddleton.com |
#5
|
|||
|
|||
How can I add a Gaussian curve to a histogram on Excel?
Ariel -
Appropriate scaling of all four axes is critical. I do not have time to describe step-by-step instructions for the task, but I have just posted an example worksheet of the results at http://www.mikemiddleton.com (bottom left corner of the web page). - Mike "Ariel" wrote in message ... Mike, I just downloaded your Better Histogram and the PDF. When I tried to overlay a normal curve on the secondary axis (so that I can dispense with the secondary axis line, etc.), it just didn't fit the curve over the entire spectrum of values (those from the histogram on the primary axis)? Any thoughts? Thanks Ariel "Mike Middleton" wrote: JC1379 - Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I dont know how. Any tips or advice? One way is to use a combination chart, with a Column chart type for the vertical histogram bars and an XY (Scatter) chart type for the normal density curve. You could start with the chart generated by my free Better Histogram add-in, available at www.treeplan.com, which produces a combination chart (so that the horizontal axis is more properly labeled), and then you could change that chart's XY (Scatter) data series to be based on worksheet data using NORMDIST for the curve. You must be careful about scaling so that the Column chart type and the XY (Scatter) chart type are aligned correctly. - Mike www.mikemiddleton.com |
#6
|
|||
|
|||
How can I add a Gaussian curve to a histogram on Excel?
Excellent, this is better than an explanation!
"Mike Middleton" wrote: Ariel - Appropriate scaling of all four axes is critical. I do not have time to describe step-by-step instructions for the task, but I have just posted an example worksheet of the results at http://www.mikemiddleton.com (bottom left corner of the web page). - Mike "Ariel" wrote in message ... Mike, I just downloaded your Better Histogram and the PDF. When I tried to overlay a normal curve on the secondary axis (so that I can dispense with the secondary axis line, etc.), it just didn't fit the curve over the entire spectrum of values (those from the histogram on the primary axis)? Any thoughts? Thanks Ariel "Mike Middleton" wrote: JC1379 - Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I dont know how. Any tips or advice? One way is to use a combination chart, with a Column chart type for the vertical histogram bars and an XY (Scatter) chart type for the normal density curve. You could start with the chart generated by my free Better Histogram add-in, available at www.treeplan.com, which produces a combination chart (so that the horizontal axis is more properly labeled), and then you could change that chart's XY (Scatter) data series to be based on worksheet data using NORMDIST for the curve. You must be careful about scaling so that the Column chart type and the XY (Scatter) chart type are aligned correctly. - Mike www.mikemiddleton.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fit bell curve to histogram | cwinters | Charts and Charting | 1 | June 14th, 2005 02:03 AM |
watch a curve change over time like a movie | RandyBarrett | Charts and Charting | 6 | February 19th, 2005 05:00 AM |
How to draw a gaussian curve with Excel? | BigRu | Charts and Charting | 3 | February 6th, 2005 04:41 PM |
Vertical ND Curve on Combination Chart | Phil Hageman | Charts and Charting | 4 | December 30th, 2004 06:07 PM |
trouble with histogram use | Beth_gis | General Discussion | 1 | August 14th, 2004 04:49 AM |