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

"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.

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/R...20Session2.pdf

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.

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.

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.

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.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Shai Rachamim" wrote in message
...
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.