Тёмный

How To Find Quartiles and Construct a Boxplot in Excel 

Joshua Emmanuel
Подписаться 136 тыс.
Просмотров 87 тыс.
50% 1

Опубликовано:

 

28 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@drrodrigoromanpena3742
@drrodrigoromanpena3742 3 месяца назад
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 3 года назад
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
@NewEdit617
@NewEdit617 3 месяца назад
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 3 месяца назад
Glad the old video still helps. Thanks for dropping a note.
@neelsrv
@neelsrv 3 месяца назад
@@joshemmanI am still referring your video ❤
@joshemman
@joshemman 3 месяца назад
@@neelsrv Thank you! 🙏
@anggitawirahma
@anggitawirahma 9 месяцев назад
Finally i found the long method to make bos whisker!!! Thank you!!!!!
@marcjackson9571
@marcjackson9571 2 года назад
You really know what you're doing!! Thank you!!
@trisahchristina1811
@trisahchristina1811 11 месяцев назад
Hi what is the difference between inclusive and exclusive? Should I calculate percentiles using exclusive or inclusive?
@bernicemain2647
@bernicemain2647 7 лет назад
This was extremely helpful! Thank you very much ; )
@williama.rivera9414
@williama.rivera9414 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 года назад
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 года назад
@@joshemman Thank you so much for answer.
@AJ-et3vf
@AJ-et3vf Год назад
Great video. Thank you
@brandonhowes5364
@brandonhowes5364 4 года назад
Thanks, helped on one of my Statistics Assignments.
@tashanipiyushani5348
@tashanipiyushani5348 7 месяцев назад
It is very greatful to me
@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!
@deddywirata3719
@deddywirata3719 4 года назад
Thanks, luckly excel understands our problem and they introduced the box plot feature in excel 2016
@karahrahmii2499
@karahrahmii2499 5 лет назад
Cool and helpful, thanks
@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5QgctkvP4Gs.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).
@HighAngel
@HighAngel 2 года назад
Nice! THX man :)
@abns4792
@abns4792 2 года назад
Thnx
@Shubham.daliya
@Shubham.daliya 7 лет назад
There is no plus option in new excel
@joshemman
@joshemman 7 лет назад
Which Excel (year) are you referring to?
@adiyabilguun5063
@adiyabilguun5063 3 года назад
why calculate diff ? tell me pls
@joshemman
@joshemman 3 года назад
It's a workaround. Excel now has the capability of creating a boxplot so you don't have to use this approach.
@khairolnajmi
@khairolnajmi Год назад
I LITERALLY UNDERSTAND NOTHING!!!!!
@joshemman
@joshemman Год назад
Oh sorry😔. What exactly are you looking for?
Далее
How To Create A Box Plot In Excel (Including Outliers)
8:01
Creating A Boxplot Using Excel (Short Version)
9:00
Просмотров 129 тыс.
skibidi toilet 77 (part 4)
05:20
Просмотров 15 млн
Quartiles, Boxplots, Outliers
11:15
Просмотров 175 тыс.
quartiles in excel
2:54
Просмотров 59 тыс.
How To Make Box and Whisker Plots
13:56
Просмотров 1,3 млн
Membuat Boxplot dengan Excel
8:23
Просмотров 47 тыс.
skibidi toilet 77 (part 4)
05:20
Просмотров 15 млн