How do I get a normal curve in Excel with values 0-200000?
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! |
How do I get a normal curve in Excel with values 0-200000?
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. "Kizzy" wrote: 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! |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com