How to Construct a Cumulative Distribution Plot in Excel 2007

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 35

  • @MdMainuddinJU
    @MdMainuddinJU 4 года назад +5

    There is no way someone could explain me CDF easier than this man.

  • @Hajjat
    @Hajjat 7 лет назад +1

    Man you're awesome! Never thought plotting a CDF in Excel was that easy!
    I've been always using tools in Linux, etc. but this one is amazing!

  • @mechmoh1421
    @mechmoh1421 2 года назад

    this is a decade later, but thank you, this helped me with My decisions making under uncertainty class.

  • @churui582
    @churui582 3 года назад

    THANKS ALOT you remind me of changing title and axises

  • @pablo19852000
    @pablo19852000 11 лет назад

    Thank you very much Sir!!, you saved me a lot of time trying to figure this out.

  • @tc285202
    @tc285202  11 лет назад

    Indeed - data recording resolution is a better way to describe it. As far as digital acquisition goes, it depends on the measurement being taken - in the engineering world, our measurements are, for the most part, digitally acquired, but analog instrumentation or other types of data will not necessarily be associated with an A/D converter. Whether the conversation is about bit depth or the resolution of an analog device, the result and cause are essentially the same.

  • @mayaz.2858
    @mayaz.2858 7 лет назад

    Very helpful! Thank you very much! !
    Now it is time for PDF...
    ---one struggling with homework

  • @karlhiscock92
    @karlhiscock92 3 года назад

    Here is the second part for those who need it

  • @tomstruct
    @tomstruct 5 лет назад

    Thanks heaps for this, very helpful and clear examples

  • @rafaelcosta9440
    @rafaelcosta9440 4 года назад +1

    That's really helpful! Thanks a lot! Is there an explanation on how to plot CCDF? (Complementary Cumulative Distribution Function)

  • @edsmartlang6307
    @edsmartlang6307 5 лет назад +1

    tnx a great relearning/review ,more power

  • @ouodi
    @ouodi 11 лет назад

    Thanks for the review in cumulative probability.

  • @leisureurban
    @leisureurban 8 лет назад

    It is really helpful for me. Thank you.

  • @bontron1000
    @bontron1000 11 лет назад

    Thank you SO MUCH! This video was so helpful.

  • @dragonemperor007
    @dragonemperor007 8 лет назад

    Thanks a lot. Saved my day.

  • @tc285202
    @tc285202  12 лет назад

    Data is data - if you have repeated values from what ought to be a continuous variable, then it's evidence of a resolution problem - your measuring device isn't precise enough. In any case, if the data is valid, leave it in. You'll see a vertical jump on the graph at your repeated value, which is a good way to spot resolution problems with instrumentation. Does that make sense?

  • @alexandrekisner5369
    @alexandrekisner5369 7 лет назад

    Thank you so much ! Very helpful !

  • @BillM1960
    @BillM1960 11 лет назад

    Do you not mean your data recording resolution? Chances are it's not the measurement but the digital acquisition of the measurement's resolution that's at issue with repeated values. Analog to digital conversion of less than 12 bit is awful and 12 bit is bad but around 16 bit gets very good. I guess it depends on what you need. Cheap A/D is easier these days than when I was growing up. If you are not at least using 16 bit, look at that first and the quality of your sensors and outputs. Nice vid.

  • @jnseiios
    @jnseiios 12 лет назад

    excellent video... thank you very much!

  • @razia9689
    @razia9689 10 лет назад

    I'm confused on one issue - Your graphical explanation of the average uses the median to calculate the average. That is, you organize the data and find the value 50% along the way to calculate the average. Then you compare this to the average calculated with the mean formula. Are these values close but not the same?

  • @sophia2928
    @sophia2928 5 лет назад +1

    but if the values are repeating it is possible that have the same frequency?

  • @MaheshKumarshan
    @MaheshKumarshan 12 лет назад

    Just a small question: CDF tell us that the probability of a particular value on x axis is equal to value on y axis right?

  • @MaheshKumarshan
    @MaheshKumarshan 12 лет назад

    Ok basically what i have is distances for a list of locations... So in this case should i take the repeated values?

  • @qahharqadir395
    @qahharqadir395 10 лет назад +1

    Great, thanks mate.

  • @sophia2928
    @sophia2928 5 лет назад

    thank u so muuuuuuuuuuuch :D

  • @sophia2928
    @sophia2928 5 лет назад

    thanks :D awesome

  • @iamdumbmatt
    @iamdumbmatt 7 лет назад +4

    doesnt look like a normal distribution, looks uniform to me

    • @BiscuitZombies
      @BiscuitZombies 5 лет назад

      True, a normal distribution has a stretched 'S' look to it.

  • @miketyson1640
    @miketyson1640 5 лет назад

    This is definitely pedantic, but the approach of assigning frequencies as p = n/N is biased when modeling sample data - median ranks (or Benard's approximation, Kaplan-Meier, etc) should be used instead.

  • @jujupianolover
    @jujupianolover 11 лет назад

    Thanks! :)

  • @mahsal5532
    @mahsal5532 6 лет назад

    thanks

  • @MaheshKumarshan
    @MaheshKumarshan 12 лет назад

    If I have similar data, but also have repeated values, o do i have to remove the repeated values? or should I keep them, because with repeated values my graph looks kind of odd...Pls respond

    • @sophia2928
      @sophia2928 5 лет назад

      i have the same question

  • @neurosyd9985
    @neurosyd9985 Год назад

    What’s the largest value?

  • @ocranerioriaj
    @ocranerioriaj 11 лет назад

    *you're OR you are