Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / October 2007

Tip: Looking for answers? Try searching our database.

graph normal distribution

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alicia - 30 Oct 2007 14:56 GMT
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/charts/normal_distribution/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 - 30 Oct 2007 21:11 GMT
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.
Signature

David Biddulph

> Hi, i'm trying to get a bell curve graph with a STDEV of about 5 and a
> mean
[quoted text clipped - 5 lines]
> up
> on my graph.  Any ideas? Thank you!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.