ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   graph normal distribution (https://www.excelbanter.com/charts-charting-excel/164123-graph-normal-distribution.html)

Alicia

graph normal distribution
 
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!

David Biddulph[_2_]

graph normal distribution
 
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!





All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com