{"id":2800,"date":"2020-04-11T09:24:31","date_gmt":"2020-04-11T15:24:31","guid":{"rendered":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/?p=2800"},"modified":"2022-08-24T10:42:49","modified_gmt":"2022-08-24T16:42:49","slug":"colorado-covid-19-cases-and-deaths-in-control-charts","status":"publish","type":"post","link":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/colorado-covid-19-cases-and-deaths-in-control-charts\/","title":{"rendered":"Colorado COVID-19 Cases and Deaths in Control Charts"},"content":{"rendered":"\r\n<p>While most COVID-19 charts show cumulative cases and deaths, I wondered what would happen if we turned the cumulative data into a daily data and plotted it as a control chart. It is possible to use c or XmR charts for this purpose. Process changes chosen based on runs and trends in the data.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2805\" src=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-1.jpg\" alt=\"co covid cases c chart\" width=\"822\" height=\"581\" srcset=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-1.jpg 822w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-1-300x212.jpg 300w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-1-768x543.jpg 768w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-1-115x81.jpg 115w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/p>\r\n<p>Daily new cases still unstable, but hovering around 339\/day. Cases began to rise 3\/18. Potentially leveling off 3\/26. the date of state &#8220;stay-at-home&#8221; order.<\/p>\r\n<p>\u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2801\" src=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart.jpg\" alt=\"co covid cases c chart\" width=\"822\" height=\"575\" srcset=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart.jpg 822w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-300x210.jpg 300w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-768x537.jpg 768w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-c-Chart-115x80.jpg 115w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/p>\r\n<p>Daily deaths still unstable, but hovering around 12\/day. Deaths began rising 3\/21, but appear to be stabilizing.\u00a0 Significant spike on 4\/2, root cause unknown. When there are eight points in a row above (bad) or below (good) the average daily deaths, it will signal a process shift.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2802\" src=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-XmR-Cases.jpg\" alt=\"co covid cases xmr chart\" width=\"794\" height=\"654\" srcset=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-XmR-Cases.jpg 794w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-XmR-Cases-300x247.jpg 300w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-XmR-Cases-768x633.jpg 768w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Cases-XmR-Cases-115x95.jpg 115w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/p>\r\n<p>XmR charts show similar results to c chart. The Range chart shows the variation from day to day.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2804\" src=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Deaths-by-Day-XmR-Chart.jpg\" alt=\"co covid deaths by day xmr chart\" width=\"784\" height=\"658\" srcset=\"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Deaths-by-Day-XmR-Chart.jpg 784w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Deaths-by-Day-XmR-Chart-300x252.jpg 300w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Deaths-by-Day-XmR-Chart-768x645.jpg 768w, https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-content\/uploads\/CO-COVID-19-Deaths-by-Day-XmR-Chart-115x97.jpg 115w\" sizes=\"auto, (max-width: 784px) 100vw, 784px\" \/><\/p>\r\n<p>These charts show that cases and deaths are stabilizing. A downward trend or run would be terrific. An upward trend or run means the countermeasures aren&#8217;t working.<\/p>\r\n<p>Note: Charts created with QI Macros for Excel using Colorado data.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>While most COVID-19 charts show cumulative cases and deaths, I wondered what would happen if we turned the cumulative data into a daily data and plotted it as a control chart. It is possible to use c or XmR charts for this purpose. Process changes chosen based on runs and trends in the data. Daily [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,5],"tags":[41,168,158],"class_list":["post-2800","post","type-post","status-publish","format-standard","hentry","category-jay-arthur-blog","category-qi-macros","tag-excel","tag-qi-macros","tag-quality-tools"],"_links":{"self":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/2800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/comments?post=2800"}],"version-history":[{"count":8,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/2800\/revisions"}],"predecessor-version":[{"id":5995,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/2800\/revisions\/5995"}],"wp:attachment":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media?parent=2800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/categories?post=2800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/tags?post=2800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}