Box and Whisker Plot Using Excel 2016

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

КОМЕНТАРІ • 58

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

    Used your method of doing a box and whisker in my recent publication (In press). Thank you, this method rocks!

  • @StoleYourSnowman
    @StoleYourSnowman 4 роки тому +8

    I referenced you in my research paper because I wouldn't have gotten the right graphic representation without this 😄 thanks

  • @rogzcorpuz
    @rogzcorpuz 3 роки тому +2

    Thanks, Maggie. This is what I need for my presentation next week.

  • @figenozcan7536
    @figenozcan7536 6 років тому +4

    thank you for making it manual rather than just selecting "Box and Whisker Chart" option. By this way, I was be able to prepare it in Excel 2010.

  • @laurynp9886
    @laurynp9886 5 років тому +2

    This is a very helpful video, especially since the version of excel I am using is older and does not have the box and whisker function. Thank you!

  • @adrianpardoblacutt5249
    @adrianpardoblacutt5249 4 роки тому +1

    Glad I found you! I was searching for this all day... you're amazing! Thank you!

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

    Thank you so much. I have been trying to figure this out for a week!

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

    Hi I'm having an issue at 2min 50sec. After you highlight, how do you command? I'm not sure if its a Mac issue but I can't seem to complete this part of the tutorial. Any help would be appreciated as this tutorial has been amazing so far.

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

    This is such a cool way of doing it! Very effective!

  • @Bijlxmsth
    @Bijlxmsth 4 роки тому +2

    Thank you so much, you made it really simple and it was really easy to learn.

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

    Very easy and simple explanation excellent thank you

  • @muhdnurhilmibinhermanto5273
    @muhdnurhilmibinhermanto5273 5 років тому +3

    Thank you very much....it's really help me as a student

  • @BDQUERY350
    @BDQUERY350 4 роки тому +1

    thk u so much!! I love uuu , greetings from Peru! (south america)

  • @richieg.3192
    @richieg.3192 4 роки тому

    Having trouble scaling the axis did you ever figure it out or post a video about it?

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

    Thanks Meggie, great work! cheers from Italy

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

    Very helpful, thank you!

  • @jasminenava1520
    @jasminenava1520 4 роки тому +2

    What is the hit the "Command" button to keep cells active?

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

    Lifesaver! But, how do I make Sample 1 and Sample 2 different colours? It only allows me to change the colours of Boxes 1 and 2, but I want to compare a test to a control and would like them to be different colours.

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

    Thank you! So easy to follow.

  • @cake_baker
    @cake_baker 6 років тому +1

    Thank you, you made it very easy to follow

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

    Ms Maggie, why you do it this way, and not using the default Whiskers and plot that excel shows? By selecting the data you want and create the plot?
    Thank you

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

      When you make it by hand you have more control over the final results. When you select the default, it doesn't look as good and you can't make as many changes to the appearance.

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

    Such a lifesaver, thank you so much ;;;;;;;;;;

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

    Thank you miss you save the day

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

    thanks this made me not hate math as much.

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

    I have Negative whisker not touching Box 2, there was a gap, what could be the reason,? My data have (+) and (-) values

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

    Thank you loads for the video! I much rather do it manually from now on!

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

    the online version of 365 is extremely limited and doesnt even have the "Chart Design" tab needed to make the box plot. Great video tho

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

    THANK YOU SO MUCH SO THIS VIEDO !!!!!HELPS ME A LOT=)

  • @johnmlendvay7021
    @johnmlendvay7021 5 років тому +1

    Hello, Hello, Maggie! This was wonderful and I might add refreshing and bit hilarious!

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

      i realize Im kinda off topic but do anyone know of a good website to stream newly released series online?

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

      @Valentino Noah i use FlixZone. Just search on google for it :)

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

      @Matthew Zachariah Yup, I have been using flixzone for since april myself :D

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

      @Matthew Zachariah Thank you, signed up and it seems to work =) I really appreciate it!

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

      @Valentino Noah You are welcome =)

  • @InDiGoMeStYlE
    @InDiGoMeStYlE 6 років тому +3

    WOW MAGGIE WOW THANK YOU FOR EXISTING

  • @arigunawan4314
    @arigunawan4314 6 років тому

    Thank you.. the best tutorial

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

    This was very helpful, thank you :)

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

    It is now available as one of the charts.Just update your version.

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

    FANTASTIC!

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

    HI Maggie, thank you for sharing this video it is extremely helpful! I was wondering if it would be possible to plot a set of points on the whisker plot so that someone could highly the data compared to the box plot. Example if you wanted to see the point 9.7 in sample 1 on the chart
    Thanks!

  • @sebooz4949
    @sebooz4949 5 років тому +2

    in some tutorials here in youtube, they tell differently, they make minimum is minimum but you calculated their differences, which one is true Im not sure now....:( Im confused, of course I see what you do but everybody does different

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

    Can we go directly to Box n whiskert chart option

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

      There is an automatic chart but these look nicer and have more options for changing the look.

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

    where is the "command" function she said in the video?

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

    Thank You Very much!!!

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

    you saved me

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

    what command she taking bout

    • @17Jahseh17
      @17Jahseh17 4 роки тому

      idfk

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

      The command button on your keyboard. I am not sure about other companies, but Apple laptops have one on the right and left side of the space bar.

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

    Thank you!

  • @a.fleischbender7681
    @a.fleischbender7681 6 років тому +1

    There is a Chart type called "Box and Whisker chart". You don't need to make it manually....

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

    This won’t show you outliers though.

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

    Idk whats going on here

  • @InDiGoMeStYlE
    @InDiGoMeStYlE 6 років тому

    WOW MAGGIE WOW THANK YOU FOR EXISTING

    • @InDiGoMeStYlE
      @InDiGoMeStYlE 6 років тому

      Wish there was an outlier example though

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

    thank you!