Overlay histogram & normal distribution chart, bell curve: secondary axis | Excel 1-2| IHDE Academy

Overlay histogram & normal distribution chart, bell curve: secondary axis | Excel 1-2| IHDE Academy

HomeOther ContentOverlay histogram & normal distribution chart, bell curve: secondary axis | Excel 1-2| IHDE Academy
ChannelPublish DateThumbnail & View CountActions
Channel Avatar IHDE Academy2022-12-16 07:24:37 Thumbnail
22,970 Views
In Microsoft Excel, superimposing or overlaying a histogram with the normal distribution or bell curve (Gaussian) in a diagram is not easy.
In this lesson, an example will show how to do this for the same dataset.
The scatter xy diagram is used for this.
This has the option of adding a secondary axis (second y-axis) and error indicators.

With this knowledge, you then have a reasonable basis for visually comparing the distribution of values in a histogram with the normal distribution.

I wish you much success.

Rolf Ihde

Please take the opportunity to connect and share this video with your friends and family if you find it useful.