Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Normal distribution
Hi, good morning,
I have a list of values and intend to trace a graph of normal distribution. How I can make using excel 2007? Supose that this is the list: column A 91,00 88,00 79,00 78,80 77,00 75,30 74,00 72,40 71,00 68,00 66,00 65,50 65,40 62,30 61,00 59,00 56,00 55,90 55,00 Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Normal distribution
Plot either
NORMDIST(x,AVERAGE(data),STDEV(data),FALSE) vs. x or NORMDIST(x,AVERAGE(data),STDEV(data),TRUE) vs. x depending on whether you want the bell-shaped density curve or the S-shaped cumualtive curve. Jerry "Alexandra Lopes" wrote: Hi, good morning, I have a list of values and intend to trace a graph of normal distribution. How I can make using excel 2007? Supose that this is the list: column A 91,00 88,00 79,00 78,80 77,00 75,30 74,00 72,40 71,00 68,00 66,00 65,50 65,40 62,30 61,00 59,00 56,00 55,90 55,00 Thanks in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Normal distribution
Thank you very much!
Alexandra Jerry W. Lewis wrote: Plot either NORMDIST(x,AVERAGE(data),STDEV(data),FALSE) vs. x or NORMDIST(x,AVERAGE(data),STDEV(data),TRUE) vs. x depending on whether you want the bell-shaped density curve or the S-shaped cumualtive curve. Jerry "Alexandra Lopes" wrote: Hi, good morning, I have a list of values and intend to trace a graph of normal distribution. How I can make using excel 2007? Supose that this is the list: column A 91,00 88,00 79,00 78,80 77,00 75,30 74,00 72,40 71,00 68,00 66,00 65,50 65,40 62,30 61,00 59,00 56,00 55,90 55,00 Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph normal distribution | Charts and Charting in Excel | |||
Normal Distribution line | Excel Discussion (Misc queries) | |||
NORMAL DISTRIBUTION | Excel Worksheet Functions | |||
normal distribution curve | Charts and Charting in Excel | |||
Normal Distribution? | Excel Discussion (Misc queries) |