Calculating a Z-score in Excel

Sdílet
Vložit
  • čas přidán 6. 08. 2017
  • How to calculate a z-score in Excel

Komentáře • 22

  • @88spaces
    @88spaces Před 4 lety +7

    Thank you. You explained the z-score in the simplest way.

  • @AmbizarYT
    @AmbizarYT Před 4 lety +6

    Quick, clear, and to point. This was perfect, thank you. You've earned a like.

  • @dugudonz
    @dugudonz Před rokem

    This is the best instruction for calculating z-scores, thank you so much! My struggle is over :D

  • @traviswilliams9800
    @traviswilliams9800 Před 3 lety

    Thank you for this very easy/simple explanation of how to calculate Z-Scores. Now I can move on to calculating confidence intervals and so forth!

  • @lucagiacomella690
    @lucagiacomella690 Před 3 lety +3

    A very precise and detailed explanation. EXCEL-LENT😁!!

  • @lawrence2467
    @lawrence2467 Před 4 lety +1

    Thank you for making this tutorial!!!!!

  • @Dopebeautiful
    @Dopebeautiful Před 7 měsíci

    Great explanation thank you

  • @rozaimiz6076
    @rozaimiz6076 Před 3 lety +2

    Hi, what is the difference between z-score and z-score (excel)? And what is the purpose for doing that specifically?

  • @spritebeverage5993
    @spritebeverage5993 Před 4 lety +4

    finally found a decent tutorial thanks !!

  • @Sage-rw8oo
    @Sage-rw8oo Před 3 lety

    Thank you!!

  • @o1Lars
    @o1Lars Před 8 měsíci

    If i want to find the p value next, how would i go about it?

  • @blazelematu3626
    @blazelematu3626 Před 9 měsíci

    the only think I didn't get was how to do that copy trick! but Everything else was great

  • @charmikabrown9
    @charmikabrown9 Před rokem +2

    how do you lock the cells?

  • @akashwaghmare3957
    @akashwaghmare3957 Před 3 lety

    You have taken sample standard deviation but for z score we have to take population standard dev

    • @5eanalytics
      @5eanalytics  Před 3 lety +1

      Thanks for the comment. When the population mean and the population standard deviation are unknown, the standard score may be calculated using the sample mean (x̄) and sample standard deviation (s) as estimates of the population values.

  • @willminkorea2010
    @willminkorea2010 Před rokem

    Good info but, please, a little slower

    • @5eanalytics
      @5eanalytics  Před rokem

      Sorry! thank you for the feedback

    • @reynoldwestgate3832
      @reynoldwestgate3832 Před rokem

      you can just reduce the playback speed by clicking the cog for settings

  • @jokerc443
    @jokerc443 Před 10 měsíci

    schools 💀💀