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

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

Excellent! Tkeep up the good work pls.

wcemkfd
Автор

Thank you! Finally made sense after watching your video!

MarthaCoronel-yi
Автор

Love the music, I happen to learn piano and excel at the same time.😊

LauraLang-hxyo
Автор

I'm happy you're doing something you know. I tried to follow but I kept on trailing behind. I will watch again.

mjmeternal
Автор

Great video! Just one question. How did you decide the x-axis values for the bell curve?

nicholasspaeth