View Single Post
  #4   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

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.