Understasnding the two different functions

[Geraldtanwx1990]

Capture.PNG

Am playing around with excel function to do a normal distribution curve.

I was wonder if there is any difference between the two graphs?( one done using Z value, the other done using norm.dis function).

Are both of the graphs correct?

[MarvinP]

Hey Gerald,

The coordinates on the graphs are different. Did you ask if both graphs look like a bell shaped curve. Yes they look similar but the scales are different so they are different.

Maybe this site will explain it better:
https://www.thoughtco.com/excel-norm...s-dist-3126614
where it says the curves are identical.

Or this link:
http://www.exceluser.com/formulas/statsnormal.htm

[Geraldtanwx1990]

Thanks Marvin!

Really appreciate your help!

So both graph and area under the cruve does give me a rough estimate of the population?

[MrShorty]

So both graph and area under the cruve does give me a rough estimate of the population?

This seems like more of a statistics question rather than an Excel question, and I am not sure I am statistician enough to give a solid answer. From what I can gather (see here http://stattrek.com/probability-dist...ns/normal.aspx for example), the area under any normal curve is 1 (or 100%), whether you have a population of 10 or 10E6. It seems to me that the area under a normal curve, by itself, would not tell you anything about population or sample size.