{"id":123,"date":"2008-11-13T16:17:49","date_gmt":"2008-11-13T16:17:49","guid":{"rendered":"http:\/\/www.supplychainview.com\/blog\/?p=123"},"modified":"2009-05-11T14:27:53","modified_gmt":"2009-05-11T14:27:53","slug":"free-excel-files-for-six-sigma-and-business-statistics","status":"publish","type":"post","link":"http:\/\/www.supplychainview.com\/blog\/2008\/11\/free-excel-files-for-six-sigma-and-business-statistics\/","title":{"rendered":"Free Excel files for Six Sigma and business statistics"},"content":{"rendered":"<p>I enjoy making useful things freely available on Supply Chain View, so it&#8217;s good to find other people doing the same thing. There are <a href=\"http:\/\/highered.mcgraw-hill.com\/sites\/0073373605\/student_view0\/excel_templates.html\">57 useful business statistics Excel files<\/a> to download from the McGraw Hill website (to accompany the book <a href=\"http:\/\/www.mhhe.com\/business\/opsci\/aczel05\/index.mhtml\">Complete Business Statistics<\/a> by Aczel and Sounderpandian).<\/p>\n<p>Among others, there are calculations for testing difference in means, linear regression, exponential smoothing, t-tests and (as they say) many, many more.<\/p>\n<p><!--more-->This is a screenshot from the control chart sheet. The colours look garish (could be because I opened it with Open Office) but the calculations are sound.<\/p>\n<div id=\"attachment_124\" style=\"width: 510px\" class=\"wp-caption alignnone\"><img aria-describedby=\"caption-attachment-124\" title=\"control_chart_xls\" src=\"http:\/\/www.supplychainview.com\/blog\/wp-content\/uploads\/control_chart_xls.jpg\" alt=\"Control Chart spreadsheet\" width=\"500\" \/><p id=\"caption-attachment-124\" class=\"wp-caption-text\">Control Chart spreadsheet<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I enjoy making useful things freely available on Supply Chain View, so it&#8217;s good to find other people doing the same thing. There are 57 useful business statistics Excel files to download from the McGraw Hill website (to accompany the book Complete Business Statistics by Aczel and Sounderpandian). Among others, there are calculations for testing [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,7],"tags":[70,68,69,9,71,40],"_links":{"self":[{"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/posts\/123"}],"collection":[{"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":5,"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":134,"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/posts\/123\/revisions\/134"}],"wp:attachment":[{"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.supplychainview.com\/blog\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}