Hi Jamal
Have a look at this link.
http://academy.excelhero.com/vanilla...uted-values/p1
Hope it helps.
Tony

Many thanks for the answer OTPM.

I couldn’t find an answer for my issue in the link that you have already provided.

My question is simple: how check whether particular values are normally distributed or not?

Is there a tool on the Excel which can do this sort of work straight forward?

Best

Jamal

Hi Jamal

Have you tried NORM.S.DIST()?

Tony

Many thanks for the prompt answer

I feel that my question is still not answered. For example, suppose that we have the values below:


Then how to check whether they are normally distributed or not?
How to apply the function “NORM.S.DIST()” in this case?

Best

Jamal

Attached Images

Clip_86.jpg (86.5 KB, 12 views)

Hi Jamal
Your question is probably a little beyond me. However have a look at this link which MAY help you:

http://www.oup.com/uk/orc/bin/978019...ox5-2excel.pdf

Good luck
Tony

Many thanks for the help. The link you have provided sounds to be very useful. I’ll try it and see it may solve my issue.

Appreciated

Jamal