Getting a Normal Distribution

  • Thread starter Thread starter mozart
  • Start date Start date
M

mozart

I have a single random variable with some data and i have plotted thi
on a histogram grouping the data in bins.

Now I wish to superimpose a normal curve over the top of this data t
see graphically how much it deviates from the normal.

I am having problems creating this graph

My bins are 41,42,43,44,45,46,47,48 and my mean is 43 and std 1.5

How can i generate this normal curve. I was playing around with th
normdist() function but i end up getting small values.

Thank
 
=NORMDIST(x,43,1.5,FALSE)

Gives the normal probability density at x. For plotting over your
histogram, remember that the integral under this bell-shaped curve is 1,
while the integral under your histogram is n, so you would overlay your
histogram with
=n*NORMDIST(x,43,1.5,FALSE)

Jerry
 
Back
Top