How to Create a Normal Curve - Distribution plot - Bell Curve - Normal Distribution graph in Excel

Подписаться 6 тыс.

Просмотров 136 тыс.

50% 1

001 A summary of Data and Statistic • 001 Data and Statistic...
002 Types of data • 002 Types of data. Att...
03 The important of graphs for analyzing data • 003 Using graphs to an...
004 Bar charts, Pareto charts and Pie charts • 004 Bar charts, Pareto...
005 Histogram and Dot plots • 005 Histogram and Dot ...
Create Histogram with Normal curve overlay in Excel • How to Create a Histog...
006 Individual Value Plots • 006 Individual Value P...
007 Box plots • 007 Box plots - What W...
008. Time Series Plots • 008 Time Series Plots ...
Critical to quality • Critical to quality VO...
What is Voice of Customer(VOC) • Voice of Customer(VOC)...
Why lean? What is lean? • Why lean? What is lean...
Why six sigma? What is six sigma? • Why six sigma? What is...
Six Sigma Certification Tollgate Checklist • Six Sigma Certificatio...
Process Capability, Capability indices, Cpk vs. Ppk, Capability Sixpack analysis • Process Capability, Ca...
Conduct normality test with Excel • Normality test - calcu...
Calculate StDev(Within), StDev(Overall) , Cp, Cpk using MS Excel • Subgroup greater than ...
Create Normal Curve - Distribution plot - Bell Curve - Normal Distribution graph in Excel in 5 steps • How to Create a Normal...

Опубликовано:

11 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@PPHerman 3 года назад

Best video out there. Just be patient.

@matsui8320 3 года назад

This is really helpful! Thank you so much

@LeanSixSigmaGlobal 3 года назад

You're so welcome!

@ethiolifetips2367 Год назад

Thank you so much.

@Luggruff 4 года назад

This makes no sense. Why are you calculating mean and StDev if you are not going to use it and instead overwrite them with manual values? It loses its connection to the source data completely..

@pratikmudholkar9626 2 года назад

Source data is actually linked to you overall population mean and std deviation

@koffisossou4442 3 года назад

Hello and thanks for the video. Where do the -3 and -2.9 come from ? plz

@hifipoetries1332 2 года назад

That's normal std

@nerminsokmen8057 6 часов назад

z-score

@dragonvietnam866 4 года назад

Great stuff

@nickfleming3719 4 года назад

Didn't you get the formula wrong for the normal distribution values? It should be "mean + (standard deviation * z-value)", you put minus

@pratikmudholkar9626 2 года назад

Could you please explain which part did he get wrong?

@lilchakras03 Год назад

yes please explain this part

@eatonlaw9282 Год назад

the sole purpose in step 3 is to multiple the figures from step 2, in order to create the x-axis for the graph according to the spread (aka sigma aka standard deviation), so he wasn't meant to calculate anything here, so i would say the formula is correct here

@nerminsokmen8057 4 часа назад

Yes it should be +. But even if the subtraction formula is applied, the result does not change because the average right and left are symmetrical.

@aruntram Год назад

How will you calculate normal standard deviation ?

@udicine Год назад

To calculate a normal standard deviation, use STDEV(). You can learn how to create dynamic bell curve from this lesson for FREE. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jzLGWoxPL8M.html

@MyBilal19971 2 года назад

Is it possible to draw a normal distribution for real process data? Or I would have to model and fit it into normal distribution?

@udicine Год назад

Yes you can, even creating dynamic bell curve. Learn more here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jzLGWoxPL8M.html

@duythieugia 3 года назад

Please make a video how to combine normal curve with historam chart

@LeanSixSigmaGlobal 3 года назад

Thanks, here you are ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bLhTsrmBjME.html

@brownstonecustomcabinetry5309 Год назад

Do I not have my volume on, or did you just make a video with no audio where you typed out the speech?

@954giggles Год назад

Why is there no sound 😅

@vanessasiqueira4002 Год назад

It is possible generating random variables in excel from truncated normal distribution?

@udicine Год назад

You can generate any value with ease by using scroll bar in Excel to create your dynamic bell curve. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jzLGWoxPL8M.html

@traiphamngoc9772 4 года назад

Why do we need -3 to 3 in step#2?

@PPHerman 3 года назад

Because the normal curve assumes that the mean is in the center, and that the data points you have should for the most part land between -3 standard deviations from the mean and then +3 standard deviations from the mean... just do what he says lol

@PPHerman 3 года назад

Think of the formula as “mean minus 3(standard deviations)” then “mean minus 2.9(standard deviations)” etc. the more times you do this, the smoother the curve and more precise the data

@angelicaforve8693 3 года назад

When I scroll down to calculate x, the equation keeps getting the wrong cells, what am I doing wrong? It keeps adding the ones below, here it is E4 and 5, in mine it adds the next cells and does not stick to the mean and SD ones.

@LeanSixSigmaGlobal 3 года назад

Hi, you can press F4 (or Fn+F4) key to fix reference cells