How do I get a normal curve in Excel with values 0-200000?

G

Guest

I need to make a normal distribution chart for class and don't know how? I
know that I have to use NORMDIST but I don't know how to get my x value. When
I make my graph it is just one line. Please help!
 
G

Guest

My suggestion:
In column A from A1 create a series from -3 to +3 in 0.1 increments. In B1
enter
=NORMDIST(A1,0,1,FALSE)
and copy this down.
Use XY (Scatter) on your chart wizard to create the chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top