{"id":21414,"date":"2017-02-02T16:11:54","date_gmt":"2017-02-02T08:11:54","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=21414"},"modified":"2018-11-06T09:01:54","modified_gmt":"2018-11-06T01:01:54","slug":"reading-a-box-plot","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/using-the-page-controls\/reading-a-box-plot\/","title":{"rendered":"Reading a Box Plot"},"content":{"rendered":"\n

Overview<\/h2>\n

The Box Plot (sometimes known as the Box and Whiskers Plot) is used to show the distribution of a set of data, using a Median and Quartiles.<\/p>\n\n\n\n\n
\"box1\"<\/a><\/td>\n\"box2\"<\/a><\/td>\n\"box3\"<\/a><\/td>\n<\/tr>\n
The lines at the top and bottom represent Post Q and Pre Q respectively. The grey box represents the distribution between Q1 (bottom) and Q3 (top), with the median line and value shown in the centre of the box.<\/em><\/td>\nHover over the box plot to see actual values.<\/em><\/td>\nThis box plot is configured to show the minimum and maximum values (used for scalability).<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

If several box plots are grouped together, using the same scale, the relative distribution patterns between similar sets of data becomes clear. Note<\/strong>: The box plot on the left has been configured to show a scale between the minimum and maximum display values.<\/p>\n

\"box6\"<\/a><\/p>\n

The box plot can be horizontal (as shown above) or vertical (as shown below), depending on its configuration:<\/p>\n

\"box7\"<\/a><\/p>\n

 <\/p>\n

\n

Reading the Box Plot<\/h2>\n

Hover over the box plot to see values shown in the tooltip, as described below.<\/p>\n

Note: <\/strong>Only some of the tooltip values are displayed on the box plot.<\/p>\n

Box Plot Values<\/h3>\n

Some of the box plot values are visualised in the size of the rectangle, and the spaces between the different lines. Actual values are also listed in the tooltip.<\/p>\n\n\n\n
<\/a><\/td>\n\n\n\n\n\n\n\n\n\n\n\n\n
Max<\/strong><\/td>\nThe maximum value in the full data range (this is not shown in the Box Plot)<\/td>\n<\/tr>\n
Post Q<\/strong><\/td>\nThis is known as a 'whisker', and is the value of the last data point before any 'high-end' outliers (marked by line at Point 1<\/strong> on the Box Plot screenshot)<\/td>\n<\/tr>\n
Q3<\/strong><\/td>\nThird quartile (marked by line at point 2<\/strong> on the Box Plot screenshot)<\/td>\n<\/tr>\n
Med<\/strong><\/td>\nMedian value of the data range (marked by line at point 3<\/strong> on the Box Plot screenshot). On the Box Plot, this value is displayed below the Median line.<\/td>\n<\/tr>\n
Q1<\/strong><\/td>\nFirst quartile (marked by line at point 4<\/strong> on the Box Plot screenshot)<\/td>\n<\/tr>\n
Pre Q<\/strong><\/td>\nThis is known as a 'whisker', and is the value of the first data point after any 'low-end' outliers (marked by line at point 5<\/strong> on the Box Plot screenshot)<\/td>\n<\/tr>\n
Min<\/strong><\/td>\nMinimum value in the full data range (this is not shown in the Box Plot)<\/td>\n<\/tr>\n
 <\/td>\n <\/td>\n<\/tr>\n
 <\/td>\nThe grey box marks the Interquartile Range<\/em>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Calculations<\/h3>\n

The Box Plot data is numerical. Data is sorted from smallest to largest, to calculate the statistics represented by the box plot.<\/p>\n\n\n\n\n\n\n\n
Median<\/strong><\/td>\nThe median is the value in the middle of the sorted data. If there are two middle values (from an even number of data points), the median is the average of those two middle numbers.<\/td>\n<\/tr>\n
Q1<\/strong><\/td>\nThe set of numbers below<\/em> the median is used to calculate Q1. Q1 is the value in the middle of this set. If there are two middle values (from an even number of data points), Q1 is the average of those two middle numbers.<\/td>\n<\/tr>\n
Q2<\/strong><\/td>\nThe set of numbers above<\/em> the median is used to calculate Q3. Q3 is the value in the middle of this set. If there are two middle values (from an even number of data points), Q3 is the average of those two middle numbers.<\/td>\n<\/tr>\n
Interquartile Range<\/strong><\/td>\nThis is the range between Q1 and Q3 (the value is Q3 - Q1).<\/td>\n<\/tr>\n
Outlier<\/strong><\/td>\nAn outlier is any data point that is at least 1.5 times the interquartile range, beyond either Q1 or Q3. So an outlier can be any data point greater than (Q3 - Q1) * 1.5 + Q3, or any data point less than Q1 - (Q3 - Q1) * 1.5.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example 1<\/h4>\n

Here is an example of data and how it is represented in the box plot.<\/p>\n

A set of numerical data is retrieved from a dataset query, or list of fixed or variable values within Explorer. For example, the number of truckloads delivered within a single day, at a given site, is displayed in a box plot:<\/p>\n

<\/a><\/p>\n

This is how the data is processed to give the key values:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Unsorted Data<\/strong><\/td>\nUnsorted data from the database<\/td>\n<\/a><\/td>\n<\/tr>\n
Sorted Data<\/strong><\/td>\nThis is how the data looks, sorted<\/td>\n<\/a><\/td>\n<\/tr>\n
Max<\/strong><\/td>\nThe maximum value, in the sorted set.<\/td>\n<\/a><\/td>\n<\/tr>\n
Post Q<\/strong><\/td>\nThe value of the highest data point before any 'high-end' outliers.<\/td>\n<\/a><\/td>\n<\/tr>\n
Q3<\/strong><\/td>\nThe middle of the upper half of data, in the sorted set<\/td>\n<\/a><\/td>\n<\/tr>\n
Med<\/strong><\/td>\nThe median is calculated as the average of the two middle values = 27<\/td>\n<\/a><\/td>\n<\/tr>\n
Q1<\/strong><\/td>\nThe middle value of the lower half of data, in the sorted set<\/td>\n<\/a><\/td>\n<\/tr>\n
Pre Q<\/strong><\/td>\nThe value of the first data point after any 'low-end' outliers.<\/td>\n<\/a><\/td>\n<\/tr>\n
Min<\/strong><\/td>\nThe minimum value in the sorted set<\/td>\n<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example 2<\/h4>\n

Here is an example of data with outliers.<\/p>\n

The same set of data from the above example now has two extra pieces of data: 99 and -50. These values are the max and min, respectively, but are also outliers (each one is more than 1.5 times\u00a0the interquartile range - \u00a0from Q1 and Q3, respectively).<\/p>\n

In the box plot, 99 is shown as the Max, and -50 is shown as the Min. Post Q is still 39 (the value of the last data point before any 'high-end' outliers), while Pre Q is 19 (the value of the first data point after any 'low-end' outliers).<\/p>\n

<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The Box Plot component is used to show the distribution of a set of data, using a Median and Quartiles. Learn how to interpret the representation of data, and find out more about what values are displayed.<\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":8,"featured_media":23924,"parent":4254,"menu_order":21,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[528],"class_list":["post-21414","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-box-plot","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/21414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=21414"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/21414\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/4254"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/23924"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=21414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=21414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=21414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}