Hi,
What are the mean and the standard deviation for the bell curve you want to
make?
In any case, the following suggestion is for making a normal distribution
curve for a mean of 4.0 and a standard deviation of 1.0:
In column A, starting at A1, create an array of x-values starting with four
standard deviations less than the mean and ending with four standard
deviations more than the mean (in our example 0.0 to 8.0) in increments of
say one-tenth the standard deviation (in our example, 0.1).
In B1, enter the formula,
=NORMDIST(A1,4,1,)
and drag the formula down the column.
Make an XY-plot of Column B vs Column A.
The general format of the formula is,
=NORMDIST(x-value,mean,standard deviation,)
HTH,
Best regards,
B. R. Ramachandran
