Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi, i'm trying to get a bell curve graph with a STDEV of about 5 and a mean
of 13.8. I tried graphing the 1, 2, and 3 stdev above and below the mean and that didn't work. I just noticed this tutorial http://www.tushar-mehta.com/excel/ch...tion/index.htm, however i'm unsure why i have to use -4. I want the mean of 13.8 to show up on my graph. Any ideas? Thank you! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The -4 is the starting point of the graph, in that he's plotted from -4
standard deviations to +4 standard deviations. He's used a interval of 0.25 standard deviations between those points. You can plot over whichever range, and with whatever intervals, you like. You have given the rather unhelpful fault description of "it didn't work". If you want help, it may be worth telling us what results you got with which formula and which input values, and what you expected instead. -- David Biddulph "Alicia" wrote in message ... Hi, i'm trying to get a bell curve graph with a STDEV of about 5 and a mean of 13.8. I tried graphing the 1, 2, and 3 stdev above and below the mean and that didn't work. I just noticed this tutorial http://www.tushar-mehta.com/excel/ch...tion/index.htm, however i'm unsure why i have to use -4. I want the mean of 13.8 to show up on my graph. Any ideas? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
graph a normal distribution with skew and kurtosis | Charts and Charting in Excel | |||
Normal distribution, graph | Excel Discussion (Misc queries) | |||
How to graph normal distribution curve | Charts and Charting in Excel | |||
Graph a normal distribution chart? | Charts and Charting in Excel | |||
NORMAL DISTRIBUTION | Excel Worksheet Functions |