{"id":4483,"date":"2016-01-16T11:17:36","date_gmt":"2016-01-16T10:17:36","guid":{"rendered":"http:\/\/www.saasoft.com\/blog\/?p=4483"},"modified":"2016-01-16T11:17:36","modified_gmt":"2016-01-16T10:17:36","slug":"hot-and-cold","status":"publish","type":"post","link":"https:\/\/hcse.blog\/?p=4483","title":{"rendered":"Hot and Cold"},"content":{"rendered":"<p><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/stick_figure_on_cloud_150_wht_9604.gif\" rel=\"attachment wp-att-4484\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-4484\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/stick_figure_on_cloud_150_wht_9604.gif\" alt=\"stick_figure_on_cloud_150_wht_9604\" width=\"150\" height=\"135\" \/><\/a>Last week Bob and Leslie were exploring the data analysis trap\u00a0called a\u00a0two-points-in-time comparison: as illustrated by the headline\u00a0&#8220;<em>This winter has not been as bad as last\u00a0&#8230; which proves that our winter action plan has worked.<\/em>&#8221;<\/p>\n<p><strong>Actually it doesn&#8217;t.<\/strong><\/p>\n<p>But just saying that is not very helpful. We need to explain the reason why this conclusion is invalid and therefore potentially dangerous.<\/p>\n<hr \/>\n<p style=\"text-align: left\">So here is the continuation of Bob and Leslie&#8217;s conversation.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> Hi Leslie, have you been reflecting on the two-points-in-time challenge?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em> Yes indeed, and\u00a0you were correct, I did\u00a0know the answer &#8230;\u00a0I just didn&#8217;t know I knew if you get my\u00a0drift.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> Yes, I do.\u00a0So, are you willing to share\u00a0your story?<\/p>\n<p style=\"text-align: left\">&lt;Leslie&gt; OK,\u00a0but before I do that I would like to share what happened when\u00a0I described what we talked about to some colleagues.\u00a0 They sort\u00a0of got the idea but\u00a0got lost in the\u00a0unfamiliar language of &#8216;variance&#8217; and I realized that I needed\u00a0an example to illustrate.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> Excellent &#8230; what example did you choose?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em> The UK weather &#8211; or more specifically the temperature.\u00a0 My reasons for choosing this\u00a0were many: first it is something that everyone can relate to; secondly it has strong seasonal cycle; and thirdly because\u00a0the data is readily available on the Internet.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> OK, so what\u00a0specific question were you trying to answer and what data did you\u00a0use?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em>\u00a0The question was &#8220;<em>Are our winters getting warmer?&#8221;<\/em>\u00a0and my\u00a0interest in that is because many people assume that the colder the winter the more people suffer from respiratory\u00a0illness and the more that\u00a0go to hospital &#8230; contributing to the winter A&amp;E and hospital pressures.\u00a0 The data that I used was the maximum monthly temperature from 1960 to the present\u00a0recorded at our closest weather station.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> OK, and what did you do with that data?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em>\u00a0Well, what I did <strong>not<\/strong> do was to compare this winter with last winter and draw my conclusion from that!\u00a0 What I did first was just to plot-the-dots\u00a0&#8230; I created a time-series chart &#8230; using the <a href=\"http:\/\/www.saasoft.com\/baseline\" target=\"_blank\" rel=\"noopener\">BaseLine\u00a9<\/a> software.<\/p>\n<p><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015.png\" rel=\"attachment wp-att-4486\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4486\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015.png\" alt=\"MaxMonthTemp1960-2015\" width=\"600\" height=\"182\" srcset=\"https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015.png 600w, https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015-300x91.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>And it shows what I expected to see, a\u00a0strong, regular, 12-month\u00a0cycle, with peaks in the summer and troughs in the winter.<\/p>\n<p><em>&lt;Bob&gt;<\/em> Can you explain what the green and red lines are and why some dots are red?<\/p>\n<p><em>&lt;Leslie&gt;<\/em> Sure. The green line is the average for all the data.\u00a0The red lines are called the upper and lower process limits.\u00a0\u00a0They are calculated from the data and what they say is &#8220;<em>if the variation in this data is random then we will expect more than 99% of the points to fall between these two red lines<\/em>&#8220;.<\/p>\n<p><em>&lt;Bob&gt;<\/em> So, we have 55 years of monthly data which is nearly 700 points which means we would expect fewer than seven to fall outside these lines &#8230; and we clearly have\u00a0many more than that.\u00a0 For example, the winter of 1962-63 and the summer of 1976 look exceptional &#8211; a run of three consecutive dots outside the red lines. So can\u00a0we conclude the\u00a0variation we are seeing is not random?<\/p>\n<p><em>&lt;Leslie&gt;<\/em> Yes,\u00a0and there is more evidence to\u00a0support that conclusion.\u00a0First is the reality check &#8230;\u00a0I do not\u00a0remember either of those exceptionally cold or hot years personally, so I asked Dr Google.<\/p>\n<p><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/BigFreeze_1963.jpg\" rel=\"attachment wp-att-4488\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-4488\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/BigFreeze_1963.jpg\" alt=\"BigFreeze_1963\" width=\"250\" height=\"180\" \/><\/a>This picture from January 1963\u00a0shows copper telephone lines that are\u00a0so weighed down with ice, and for so\u00a0long,\u00a0that they have stretched down to the ground.\u00a0 In this era of mobile phones we forget this was what telecommunication was like!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/HeatWave_1976.jpg\" rel=\"attachment wp-att-4489\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-4489 size-medium\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/HeatWave_1976-300x197.jpg\" alt=\"HeatWave_1976\" width=\"300\" height=\"197\" srcset=\"https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/HeatWave_1976-300x197.jpg 300w, https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/HeatWave_1976.jpg 429w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: left\">And just look at the young Michal Fish in the Summer of &#8217;76! Did people really wear clothes like that?<\/p>\n<p style=\"text-align: left\">And there is more evidence on the chart.\u00a0The red dots that you mentioned are\u00a0indicators\u00a0that BaseLine\u00a9\u00a0has detected other non-random patterns.<\/p>\n<p style=\"text-align: left\">So the large number of red dots confirms our Mark I Eyeball conclusion &#8230;\u00a0that there are signals mixed up with the noise.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt; <\/em>Actually, I do remember the Summer of &#8217;76 &#8211; it was the year I did my O Levels!\u00a0 And your <em>signals-in-the-noise<\/em> phrase\u00a0reminds me of\u00a0SETI &#8211;\u00a0the search for extra-terrestrial intelligence!\u00a0 I really enjoyed the 1997 film of Carl Sagan&#8217;s book\u00a0<em>Contact<\/em> with Jodi Foster playing the role of the determined scientist who ends up taking a faster-than-light trip through space in a machine designed by\u00a0ET and built by humans. And especially the line about 10 minutes from the end when those-in-high-places who had discounted her story\u00a0as &#8220;unbelievable&#8221; realized\u00a0they may have made an error &#8230; the line\u00a0<em>&#8216;Yes, that is interesting isn&#8217;t it&#8217;<\/em>.<\/p>\n<p><iframe loading=\"lazy\" title=\"&quot;Contact&quot; Theatrical Trailer (1997)\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/SRoj3jK37Vc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em> Ha ha! Yes. I enjoyed that film too. It had lots of great characters &#8211;\u00a0her glory seeking boss; the\u00a0hyper-suspicious head of national security who <em>militarized<\/em> the project; the charismatic anti-hero; the\u00a0ranting radical who blew up the first alien machine; and\u00a0John Hurt as\u00a0her guardian angel.\u00a0I must watch it again.<\/p>\n<p style=\"text-align: left\">Anyway, back to the story. The problem we have here is that this\u00a0type of time-series chart is not\u00a0designed to extract the overwhelming cyclical, annual pattern so that we can search for any weaker signals &#8230; such as a smaller change in winter temperature over a longer period of time.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em>Yes, that is indeed the problem with these statistical process control charts.\u00a0 SPC charts were designed over 60 years ago for process\u00a0quality assurance in manufacturing not as a diagnostic tool in a complex adaptive system\u00a0such a\u00a0healthcare.\u00a0So how did you solve the problem?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;\u00a0<\/em>I realized that it was the regularity of \u00a0the cyclical pattern that was the key.\u00a0 I realized that I could use that to separate out the annual cycle and to expose the weaker signals.\u00a0 I did that using the <strong>rational grouping<\/strong> feature of BaseLine\u00a9\u00a0with the month-of-the-year as the group.<\/p>\n<p><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015_ByMonth.png\" rel=\"attachment wp-att-4487\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4487\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015_ByMonth.png\" alt=\"MaxMonthTemp1960-2015_ByMonth\" width=\"600\" height=\"182\" srcset=\"https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015_ByMonth.png 600w, https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxMonthTemp1960-2015_ByMonth-300x91.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p style=\"text-align: left\">Now I realize why the designers of the software put this feature\u00a0in! With just one mouse click the\u00a0story jumped out of the screen!<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> OK. So can you explain what we are looking at here?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em> Sure. This chart shows the same data as before except that I asked BaseLine\u00a9\u00a0first to\u00a0group the data by month and then to create a mini-chart for each month-group independently.\u00a0 Each group has its own average and process limits.\u00a0 So if we look at the pattern of the\u00a0averages, the green lines, we can clearly see the annual cycle.\u00a0 What is very obvious now is that the process limits for each sub-group are much narrower, and that there are now very few red points\u00a0 &#8230; other than in the groups that are coloured red anyway &#8230; a niggle that the designers need to nail in my opinion!<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> I will pass on your improvement suggestion! So are you saying that the regular annual cycle has accounted for the majority of the <em>signal<\/em> in the previous chart and that now we have extracted that signal we can look for\u00a0weaker signals by looking for red flags in each monthly group?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt; <\/em>Exactly so.\u00a0 And the groups I am most interested in\u00a0are the November to March ones.\u00a0 So, next I filtered out the November data and plotted it as a separate chart; and I then used another cool feature of\u00a0BaseLine\u00a9 called <strong>limit locking<\/strong>.<\/p>\n<p><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxTempNov1960-2015_LockedLimits.png\" rel=\"attachment wp-att-4490\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4490\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxTempNov1960-2015_LockedLimits.png\" alt=\"MaxTempNov1960-2015_LockedLimits\" width=\"513\" height=\"331\" srcset=\"https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxTempNov1960-2015_LockedLimits.png 513w, https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxTempNov1960-2015_LockedLimits-300x194.png 300w\" sizes=\"auto, (max-width: 513px) 100vw, 513px\" \/><\/a><\/p>\n<p style=\"text-align: left\">What that means is that I have used the November maximum temperature data for the first 30 years to get the baseline average and natural process limits &#8230; and we can see that there\u00a0are no red flags in that section, no obvious signals.\u00a0\u00a0Then I locked these\u00a0limits at 1990 and\u00a0this tells BaseLine\u00a9 to compare the\u00a0subsequent\u00a025 years of data against\u00a0these projected limits.\u00a0 That\u00a0exposed a lot of signal flags, and we can clearly see that most of the points in the later section are above the projected average from the earlier one.\u00a0\u00a0This confirms that there has been a significant increase in November maximum temperature over this 55 year period.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em>\u00a0Excellent! You have answered part of your question. So what about December onwards?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em>\u00a0I was on a roll now! I also noticed from my second chart that the December, January and February groups looked rather similar so I filtered that data out and plotted them as a separate chart.<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4491\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015_Grouped.png\" alt=\"MaxTempDecJanFeb1960-2015_Grouped\" width=\"630\" height=\"388\" srcset=\"https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015_Grouped.png 630w, https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015_Grouped-300x185.png 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/>These were indeed almost identical so I lumped them together\u00a0as a &#8216;winter&#8217; group\u00a0and compared the earlier half with the later half using another BaseLine\u00a9 feature called <strong>segmentation<\/strong>.<\/p>\n<p style=\"text-align: left\"><a href=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015-Split.png\" rel=\"attachment wp-att-4492\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4492\" src=\"http:\/\/www.improvementscience.co.uk\/blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015-Split.png\" alt=\"MaxTempDecJanFeb1960-2015-Split\" width=\"630\" height=\"388\" srcset=\"https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015-Split.png 630w, https:\/\/hcse.blog\/wp-content\/uploads\/2016\/01\/MaxTempDecJanFeb1960-2015-Split-300x185.png 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a>This showed that the more recent winter months\u00a0have\u00a0a higher maximum temperature &#8230;\u00a0on average. The difference is just over one degree Celsius. But it also shows that that the month-to-month and year-to-year variation still dominates the picture.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> Which implies?<\/p>\n<p style=\"text-align: left\"><em>&lt;Leslie&gt;<\/em> That, with data like this, a two-points-in-time comparison is meaningless.\u00a0 If we do that we are just sampling random noise and there is no useful information in noise. Nothing that\u00a0we can\u00a0 learn from. Nothing that we can justify a decision with.\u00a0 This is\u00a0the\u00a0reason the <em>&#8216;this year was better than last year&#8217;<\/em> statement is meaningless at best; and dangerous at worst.\u00a0 Dangerous because if we draw an invalid conclusion, then it can lead us\u00a0to make an unwise decision, then decide a counter-productive action, and then deliver an unintended outcome.<\/p>\n<p style=\"text-align: left\">By doing invalid two-point comparisons we can too easily make the problem worse &#8230; not better.<\/p>\n<p style=\"text-align: left\"><em>&lt;Bob&gt;<\/em> Yes. This is what <a href=\"https:\/\/en.wikipedia.org\/wiki\/W._Edwards_Deming\" target=\"_blank\" rel=\"noopener\">W. Edwards Deming<\/a>, an early\u00a0guru of improvement science, referred to as &#8216;<strong>tampering<\/strong>&#8216;.\u00a0 He was a student of <a href=\"https:\/\/en.wikipedia.org\/wiki\/Walter_A._Shewhart\" target=\"_blank\" rel=\"noopener\">Walter A. Shewhart<\/a> who recognized this problem in manufacturing and, in 1924,\u00a0invented the first control chart to highlight it, and so prevent it.\u00a0\u00a0My grandmother used the term <strong>meddling <\/strong>to describe this same behavior &#8230; and I now use that term as one of the <em>eight sources of variation<\/em>. Well done Leslie!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last week Bob and Leslie were exploring the data analysis trap\u00a0called a\u00a0two-points-in-time comparison: as illustrated by the headline\u00a0&#8220;This winter has not been as bad as last\u00a0&#8230; which proves that our winter action plan has worked.&#8221; Actually it doesn&#8217;t. But just saying that is not very helpful. We need to explain the reason why this conclusion &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/hcse.blog\/?p=4483\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Hot and Cold&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,17,25,26,42,43,45,46],"tags":[],"class_list":["post-4483","post","type-post","status-publish","format-standard","hentry","category-baseline","category-bobles","category-examples","category-information","category-isp","category-how","category-why","category-what","category-teach"],"_links":{"self":[{"href":"https:\/\/hcse.blog\/index.php?rest_route=\/wp\/v2\/posts\/4483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hcse.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hcse.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hcse.blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hcse.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4483"}],"version-history":[{"count":0,"href":"https:\/\/hcse.blog\/index.php?rest_route=\/wp\/v2\/posts\/4483\/revisions"}],"wp:attachment":[{"href":"https:\/\/hcse.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hcse.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hcse.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}