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

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

Комментарии

Информация по комментариям в разработке