Create and correctly interpret boxplots in Excel 2016 - Visualize data in Excel (26)
// Create and correctly interpret a box plot in Excel 2016 //
Generally, a box plot graphically displays several different location and dispersion measures in one chart.
Note:
=======
This video shows how to create one for Excel 2016. For older versions, please use the videos in this playlist:
🎞 https://www.youtube.com/playlist?list...
The box is the so-called interquartile range (measure of dispersion) and represents the range spanned by the third quartile minus the first quartile. The median is located in the center of the box. The antennae typically represent the minimum and maximum values of a distribution, unless they are outliers. In this video, I show what outliers are, how to identify them, and how the box plot handles them.
Boxplots provide a very compact graphical representation of a distribution and its most important parameters.
If you have any questions or suggestions about creating and correctly interpreting boxplots in Excel 2016, please use the comments section. You can indicate whether you found the video helpful by giving it a thumbs up or down. #statistikampc
Read more on my homepage:
========================================
💡Interpreting a boxplot (illustrated):
https://www.bjoernwalther.com/boxplot...
⭐Become a channel member⭐:
=======================
/ @statistikampc_bjoernwalther
Timestamp ⏰
============
0:00 Introduction
0:18 Boxplot - Introduction
0:33 Creating a boxplot
1:08 Boxplot structure
1:48 Adjusting the boxplot quartile calculation
2:15 Calculating the boxplot location parameter - Minimum
2:36 Calculating the boxplot location parameter - Maximum
2:43 Calculating the boxplot location parameter - 1st quartile
3:09 Calculating the boxplot location parameter - Median
3:15 Calculating the boxplot location parameter - 3rd quartile
3:50 Reading the boxplot location parameter in the boxplot - Median
4:01 Reading the boxplot location parameter in the boxplot - 1st and 3rd quartile
4:15 Reading the boxplot dispersion parameter in the boxplot - Interquartile range
4:48 Interquartile range for finding outliers
6:08 Calculating the upper outlier limit
6:38 Calculating the lower outlier limit
7:36 Example cases for outliers
8:36 Interpreting antennae (whiskers) in the boxplot
Support channel? 🙌🏼
====================
Paypal donation: https://www.paypal.com/paypalme/Bjoer...
Amazon affiliate link: http://amzn.to/2iBFeG9
Thank you for your support! ♥
Thank you for your support!