{"id":2833,"date":"2024-01-09T12:00:00","date_gmt":"2024-01-09T11:00:00","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?p=2833"},"modified":"2024-01-09T11:52:16","modified_gmt":"2024-01-09T10:52:16","slug":"statistics-with-tableau-basics-part-ii","status":"publish","type":"post","link":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/","title":{"rendered":"Statistics with Tableau \u2013 Basics Part II"},"content":{"rendered":"\n

In the previous post \u201cStatistics with Tableau \u2013 the Basics<\/strong><\/a>\u201c, we discussed the essential statistical measures: average, median, minimum and maximum, quartiles, percentiles, and interquartile range. You learned how to adjust them on the charts using such Tableau functions as reference lines and how to apply them to the calculation fields. In this post, we will take one step forward and present more advanced statistical measures such as variance and standard deviation and will explain when to use them.<\/p>\n\n\n\n

Statistics with Tableau: measuring dispersion of values \u2013 variance<\/h2>\n\n\n\n

In addition to the basic statistical measures, for example, the average value of a specific situation, it is important to understand the variability. To illustrate this, let\u2019s look at the example from the previous post \u2013 the employees\u2019 salaries. This time we are going to compare the salaries in two departments that have the same average:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

As shown in the chart, despite the same average, the arrangement of the values significantly differs in both cases. For this reason, we are going to introduce variability, and more specifically: variance. It measures the deviation of the values from their average. The easiest way would be to take the differences for each point and sum up the resulting values:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

The problem is that when you sum up the differences of the salary and the average, you will always get zero, as some values will be above the average while other will fall below it. For this reason, the resulting difference is then squared to solve the problem of the opposite signs. By diving the resulting value by the number of observations, you will get the following variance:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

A more intuitive variability measure \u2013 standard deviation<\/h2>\n\n\n\n

To simplify the interpretation of the variance, which is expressed as the squared difference, the standard deviation function is often used, which is the square root of the variance:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

This makes the interpretation of the data a little easier: the average salary is 1590, and the deviation is 446. Let\u2019s take a look at the comparison of the two departments \u2013 where the average salary was identical in both cases:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

In this scenario, the standard deviation shows, in which case the variability of salaries is higher, and in which case it is lower. That was our intention.<\/p>\n\n\n\n

Statistics with Tableau \u2013 variability measurements as calculation fields and chart elements<\/h2>\n\n\n\n

In the above section, we manually calculated the variance and standard deviation, however, we can use the built-in statistic functions in Tableau to calculate these measures. These functions are:<\/p>\n\n\n\n

\u2013 VAR ([Measure]) \u2013variance of the sample, VARP ([Measure]) \u2013variance of the population<\/p>\n\n\n\n

\u2013 STDEV ([Measure]) \u2013standard deviation of the sample, STDEVP ([Measure]) \u2013standard deviation of the population<\/p>\n\n\n\n

The resulting measures can be used as calculation fields in the analysis:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

As Tableau is a visualization tool, these measures are depicted in the graphical format. Standard deviation can serve to show the distribution of data by applying the Distribution Band function from the Analytics tab:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

Select Distribution Band, next in the Value list choose: Standard Deviation (default +-1), click on Sample (when you have sample data) or Population (when you have all the data) and that\u2019s all you need to do:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

Grey areas show the ranges from the average minus the standard deviation to the average plus the standard deviation. You can clearly see in the chart, which dataset has higher variability.<\/p>\n\n\n\n

Statistics with Tableau \u2013 what to focus on when analysing variability<\/h2>\n\n\n\n

In the previous post, I pointed out that in the case of datasets with outliers, such measurements as the average may not be fully representative and thus distort the actual picture. The same applies to the standard deviation which is another classic measure. Let\u2019s take a look at the previous example with the salaries, but this time we will add a high salary to the x-employee:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

As you can see, the standard deviation went to the extreme. At this point saying that the average salary is 2355 +- 2456 doesn\u2019t mean much, taking into account that the salary cannot be a negative value. What to do in this case? The best would be to go to the position measures and look at the median instead of the average, and at the interquartile range instead of the standard deviation. As explained in the previous post, the median is the middle value, with the same number of smaller and larger data points. The interquartile range is the difference between the lower and the upper quartile, which covers 50% of the data. In Tableau, you can add visually the relevant range from the Analytics tab, by selecting Median with Quartiles:<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

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

