Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i set up a normal distribution in excel?
I need to find out how you can set up a normal distribution curve on
microsoft excel. When I search normal distribution i get a function for it but i want to see the curve, which i can't figue out how to do |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i set up a normal distribution in excel?
"dimi" wrote: I need to find out how you can set up a normal distribution curve on microsoft excel. When I search normal distribution i get a function for it but i want to see the curve, which i can't figue out how to do In column A set up your X values, For example from -4 to +4. Increments of 0.1 should be OK. In column B use the NORMDIST function like this If you X values start at A1 then cell B1 should be =NORMDIST(A1,0,1,FALSE) Copy the formula down for all X values. Produce chart on Column B and use Column A for X values HTH Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Normal Distribution line | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I graph normal probability distributions in excel? | Excel Worksheet Functions | |||
how do i draw a distribution chart in excel | Charts and Charting in Excel |