Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 34
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
graph a normal distribution with skew and kurtosis MarkS Charts and Charting in Excel 9 April 3rd 23 06:59 PM
Normal distribution, graph Henrootje Excel Discussion (Misc queries) 2 September 3rd 07 01:41 PM
How to graph normal distribution curve GH Charts and Charting in Excel 1 August 25th 06 09:03 AM
Graph a normal distribution chart? Barbara Charts and Charting in Excel 4 June 2nd 06 08:02 PM
NORMAL DISTRIBUTION FLKULCHAR Excel Worksheet Functions 13 October 27th 05 10:35 PM


All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"