Using MS Excel Instead of a Standard Normal Distrib Table

How to create a MS Excel spreadsheet to determine the area (probability) under the normal curve instead of a table. Given a z-score, this shows how to find the prob shaded to the left of the z-score, shaded to the right of the z-score, and shaded in between two z-scores. It uses the Excel formula called "Normsdist()".

Пікірлер: 36

  • @PedroAugusto-yu8yc
    @PedroAugusto-yu8yc Жыл бұрын

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

  • @1924Badmonkey
    @1924Badmonkey5 жыл бұрын

    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!

  • @Rachelsc26
    @Rachelsc266 жыл бұрын

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

  • @markhartevelt
    @markhartevelt9 жыл бұрын

    Just what I was looking for. Thanks!!

  • @brees4me
    @brees4me9 жыл бұрын

    Thank you this extremely helpful for my statistics class.

  • @keishasoto23
    @keishasoto238 жыл бұрын

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

  • @addiferr
    @addiferr3 жыл бұрын

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

  • @marthaowens9245
    @marthaowens92455 жыл бұрын

    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!!!!

  • @deelee9936
    @deelee99369 жыл бұрын

    YOU'RE MY HERO!

  • @ronglass5968
    @ronglass59684 жыл бұрын

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

  • @marissamendoza1480
    @marissamendoza14805 жыл бұрын

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

  • @healy178
    @healy1789 жыл бұрын

    GREAT VIDEO!!!!!!!

  • @Gamerssassin
    @Gamerssassin3 жыл бұрын

    Thank you!

  • @limitlessmysteries269
    @limitlessmysteries2692 жыл бұрын

    Thank you sir🙏🙏

  • @ianlorber2438
    @ianlorber24384 жыл бұрын

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

  • @daniel3897
    @daniel38979 жыл бұрын

    beautiful!

  • @alisabanci48
    @alisabanci489 жыл бұрын

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

  • @mmartian66
    @mmartian664 жыл бұрын

    Thank youuuu!

  • @mayrajloredo87
    @mayrajloredo872 ай бұрын

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

  • @markstark9572
    @markstark95727 жыл бұрын

    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.

  • @ratoor1
    @ratoor110 жыл бұрын

    Thanks a lot

  • @ACTIVATECNOLOGIA-wp9xf
    @ACTIVATECNOLOGIA-wp9xf3 жыл бұрын

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

  • @thebeastandthewest5191
    @thebeastandthewest5191 Жыл бұрын

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

  • @kashfortheking
    @kashfortheking8 жыл бұрын

    Great!!!

  • @thepickle7047
    @thepickle70477 жыл бұрын

    Or Normalcdf on the calc

  • @bvbull200
    @bvbull2007 жыл бұрын

    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

    7 жыл бұрын

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

  • @TheMotoguse
    @TheMotoguse10 жыл бұрын

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

  • @jerrylamola911
    @jerrylamola9113 жыл бұрын

    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

  • @ntlkrr
    @ntlkrr5 жыл бұрын

    OH THANK GOD

  • @priyamsarker9355
    @priyamsarker93553 жыл бұрын

    which excel is using here??

  • @frankvalenti8350
    @frankvalenti83505 жыл бұрын

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

  • @EmeraldBayMovies
    @EmeraldBayMovies4 жыл бұрын

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

  • @garyhilson7220
    @garyhilson722010 жыл бұрын

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

  • @charlesshivnarain3099

    @charlesshivnarain3099

    9 жыл бұрын

    you know you can change the speed right?

  • @deborahfetene5641
    @deborahfetene56419 жыл бұрын

    Thank you!