View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shai Rachamim Shai Rachamim is offline
external usenet poster
 
Posts: 2
Default Commulitive Distribution Function (CDF) Graphs

Yes and yes.
Excel is a fair analyzing for CDF graphs, but in MATLAB you simply input the
array into the CDF function, and you get a neat graph, with the x axis
continued high and low (in the edges where y values reaches 100% and 0%).
Thanks anyway,
Shai.

"Jerry W. Lewis" wrote:

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.