The Mean and Standard Deviation of a Probability Distribution using Excel

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

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

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

    You are my saving grace! I FINALLY understand this!!!!!!!!!!

  • @chidachapagain6637
    @chidachapagain6637 6 лет назад +2

    Thanks, man!! very helpful

  • @HerdingDogRescuer
    @HerdingDogRescuer 8 лет назад +3

    This video is helpful, but the formula you are using for variance is not as it's detailed in my text so I am a bit confused. My text says Variance is (X - mean)^2 (P(x)). Is that the same as what you are doing here? It seems like it, but I want to be sure. Thanks!

    • @rudysingh5119
      @rudysingh5119 8 лет назад +2

      +HerdingDogRescuer
      The formula you give is correct. The version I used: Sum( x^2 * P(x)) - mean^2 is an alternative version that is easier to use for calculation. Either one will give the same answer. Thanks for watching the video.

  • @normajean5975
    @normajean5975 4 года назад

    I dont understand where all those numbers came from?

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

    why is it raised to the .5 on the standard deviation?

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

      The standard deviation involves taking a square root. taking a square root is the same as raising it to the 0.5 power.

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

    Why you square rooted the std x 0.5?

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

      I square rooted the Variance. To square root a number you raise it to the 0.5 power (not multiplication by 0.5 - it is an exponent). I.E. Variance ^ 0.5 = Standard Deviation.

  • @Alchemistje9
    @Alchemistje9 9 лет назад

    can you add finding the range of usual values?

    • @009rud
      @009rud  9 лет назад

      +Jenine Guerrero
      So to find the range of usual values, you take the mean + or - 2 standard deviations. Thus, for the example take the mean of 1.57 and then add and subtract 2 times 1.358. This gives you a range of usual values of -1.146 to 4.286 approx.

  • @cc00nneerr
    @cc00nneerr 9 лет назад +5

    x squid

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

    God bless you friend

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

    009rud, Could you explain how to compute the median value of this data? Tkns! f.e.: I computed the cum. freq. and then I use FIND(50, cum.freq column, x column)

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

      This is a probability distribution and not really a set of data. However suppose the probabilities were calculated from 100 cars, then we would have 29 cars with no defective tires, 24 cars with 1 defective tires and so on. thus we list 0,0,0, 29 times 1 24 times and so on. Median is the 50th percentile and so the 50th we list would be 2.
      However in this set of data median does not have much meaning since only 5 discrete values of x are present. That is why we get the expected value or mean instead.