The resulting outcome on the chart \u2013 it is much clearer now than the average\/standard deviation<\/p>\n\n\n\n

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

\"\"<\/a><\/figure>\n\n\n\n

 <\/h2>\n\n\n\n

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

Basic statistics are important<\/h2>\n\n\n\n

When beginning the analysis of data, it\u2019s good to start with the basic statistics. They will help build up the essential knowledge about the data and indicate the direction of analytics. However, you should bear in mind the limitations \u2013 for example, when it comes to the average, which is sensitive to outliers. If the average substantially differs from the median, you can expect significant outliers. In such a case, it is worthwhile to leave the classic measures and move to the position measures. Tableau will support you here both in terms of the calculations (by using in-built statistic functions) as well as the visual aspects (by using reference lines, distribution or box plots).<\/p>\n\n\n\n

Autor: Mateusz Karmalski Tableau Author<\/p>\n","protected":false},"excerpt":{"rendered":"

In the previous post \u201cStatistics with Tableau \u2013 the Basics\u201c, we discussed the essential statistical measures: average, median, minimum and maximum, quartiles, percentiles, and interquartile range. You learned how to adjust them on the charts using such Tableau functions as reference lines and how to apply them to the calculation fields. In this post, we […]<\/p>\n","protected":false},"author":5,"featured_media":2834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"content-sidebar","footnotes":""},"categories":[9,5],"tags":[],"class_list":{"0":"post-2833","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-blog","8":"category-tableau","9":"entry"},"yoast_head":"\nStatistics with Tableau \u2013 Basics Part II - NewDataLabs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Statistics with Tableau \u2013 Basics Part II - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"In the previous post \u201cStatistics with Tableau \u2013 the Basics\u201c, we discussed the essential statistical measures: average, median, minimum and maximum, quartiles, percentiles, and interquartile range. You learned how to adjust them on the charts using such Tableau functions as reference lines and how to apply them to the calculation fields. In this post, we […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-09T11:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gosia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gosia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\"},\"author\":{\"name\":\"Gosia\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\"},\"headline\":\"Statistics with Tableau \u2013 Basics Part II\",\"datePublished\":\"2024-01-09T11:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\"},\"wordCount\":904,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg\",\"articleSection\":[\"Blog\",\"Tableau\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\",\"url\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\",\"name\":\"Statistics with Tableau \u2013 Basics Part II - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg\",\"datePublished\":\"2024-01-09T11:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\"},\"breadcrumb\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage\",\"url\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg\",\"contentUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg\",\"width\":360,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/newdatalabs.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistics with Tableau \u2013 Basics Part II\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\",\"url\":\"https:\/\/newdatalabs.com\/en\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/newdatalabs.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\",\"name\":\"Gosia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g\",\"caption\":\"Gosia\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Statistics with Tableau \u2013 Basics Part II - NewDataLabs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/","og_locale":"en_US","og_type":"article","og_title":"Statistics with Tableau \u2013 Basics Part II - NewDataLabs","og_description":"In the previous post \u201cStatistics with Tableau \u2013 the Basics\u201c, we discussed the essential statistical measures: average, median, minimum and maximum, quartiles, percentiles, and interquartile range. You learned how to adjust them on the charts using such Tableau functions as reference lines and how to apply them to the calculation fields. In this post, we […]","og_url":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/","og_site_name":"NewDataLabs","article_published_time":"2024-01-09T11:00:00+00:00","og_image":[{"width":360,"height":216,"url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg","type":"image\/jpeg"}],"author":"Gosia","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gosia","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#article","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/"},"author":{"name":"Gosia","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7"},"headline":"Statistics with Tableau \u2013 Basics Part II","datePublished":"2024-01-09T11:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/"},"wordCount":904,"commentCount":0,"image":{"@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg","articleSection":["Blog","Tableau"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/","url":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/","name":"Statistics with Tableau \u2013 Basics Part II - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg","datePublished":"2024-01-09T11:00:00+00:00","author":{"@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7"},"breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#primaryimage","url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg","contentUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-09.01.24.jpg","width":360,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/statistics-with-tableau-basics-part-ii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Statistics with Tableau \u2013 Basics Part II"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7","name":"Gosia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g","caption":"Gosia"}}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/2833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=2833"}],"version-history":[{"count":1,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/2833\/revisions"}],"predecessor-version":[{"id":2846,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/2833\/revisions\/2846"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media\/2834"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=2833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/categories?post=2833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/tags?post=2833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}