View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default Commulitive Distribution Function (CDF) Graphs

Is the chart an "XY (Scatter)" chart, not a "Line" chart?

Select CDF line on the chart and Format|Select Data series; is "Smoothed
line" checked?

If the answer to both of the these questions is "Yes", then you are not
including eoungh points in the region of extensive curvature.

Jerry

"Shai Rachamim" wrote:

I found another way using the NORMDIST function, but the graphs are still not
as smoove as graphs received in MATLAB by the simplest function CDF.
Shai.

"Mike Middleton" wrote:

Shai Rachamim -

For a discrete probability mass function, you can plot the cumulative
distribution using an XY (Scatter) chart with error bars. For instructions,
see Tushar Mehta's web site
http://www.tushar-mehta.com/excel/charts/step_chart/

For a continuous probability density function, you can plot the cumulative
distribution using an XY (Scatter) chart using many pairs of x and f(x) in
worksheet cells (and optionally using the "smoothed line" format).

- Mike
http://www.mikemiddleton.com

"Shai Rachamim" <Shai wrote in message
...
What is the simplest way to plot a commulitive distribution function
graph? I
would like to add several graphs in one chart if possible.