Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule

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

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

  • @excelisfun
    @excelisfun  9 лет назад +10

    Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule
    Download files: people.highline.edu/mgirvin/excelisfun.htm
    Topics in this video:
    1. (00:09) Calculate z score. Z Score is the Number of Standard Deviations a particular value is away from the mean. Deviation divided by Standard Deviation formula or STANDARDIZE function.
    2. (08:15) Chebshev’s Rule: 5 Examples
    3. (14:03) Empirical Rule: 12 Examples

  • @rodrigocustodio1955
    @rodrigocustodio1955 4 года назад +3

    Mike, you are the best teacher I had my life, Thank you so much for your youtube channel.

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

    These videos just got me an A on my take home test!!!! Thanks so much

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

    Yor are an excellent teacher, thank you very much for your time and effort.

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

    Thank for fantastic course.
    1 question: what happen with Z=1 in Chebshev’s rule (Proportions is 0 and how we can deal with that value?)

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

    very good effort

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

    Fantastic!

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

    These training are awesome! Where can we see how to create the height bellcurve chart that we see @18:00. I downloaded the excel but do you have a video showing how to create (this chart is different than your 2009 normal probabilistic charts)

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

    I need not only learn the excel tricks, but also review back some statistic knowledge to catch up [・ヘ・?]

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

      This is one of my better stats videos, if you want to know the hows and the WHYS : )

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

    Thanks

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

      You are welcome, clifford!!!! : )

  • @popinigis
    @popinigis 8 лет назад +1

    things are getting hot and hotter! wow!!