{"id":5745,"date":"2022-06-14T01:00:47","date_gmt":"2022-06-14T07:00:47","guid":{"rendered":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/?p=5745"},"modified":"2022-06-14T15:39:21","modified_gmt":"2022-06-14T21:39:21","slug":"what-kind-of-data-do-i-use","status":"publish","type":"post","link":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/what-kind-of-data-do-i-use\/","title":{"rendered":"What Kind of Data Should I Use?"},"content":{"rendered":"\r\n<p>Someone recently asked: &#8220;What kind of data should I use for control charts and Pareto charts.&#8221; The answer is simple. Here it is:<\/p>\r\n\r\n\r\n\r\n<p><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/704201892?title=0&amp;byline=0&amp;portrait=0\" width=\"720\" height=\"405\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\r\n\r\n\r\n\r\n<p>&#8220;Hi, I\u2019m Jay Arthur, author of \u201c<a href=\"https:\/\/www.amazon.com\/Lean-Six-Sigma-Demystified-Second\/dp\/0071749098\/\">Lean Six Sigma Demystified<\/a>\u201d and <a href=\"https:\/\/www.qimacros.com\/demo\/\">QI Macros [software]<\/a>.<\/p>\r\n<p>&#8220;I got a call from someone last week who was talking about how they&#8217;ve been a longtime user of QI Macros, and then how educated they were\u2026 and then they asked me, \u201cUh, Jay&#8230; I\u2019m not quite sure how to set up\u2026 what kind of data should I use for a <a href=\"https:\/\/www.qimacros.com\/training\/videos\/what-is-a-control-chart\/\">control chart<\/a>, and what kind of data should I use for a <a href=\"https:\/\/www.qimacros.com\/pareto-chart-excel\/\">Pareto chart<\/a>?\u201d I was like, \u201cWhat? How can you not know this?\u201d<\/p>\r\n<p>&#8220;All right, in very simple terms: for control charts and run charts you need time-series data, right? By date, by time, by whatever. For Pareto charts you need categories, types of defects, mistakes, errors, patient harm, whatever it is.<\/p>\r\n<p>&#8220;I thought \u201cHow is that possible?\u201d But then I realized something else: most people think of the QI Macros as software, not as a training shop. If you go out to our website, qimacros.com and <a href=\"https:\/\/www.qimacros.com\/training\/free-training\/\">click on \u201ctraining,\u201d<\/a> you&#8217;re going to find training about how to set up all your data in Excel so you can use it for charts. You&#8217;re going to find all kinds of tools and training, from <a href=\"https:\/\/www.qimacros.com\/Whitebelt\/white-belt-certification\/\">White Belt<\/a> to <a href=\"https:\/\/www.qimacros.com\/Moneybelt\/\">Yellow Belt<\/a> training; these are free unless you want to be certified, in which case we\u2019ll charge you [after] taking the test and getting certified.<\/p>\r\n<p>&#8220;I have a <a href=\"https:\/\/www.qimacros.com\/agile-lean-six-sigma\/\">free Agile [Lean Six Sigma] Trainer Training<\/a> which will teach you how I teach people in one day and get results\u2026 Lean and Six Sigma, one day and get results, right?<\/p>\r\n<p>&#8220;Free training, right? Our website is not just about the software, it&#8217;s all about making people wildly productive at Quality Improvement.<\/p>\r\n<p>&#8220;So that&#8217;s my Improvement Insight for this week: Go to qimacros.com and learn something. Let&#8217;s create a hassle-free America; hassle-free healthcare. Let&#8217;s go out and improve something this week.&#8221;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Someone recently asked: &ldquo;What kind of data should I use for control charts and Pareto charts.&rdquo; The answer is simple. Here it is: &#65279; &ldquo;Hi, I&rsquo;m Jay Arthur, author of &ldquo;Lean Six Sigma Demystified&rdquo; and QI Macros [software]. &ldquo;I got a call from someone last week who was talking about how they&rsquo;ve been a longtime [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":5840,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[290],"tags":[439,70,168],"class_list":["post-5745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-improvement-insights","tag-control-charts","tag-pareto-chart","tag-qi-macros"],"_links":{"self":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/5745","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=5745"}],"version-history":[{"count":8,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/5745\/revisions"}],"predecessor-version":[{"id":5875,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/5745\/revisions\/5875"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media\/5840"}],"wp:attachment":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media?parent=5745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/categories?post=5745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/tags?post=5745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}