{"id":365,"date":"2012-09-13T16:05:52","date_gmt":"2012-09-13T16:05:52","guid":{"rendered":"http:\/\/www.qimacros.com\/lean-six-sigma-blog\/?p=365"},"modified":"2023-02-01T12:27:02","modified_gmt":"2023-02-01T19:27:02","slug":"minitab-excel-which-should-i-use-when","status":"publish","type":"post","link":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/minitab-excel-which-should-i-use-when\/","title":{"rendered":"Minitab and Excel: Which Should I Use and When?"},"content":{"rendered":"<p>In a recent blog post, Minitab asked: &#8220;Have you ever found yourself switching back and forth between a Microsoft Excel file and Minitab Statistical Software just to complete a single analysis?&#8221;<\/p>\n<p>Comparing Minitab to Excel (without QI Macros) is a bit like comparing a calculator to an abacus.<\/p>\n<p><strong>If you have the QI Macros add-in for Excel,<\/strong> <em>you don&#8217;t have to switch. You can do everything in Excel.<\/em><\/p>\n<h2>Creating Graphs with Raw Data Easily<\/h2>\n<p>The blogger says: &#8220;Just try creating a Pareto Chart in Excel\u2026I <em>dare <\/em>you!&#8221;<\/p>\n<p>I&#8217;ll take that dare. If you have a column of defects (below), just click on the title for the column and choose the QI Macros Pareto Chart. In a few seconds you&#8217;ll have a Pareto Chart:<\/p>\n<p>Step 1:<br \/>\n<img decoding=\"async\" src=\"\/pareto-chart-excel\/text-data.png\" alt=\"pareto chart from column of text\" \/><\/p>\n<p>Step2<br \/>\n<img decoding=\"async\" src=\"\/pareto-chart-excel\/pareto-chart-menu2.png\" alt=\"pareto chart on qimacros menu\" \/><\/p>\n<p>Step 3<br \/>\n<img decoding=\"async\" src=\"\/pareto-chart-excel\/pareto-chart-example.png\" alt=\"pareto from text data\" \/><\/p>\n<p>Yes, in plain Excel it&#8217;s hard. With the QI Macros, it&#8217;s easy.<\/p>\n<h2>Managing and Organizing Multiple Graphs<\/h2>\n<p>Minitab uses their Project Manager.<\/p>\n<p>In Excel, just use multiple worksheets to organize a &#8220;book&#8221; of your improvement project:<\/p>\n<p><img decoding=\"async\" src=\"\/free-excel-tips\/data-analysis-101\/aiag-move-sheet2.jpg\" alt=\"\" \/><\/p>\n<h2>Statistical Methods for Quality Improvement<\/h2>\n<p>Minitab 16\u2019s Assistant menu uses decision trees that <em>you<\/em> <em>have to navigate before<\/em> you can run a statistic:<\/p>\n<p><img decoding=\"async\" src=\"\/images\/m16-decision-tree-4.jpg\" alt=\"\" \/><\/p>\n<p>The QI Macros Stat Wizard has the decision tree built in. It will analyze your data, choose the right statistics for you and even analyze the results:<\/p>\n<p><img decoding=\"async\" src=\"\/hypothesis-testing\/stat-wizard.png\" alt=\"\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/hypothesis-testing\/anova-single-factor-results.png\" alt=\"QI Macros ANOVA Single factor test results in Excel\" \/><\/p>\n<h2>But I&#8217;m Not a Statistician!<\/h2>\n<p>Minitab was designed by statisticians to train statisticians. Most ordinary users I talk to say the interface is cumbersome and confusing, mainly because it was designed for minicomputers not PCs (<strong>Mini<\/strong>computer <strong>Tab<\/strong>ulation).<\/p>\n<p>The QI Macros, on the other hand, was designed by a business guy for ordinary business people who want results from their Excel data and don&#8217;t want to feel stupid in the process. I think Minitab is great for statisticians. For everyone else, it&#8217;s overkill.<\/p>\n<p>So if you&#8217;ve ever found yourself switching back and forth between Excel and Minitab, the solution is simple. With the QI Macros and Excel, <em>you never have to switch..you can stay in the comfort of Excel<\/em>. And you&#8217;ll save about $1,400.<\/p>\n<p>Download a free 30-day\u00a0 trial at <a href=\"https:\/\/www.qimacros.com\">www.qimacros.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a recent blog post, Minitab asked: &ldquo;Have you ever found yourself switching back and forth between a Microsoft Excel file and Minitab Statistical Software just to complete a single analysis?&rdquo; Comparing Minitab to Excel (without QI Macros) is a bit like comparing a calculator to an abacus. If you have the QI Macros add-in [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[41,107,168],"class_list":["post-365","post","type-post","status-publish","format-standard","hentry","category-qi-macros","tag-excel","tag-minitab","tag-qi-macros"],"_links":{"self":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/365","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=365"}],"version-history":[{"count":16,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":6293,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/posts\/365\/revisions\/6293"}],"wp:attachment":[{"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qimacros.com\/lean-six-sigma-blog\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}