Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph a normal distribution chart?
I am having trouble graphing the percentage to the bell curve shape. Can
anyone help? Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph a normal distribution chart?
"Barbara" wrote in message
... I am having trouble graphing the percentage to the bell curve shape. Can anyone help? Thanks. If you're looking for the density function for the normal distribution, try =(EXP(-POWER(A2,2)/2))/SQRT(2*PI()) and scale appropriately. If you're looking for the cumulative, try =NORMSDIST(A2) -- David Biddulph |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph a normal distribution chart?
is the normal distribution curve based on the whole class's homework on time scores? And are the pupils the same, ie all come from the same sort of homes with the same level of parental support? -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=547635 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph a normal distribution chart?
David,
I am not sure about the formula. I try almost every sample formula but still can't curve the bell shape. What I want to do is have the mean as a percentage and the numbers are as followed: Do I use those formula you gave me as well? Thanks. 74% = 34/46 times 30% = 14/46 times 44% = 20/26 times 26% = 12/46 times how do i graph this? "David Biddulph" wrote: "Barbara" wrote in message ... I am having trouble graphing the percentage to the bell curve shape. Can anyone help? Thanks. If you're looking for the density function for the normal distribution, try =(EXP(-POWER(A2,2)/2))/SQRT(2*PI()) and scale appropriately. If you're looking for the cumulative, try =NORMSDIST(A2) -- David Biddulph |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph a normal distribution chart?
yes. here is an example i want to chart
out of 46 times 34 of the times is good that is 74% out of 46 times 30 of the times is okay that is 30% out of 46 times 20 of the time is not okay that is 44% (within this bracket, I want to chart another percentage) of the 44% that is 12/17 or 70% of the time does something else out of 46 times 12 of the time is bad that is 26% (within this bracket, I want to make another percentage) of the 26% that is 12/19 or 63% of the time does something else "robert111" wrote: is the normal distribution curve based on the whole class's homework on time scores? And are the pupils the same, ie all come from the same sort of homes with the same level of parental support? -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=547635 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Normal Distribution line | Excel Discussion (Misc queries) | |||
Normal Distribution line | Excel Discussion (Misc queries) | |||
Can I chart normal distribution in excel? | Charts and Charting in Excel | |||
Need help with chart graph not on chart wizard | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) |