Histogram, And "Normal" Curve For ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello,

Forget the two previous posts of mine re Histograms.
Am happy to say that I figured out how to select and use the Bin size.

But, now that I actually have the Histogram, is there any way to have a
curve show up over the (bin) columns; e.g., one that looks like a normal
distribution (assuming it roughly is) by using the columns Y values as
shown ?

In other words, having an distgribution actual curve on the graph, as
well as the bin columns ?

Thanks,
Bob
 
Hello,

Forget the two previous posts of mine re Histograms.
Am happy to say that I figured out how to select and use the Bin size.

But, now that I actually have the Histogram, is there any way to have a
curve show up over the (bin) columns; e.g., one that looks like a normal
distribution (assuming it roughly is) by using the columns Y values as
shown ?

In other words, having an distgribution actual curve on the graph, as
well as the bin columns ?

Thanks,
Bob
Click to expand...

If you have plotted the histogram using the midpoint of each bin on
the X axis, then this should work.
Find the mean, sd and n your original data.
For each bin midpoint, work out how many would have been in that bin
if the data was normal. =NORMDIST(bin midpoint,mean,sd,0)*n*bin width
Plot a double histogram with the data and calculated values. Select
the normal series and change the series chart type to XY scatter with
smoothed line.

Cheers, D
 
Back
Top