Commulitive Distribution Function (CDF) Graphs

[Guest]

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

 

[Philippe L. Balmanno]

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

If you know your statistics it's "cumulative distribution."
Ensure you data analysis addins are installed and active.
Descriptive statistics and Histogram are choices under Tools/Data
Analysis...
If you need help on charts for statistics see
http://peltiertech.com/Excel/Charts/statscharts.html
Here is a lesson in CDF charting in Excel
http://ardent.mit.edu/real_options/ROcse_Excel_latest/Excel 06 Session2.pdf

 

[Mike Middleton]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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.

 

[Jon Peltier]

MatLab and Excel are completely different. You can get some of the same
effects in Excel as in MatLab, but Excel makes you work harder for them.

- Jon