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

K

Kizzy

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!
 
M

Martin P

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

Similar Threads

Calculate the median value before a specified list 0
Force Distribution/ Force Ranking for Bell Curve 1
Normal distribution curve 2
How to break up a book's endnotes by chapter in a file containing a whole book? 0
How to chart a bell curve with x, mean, standard deviation, cumula 1
Drop down list control value in vba 2
Autonumber field in Excel that behaves the same as Access 0
Finding asymptote equation and how to draw them in excel 0

Top