Using MS Excel Instead of a Standard Normal Distrib Table

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

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

  • @PedroAugusto-yu8yc
    @PedroAugusto-yu8yc Год назад

    This video from 11 years ago just saved me today. Thanks

  • @davidmckee533
    @davidmckee533 2 месяца назад

    wow struggled until i found this channel

  • @1924Badmonkey
    @1924Badmonkey 6 лет назад

    I’m taking stats in grad school, and find it just as challenging as I did in junior college. This video will save me a lot of heartache. Thank you so much!

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

    THank you so much this is the most helpful video I've seen so far!

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

    OMG !!! I have been spinning my wheels for 4 hours trying to figure this out in EXCEL till I saw your video. THANK YOU !!!!

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

    I want to thank you so much. I have woke up with headaches from dreaming of not been able to get my homework done on time. I was doing this by hand. smh THANK YOU!!!!

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

    Thank you!!!! I like using excel way more than doing the formulas... way less complicated!!!

  • @deelee9936
    @deelee9936 9 лет назад +6

    YOU'RE MY HERO!

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

    Great vid. Created, saved and using this handy file.

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

    Thank you this extremely helpful for my statistics class.

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

    When to use distribution inverse and other exel function on this lesson?

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

    tyvm this is so helpful now I can finish all these problems in a short time.

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

    Just what I was looking for. Thanks!!

  • @alisabanci48
    @alisabanci48 10 лет назад +2

    is there any way we can find value of the z that lies to the right or left of z, using Excel?

  • @mayrajloredo87
    @mayrajloredo87 7 месяцев назад

    Ugh wish I found this before the end of semester :(

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

    Is there a way to do the opposite? If I know the area I am concerned with is .45 of the total, how can I get Excel to tell me the associated z-value is 1.645?

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

      I think it has something to do with the NORMSINV function. looking around right now to see if I can do anything with that

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

    I would like to find out how to work it out back using excel. Let us say I have the value of normsdist and I would like to know the value

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

    this is dope!!!! thank you. Now i wann make a full table how would do that?

  • @ACTIVATECNOLOGIA-wp9xf
    @ACTIVATECNOLOGIA-wp9xf 4 года назад

    Man!!! you are a such a bad-ass! Thank you very much! você é muuuito sinistro!

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

    GREAT VIDEO!!!!!!!

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

    i followed the directions to a T and it says i entered to few arguments

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

    Thank you sir🙏🙏

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

    which excel is using here??

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

    Thank youuuu!

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

    So how do I get z without looking at a table?

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

    Excellent! Like bvbull200, I'd like to know if it can be done in reverse? Knowing the area to find the z-score? Great video and it really helps for those who don't have the calculator and only Excel.

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

    beautiful!

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

    Thank you!

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

    Or Normalcdf on the calc

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

    Thanks a lot

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

    Great!!!

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

    Doesn't work for shaded to the right. This link gives you the correct values: www.statisticshowto.datasciencecentral.com/tables/z-table/

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

    OH THANK GOD

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

    TO LONG, TOO MUCH TALKING, GET TO THE POINT!!!!!!!!!!!!!!! YOU'RE KILLING ME!!!!!!

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

    Thank you!