| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| bell-shape normal distribution curve | Charts and Charting in Excel | |||
Linear Mode
