How to build CDF in excel?

[AAA]

I have some data shown below, how could I build the cdf from them? Just excel functions, no VBA.

Scenario 1 0.2
Scenario 2 0.4
Scenario 3 0.2
Scenario 4 0.73
Scenario 5 0.1
.
.
.
.


Thank you very much!

[whisper]

You do a running total of the pdf.

[Buck]

See picture.

[AAA]

Originally Posted by Buck

See picture.

Thank you very much for the example, but could you please be more specific?

Thanks.

[JMO]

Originally Posted by AAA

Thank you very much for the example, but could you please be more specific?

Thanks.

Maybe you should make your question more specific. I thought the example was specific enough.

[ADoubleDot]

Originally Posted by AAA

Thank you very much for the example, but could you please be more specific?

Thanks.

[Buck]

Right, there is nothing complicated in the answer I gave you -- "percentile" is the CDF.

However, you should know that Excel "percentile" function gives you a "model-fitted" CDF. If you need the raw empirical CDF, you need to use < Tools - add took pack -- analysis took pack> to get the frequency histogram function.

If this sounds too much to you, just remember Excel "percentile" does a pretty good job giving you a fitted CDF. The best part -- it's simple and easy to do.

[Arden Bensenhaver]

fit a curve?

[triplea]

I guess that's one alt I won't be able to create