You can ftp the following example which shows how to generate normal
distributions in excel:
ftp://rohan.sdsu.edu/faculty/vandenberg/Normal.XLS
I think it demonstrates what you are trying to do. You should be able to
adapt it to your problem.
Pieter Vandenberg
: I did not ask the right question. I am trying to plot
: the distribution of the occurance of values. Out of a set
: of data if the value 111 occurs 50 times I want it to
: plot x=111, y =50. If the value 25 occurs 10 times I
: want it to plot x=25 y= 10. I hope I am stating this
: correctly.
: This data should form a bell curve. It is the bell curve
: that I am after. Any suggestions?
:>-----Original Message-----
:>Stephen -
:>
:>You need to add three vertical lines to your chart. One
: at the mean, and
:>one each at the mean ? the standard deviation. Use one
: of these
:>techniques for the lines:
:>
:>
http://peltiertech.com/Excel/Charts/AddLine.html
:>
:>I'd use the error bar approach, and use the values of
: the points as data
:>labels to augment the existing X axis.
:>
:>- Jon
:>-------
:>Jon Peltier, Microsoft Excel MVP
:>Peltier Technical Services
:>Tutorials and Custom Solutions
:>
http://PeltierTech.com/
:>_______
:>
:>Stephen wrote:
:>
:>> I am trying to chart a bell curve, or what might be
:>> called the normal distribution of a set of data. I
: want
:>> to show the standard deviation of this data. I can
:>> calculate the standard deviation easy enough. Can I
:>> easily chart the data?
:>>
:>
:>.
:>
