How To Find Quartiles and Construct a Boxplot in Excel

Поділитися
Вставка
  • Опубліковано 12 гру 2024

КОМЕНТАРІ • 36

  • @drrodrigoromanpena3742
    @drrodrigoromanpena3742 4 місяці тому

    Excellent video! Finally I found somebody who can explain how to do a box whisker manually. This is important because that is why you need to do if you want to make a box whisker using class data as it is my case. Thank you!

  • @TheMixingBowlHomestead
    @TheMixingBowlHomestead 4 роки тому

    Where have you been all my STAT200 life? Books make it so complicated and I have been crying my eyes out. Thank you... this is a huge help to help me understand how to calculate Min, Max, and interquartiles

  • @anggitawirahma
    @anggitawirahma 10 місяців тому +1

    Finally i found the long method to make bos whisker!!! Thank you!!!!!

  • @NewEdit617
    @NewEdit617 4 місяці тому

    Thank you! I could not get the built-in Box-And-Whiskers function to do what I wanted, but your video demonstrated perfectly how to create the type of graph I wanted.

    • @joshemman
      @joshemman  4 місяці тому

      Glad the old video still helps. Thanks for dropping a note.

    • @neelsrv
      @neelsrv 4 місяці тому +1

      @@joshemmanI am still referring your video ❤

    • @joshemman
      @joshemman  4 місяці тому

      @@neelsrv Thank you! 🙏

  • @marcjackson9571
    @marcjackson9571 2 роки тому +1

    You really know what you're doing!! Thank you!!

  • @brandonhowes5364
    @brandonhowes5364 4 роки тому

    Thanks, helped on one of my Statistics Assignments.

  • @trisahchristina1811
    @trisahchristina1811 Рік тому +1

    Hi what is the difference between inclusive and exclusive? Should I calculate percentiles using exclusive or inclusive?

  • @nurmaisarah1033
    @nurmaisarah1033 25 днів тому +1

    How can i make dash line at the median line?

    • @joshemman
      @joshemman  25 днів тому

      One way will be to overly the median with a dashed line. However, the approach shown in the video below allows for easier manipulation.
      ua-cam.com/video/BRAj_kZXRjg/v-deo.html

  • @bernicemain2647
    @bernicemain2647 7 років тому +3

    This was extremely helpful! Thank you very much ; )

  • @AJ-et3vf
    @AJ-et3vf Рік тому

    Great video. Thank you

  • @williama.rivera9414
    @williama.rivera9414 2 роки тому +2

    Good video and information Mr. Joshua, one question. I saw that the numbers or data set is not in ascending order; is not a matter in obtain the quartiles results? Thank you for teaching

    • @joshemman
      @joshemman  2 роки тому +2

      If you're doing manual calculations, the order matters. But with software, you don't have to bother. The software takes care of that.

    • @williama.rivera9414
      @williama.rivera9414 2 роки тому +1

      @@joshemman Thank you so much for answer.

  • @tashanipiyushani5348
    @tashanipiyushani5348 8 місяців тому +1

    It is very greatful to me

  • @deddywirata3719
    @deddywirata3719 4 роки тому

    Thanks, luckly excel understands our problem and they introduced the box plot feature in excel 2016

  • @cabrinieconstantine3597
    @cabrinieconstantine3597 Рік тому

    omg u saved me a bunch! thanks

  • @josephodoyo5981
    @josephodoyo5981 3 роки тому

    Very Helpful

  • @Joe-fi5kf
    @Joe-fi5kf 6 років тому

    Thanks man, this was very helpful!

  • @olygrl01
    @olygrl01 Рік тому

    Is there anyway to duplicate this in google sheets? The part I cant figure out is the error lines

    • @joshemman
      @joshemman  Рік тому

      I haven't tried it in Google Sheets but this video might help: ua-cam.com/video/5QgctkvP4Gs/v-deo.html

  • @Sulegibongtoo176
    @Sulegibongtoo176 3 роки тому

    what if you want to have 2 boxplots? when i go to put in the error bars it puts the same error bars on both boxplots as opposed to different ones on different boxes.

    • @joshemman
      @joshemman  3 роки тому

      Excel in Office 2019 now has a boxplot chart. Just highlight the two data sets, go to Insert and select the boxplot option (under histogram icon).

  • @karahrahmii2499
    @karahrahmii2499 5 років тому

    Cool and helpful, thanks

  • @Shubham.daliya
    @Shubham.daliya 7 років тому +2

    There is no plus option in new excel

    • @joshemman
      @joshemman  7 років тому

      Which Excel (year) are you referring to?

  • @HighAngel
    @HighAngel 2 роки тому

    Nice! THX man :)

  • @adiyabilguun5063
    @adiyabilguun5063 3 роки тому

    why calculate diff ? tell me pls

    • @joshemman
      @joshemman  3 роки тому +1

      It's a workaround.
      Excel now has the capability of creating a boxplot so you don't have to use this approach.

  • @abns4792
    @abns4792 2 роки тому

    Thnx

  • @khairolnajmi
    @khairolnajmi Рік тому

    I LITERALLY UNDERSTAND NOTHING!!!!!

    • @joshemman
      @joshemman  Рік тому

      Oh sorry😔. What exactly are you looking for?