How To... Calculate a z-Statistic in Excel 2010

Поделиться
HTML-код
  • Опубликовано: 8 сен 2024
  • Learn how to calculate a z-Score (One-Sample Z-Test) to test if a sample mean belongs to or represents a population mean in easy steps.

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

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

    I like all your videos Dr. Eugene.
    Best Regards.

  • @bredleemurray904
    @bredleemurray904 9 лет назад +1

    Thank you so much Eugene. You are so great.

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

    Great video. Very helpful !

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

    What about (NOT) 1.66683 > 2.330? It tells that the null hypothesis is okay with 99% confidence... or am I missing something?

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

    great thank you. But if am not wrong you should use t-test if st.deviation of population is not known or am I wrong?thank you for your replying

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

    Thank you very much

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

    Eugene is a god sent

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

    o gush, that was awesome, i trully loved your video is there more from you?

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

      Hi Ethernity THEA - thanks for your kind comment! You can check out some more at my channel - go to "RUclips dot com forward slash eugeneoloughlin" (URLs not allowed in comments)
      Dr E.

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

    There is a way to do this using an excel add in. I previously have done it that way but I cannot find a video online that elaborate on the use of the add in. Can any one help me?

  • @satyampachisia6961
    @satyampachisia6961 6 лет назад +1

    How can you do z test when sample size is less than 30

    • @crapshit12
      @crapshit12 6 лет назад +1

      Then you do a t-test.