<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>SixSigmaTutorial</title>
	
	<link>http://sixsigmatutorial.com</link>
	<description>Free Six Sigma eBooks, Tools, Templates, Tutorials, Calculators and Online Training with Certification.</description>
	<lastBuildDate>Tue, 27 Sep 2011 07:57:00 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/sixsigmatutorial" /><feedburner:info uri="sixsigmatutorial" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" /><feedburner:emailServiceId>sixsigmatutorial</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>What is RACI? Download RACI Matrix Templates for Six Sigma</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/cQBhmRU3xXQ/</link>
		<comments>http://sixsigmatutorial.com/what-is-raci-download-raci-rasci-matrix-templates-six-sigma/141/#comments</comments>
		<pubDate>Wed, 24 Aug 2011 06:29:58 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[Process Design]]></category>
		<category><![CDATA[RACI]]></category>
		<category><![CDATA[RACI Tool]]></category>
		<category><![CDATA[RAM]]></category>
		<category><![CDATA[RASCI]]></category>
		<category><![CDATA[Template]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=141</guid>
		<description><![CDATA[What is RACI ? In Six Sigma, a well thought out and proper Process Design is very important for the process to be efficiently implemented for a longer term. A process can be designed for an existing process which has no proper design and documentation or of course a new process that is being created from [...]]]></description>
			<content:encoded><![CDATA[<h2 style="text-align: justify;">What is RACI ?</h2>
<p style="text-align: justify;">In Six Sigma, a well thought out and proper Process Design is very important for the process to be efficiently implemented for a longer term. A process can be designed for an existing process which has no proper design and documentation or of course a new process that is being created from ground up. For this exercise of process design, its very important to first identify the various tasks in that process then identify the roles (people or groups or departments) and finally their responsibilities for a given task. Not all roles have a responsibility towards a task and a given task may not be associated to all roles. Typically a task is associated with at least one role or in some cases multiple roles. This &#8216;Association&#8217; of the role with a task can be divided into the following four association types:</p>
<ul>
<li><strong>R</strong>esponsible</li>
<li><strong>A</strong>ccountable</li>
<li><strong>C</strong>onsulted</li>
<li><strong>I</strong>nformed</li>
</ul>
<p style="text-align: justify;">The above four types of association of a role to a task represented in a simple task vs Role diagram or Matrix is called <strong>RACI</strong> (pronounced &#8216;racey&#8217;) matrix. So basically the RACI matrix is a responsibility assignment matrix (<strong>RAM</strong>), designed to assign tasks, activities, responsibilities, accountability, decision making, supporting to team members of a process/project  and clarify expectations on the level of their participation.</p>
<p>There is another association type that is some times used in addition to the above four types:<span id="more-141"></span></p>
<ul>
<li><strong>S</strong>upports</li>
</ul>
<p>When you use all the five types in the matrix, its called <strong>RASCI</strong> (pronounced &#8216;race ski&#8217;) Matrix. Lets go thru each association type in detail below:</p>
<h2><span style="color: #ff0000;">R</span>esponsible</h2>
<p style="text-align: justify;">The role or person or entity that is assigned the role type &#8216;Responsible&#8217; is the one who performs the work. In other words he/she is the &#8216;doer&#8217; of the task or activity. The person who is &#8216;Responsible&#8217; need not be accountable for that task, even though in some cases the same person can be &#8216;Responsible&#8217; and &#8216;Accountable&#8217;. The degree of &#8216;Responsibility&#8217; can vary and multiple roles can share the responsibility of a single task. Also the responsibility can be delegated by the role to another role. Using the RACI matrix we can see if a role has too many or too few responsibilities and try to adjust the work load.</p>
<h2><span style="color: #ff0000;">A</span>ccountable</h2>
<p>&#8216;Accountable&#8217; is the person or role who has the final authority and accountability to a given task. For any given task, there is only one role/person accountable. This accountability can&#8217;t be delegated to other roles or individuals or entities.</p>
<h2><span style="color: #ff0000;">C</span>onsulted</h2>
<p>&#8216;Consulted&#8217; are the people/roles who are consulted and taken advice from before and during performing the task. When there are many people who are assigned as &#8216;Consulted&#8217; roles, the time take to accomplish the task increases. On the other hand too few or no &#8216;Consulted&#8217; roles assigned to a task means that task has the risk of being under performed .</p>
<h2><span style="color: #ff0000;">I</span>nformed</h2>
<p>Informed are the people/roles who are informed <strong>after </strong>the task is completed. You need to assigned the &#8216;Informed&#8217; roles properly as otherwise it may lead to mis communication and delays. You need to make sure the right people/roles are informed after a task is performed successfully.  If too many roles are informed after a task, we need to see if its necessary to do so and minimize on that.</p>
<h2><span style="color: #ff0000;">S</span>upported</h2>
<p>&#8216;Supported&#8217; are the roles/groups/departments that provide the resources and hence support that task. This is an optional role type and if the matrix uses this category along with the other four RACI categories, then its called <strong>&#8216;RASCI&#8217;</strong> matrix.</p>
<h2>RACI Diagram</h2>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-RACI-Matrix.png"><img class="alignnone size-full wp-image-154" title="Six-Sigma-RACI-Matrix" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-RACI-Matrix.png" alt="Six-Sigma-RACI-Matrix" width="515" height="282" /></a></p>
<h2>Why do we need RACI?</h2>
<ul>
<li>RACI is a good communication tool. Without RACI, six sigma processes will result in poor communication and improper process definition and poor hand-offs</li>
<li>RACI makes sure each and every task is owned by a role</li>
<li>People tend to think think they are the ones who are responsible and/or accountable where as they might actually be in &#8216;Consulted&#8217; or &#8216;Supported&#8217; roles. Assigning wrong roles results in duplication of effort and misunderstanding and fighting.</li>
<li>RACI allows the right people to be assigned to the role of consulted.</li>
</ul>
<h2>RACI Benefits and Advantages</h2>
<ul>
<li>Activities and tasks in a six sigma process are well defined thru brainstorming.</li>
<li>By clarifying roles and responsibilities at the very initial stage of the process design, RACI helps setting up the proper expectations among team members and hence reduces future misunderstandings.</li>
<li>Eliminates duplication of effort</li>
<li>RACI helps improved communication by setting up the proper expectations among team members at the very initial process design stage.</li>
<li>Identifies the owner of a task clearly and assigns accountability to that role.</li>
<li>By ensuring that the correct people are involved, RACI helps in avoiding wrong decisions.</li>
<li>RACI clarifies hand-offs and task/role/responsibility boundaries.</li>
<li>Improves understanding of cross-functional view for employees  across divisions or departments, and helps employees across various groups respect and appreciate the roles and duties of people from other groups.</li>
</ul>
<h2> Step by Step procedure to create RACI Charts</h2>
<ol>
<li>Determine the functions, decisions, tasks and activities that will make up the process or project.</li>
<li>Identify who will be the project&#8217;s participants.</li>
<li>1,2 will make up the rows and columns of the RACI chart.</li>
<li>Identifying how each participant is involved with each function, decision,task, activity.</li>
<li>Fill out the grid with the letters R(responsible),  A (accountable), C (consulted), or I (informed)</li>
</ol>
<h2>RACI Example</h2>
<p>Lets take the simple two task example of designing the process for content management.</p>
<p>Task 1: Create Content</p>
<ul>
<li>The Creative Team is the party that is responsible for doing or developing a content piece. So they are assigned a role of <strong>R</strong>.</li>
<li>The Marketing Team/Department is the Accountable party and assigned the role <strong>A</strong> and they own this process.</li>
<li>The IT team needs to be Informed when this task is completed, so IT Team is assigned the role of <strong>I</strong>.</li>
<li>The Legal Team responsible for Consulting and approving this content. Also they need to be notified when this task is done. They will be assigned <strong>C,I</strong> and even <strong>R</strong></li>
</ul>
<p>Task 2: Upload the content</p>
<ul>
<li>The IT team is Responsible for the task of Uploading the content and Publishing it. Their role is assigned with <strong>R</strong></li>
<li>The Marketing team is accountable and needs to be informed when this task is completed. So they are assigned <strong>A,I</strong>.</li>
</ul>
<h2>Discoveries/findings from RACI Chart</h2>
<ul>
<li>Each task/function/activity (row) should have ONE and only ONE Accountable (A).</li>
<li>Each task/function/activity (row) should have at least one Responsible. In some cases, a task can have more than one role responsible with shared responsibility.</li>
<li>If a task has more than one R then the task should be brainstormed further and see if it can be split into two tasks.</li>
<li>The number of Consults should be minimized.</li>
<li>Too many I&#8217;s is also not a good sign. Minimize the I&#8217;s so that only those who need to be Informed are informed.</li>
<li>If a column has no empty spaces, that means that Role/Person is involved with all tasks.  See if you can reduce C&#8217;s and I&#8217;s for this Role.</li>
<li>If a column has many R&#8217;s &#8211; The role may have too much work to do. Try to break the task into small sections and delegate to other roles.</li>
<li>If a column has no A&#8217;s or R&#8217;s, may be this role can be eliminated from this process.</li>
<li>If a column has many A&#8217;s means this role be a bottleneck. Try to see if these tasks be shared.</li>
</ul>
<div class="KHDownload">
<h2>Download Free Six Sigma RACI Tools and Templates</h2>
<p><a title="Download the Excel template for Six Sigma RACI Matrix" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-RACI-Matrix.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-RACI-Matrix.xlsx">Download the Excel spreadsheet (xlsx) template for Six Sigma RACI Matrix</a><br />
<a title="Download the Word template for Six Sigma RACI Matrix" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-RACI-Matrix.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-RACI-Matrix.docx">Download the Word template (docx) for Six Sigma RACI Matrix</a><br />
<a title="Download the PPT template for Six Sigma RACI Matrix" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-RACI-Matrix.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-RACI-Matrix.pptx">Download the Powerpoint template (pptx) for Six Sigma RACI Matrix</a></p>
<h2>Download Free Six Sigma RASCI Tools and Templates</h2>
<p><a title="Download the Word template for Six Sigma RASCI Matrix " onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-RASCI-Matrix.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-RASCI-Matrix.docx">Download the Word template (docx) for Six Sigma RASCI Matrix </a><br />
<a title="Download the Excel template for Six Sigma RASCI Matrix " onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-RASCI-Matrix.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-RASCI-Matrix.xlsx">Download the Excel spreadsheet (xlsx) template for Six Sigma RASCI Matrix </a><br />
<a title="Download the PPT template for Six Sigma RASCI Matrix" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-RASCI-Matrix.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-RASCI-Matrix.pptx">Download the Powerpoint template (pptx) for Six Sigma RASCI Matrix</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/cQBhmRU3xXQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/what-is-raci-download-raci-rasci-matrix-templates-six-sigma/141/feed/</wfw:commentRss>
		<slash:comments>9</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/what-is-raci-download-raci-rasci-matrix-templates-six-sigma/141/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=what-is-raci-download-raci-rasci-matrix-templates-six-sigma</feedburner:origLink></item>
		<item>
		<title>What is Six Sigma Quality Function Deployment (QFD)? Download Free Excel QFD Template</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/AbvLSArPQI4/</link>
		<comments>http://sixsigmatutorial.com/what-is-six-sigma-quality-function-deployment-qfd-download-free-excel-qfd-template/50/#comments</comments>
		<pubDate>Wed, 17 Aug 2011 16:15:38 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[DMAIC Define Phase]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[House of Quality]]></category>
		<category><![CDATA[QFD]]></category>
		<category><![CDATA[Template]]></category>
		<category><![CDATA[Voice of the Customer]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=50</guid>
		<description><![CDATA[In Six Sigma DMAIC, Quality Function Deployment (QFD) is a methodology and tool used in the Define stage. QFD is used to: Collect customer&#8217;s requirements/desires as specified by the customers in their own words Prioritize these desires Translate them into engineering/process requirements Establish targets to meet the requirements. QFD is also termed as: Voice of [...]]]></description>
			<content:encoded><![CDATA[<p>In Six Sigma DMAIC, <strong>Quality Function Deployment (QFD) </strong> is a methodology and tool used in the Define stage. <strong>QFD </strong>is used to:</p>
<ol>
<li>Collect customer&#8217;s requirements/desires as specified by the customers in their own words</li>
<li>Prioritize these desires</li>
<li>Translate them into engineering/process requirements</li>
<li>Establish targets to meet the requirements.</li>
</ol>
<p>QFD is also termed as:</p>
<ul>
<li>Voice of the Customer</li>
<li>House of Quality</li>
<li>Customer-Driven Engineering</li>
<li>Matrix Product Planning</li>
</ul>
<p>QFD is a customer driven product or service planning process. It is a methodology for translating customer requirements into company requirements at each stage from Concept Definition (R&amp;D) to Process Engineering and Production and into the marketplace. The QFD matrix is a tool to translate CCRs (Critical To Customers) into CTQs (Critical to Quality).</p>
<p>QFD collects the voice of the customer (VOC) in their own lingo and incorporates this VOC into the companies cross-functional team’s project management of the integrated development process. The QFD process establishes customer objectives and measures and records them on a series of matrices</p>
<h2>This QFD matrix</h2>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/QFD-Process-Translating-CCR-to-CTQ.png"><img class="alignnone size-full wp-image-51" title="QFD-Process-Translating-CCR-to-CTQ" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/QFD-Process-Translating-CCR-to-CTQ.png" alt="QFD-Process-Translating-CCR-to-CTQ" width="457" height="68" /></a><span id="more-50"></span></p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-QFD-Matrix.png"><img class="alignnone size-full wp-image-52" title="Six-Sigma-QFD-Matrix" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-QFD-Matrix.png" alt="Six-Sigma-QFD-Matrix" width="624" height="483" /></a></p>
<p>QFD matrix translates the CCRs into CTQs. The final score helps prioritize the CTQs and helps you decide which CTQs to tackle first.</p>
<h2>The QFD Methodology</h2>
<ul>
<li>Identify both internal and external customers.</li>
<li>Create a list of customer requirements/desires (<strong>Whats</strong>) by
<ul>
<li>Asking the customer, questions such as &#8220;What are the important features of  The Product&#8221;</li>
<li>Capturing the customer&#8217;s own words or &#8220;<strong>Voice of the Customer&#8221;</strong> or <strong>VOC</strong></li>
<li>Categorizing the <strong>Whats </strong>into groups/buckets if needed.</li>
</ul>
</li>
<li>Prioritize the above collected Whats on a scale of 1-5, with 5 being the most important. This ranking is based on the VOC (Voice of Customer) data. The CCRs (Whats) are listed vertically in the first column and all related CTQs (Hows) are listed horizontally across the top . In the second column, assign 1 to 5 based on the importance of the CCRs, where 5 is the most critical to the customer.</li>
<li>Score each CTQ (Hows) on how strongly it correlates to each CCR. Remember we are looking at the absolution value of the correlation. It could be either positively correlated or negatively correlated. Use 5 for a strong correlation and 1 is a weak one. Leave it blank if there is no correlation. Some CCRs will have few CTQs that relate and rest unrelated.</li>
<li>Compile list of CTQs (Hows) necessary to achieve the CCRs (Whats.)</li>
<li>Translate the CCRs from VOC (Whats) into CTQs (Hows)
<ul>
<li>Arrows show direction for improvement (up for increasing, down for decreasing, etc.)</li>
</ul>
</li>
<li>For each <strong>What</strong>, find out the correlation with each <strong>How</strong>. If the correlation is strong use 5. If its week use 1. If its in between, use a number 2,3,4 based on how strong the correlation is.</li>
<li>Next multiply the importance rating for the CCR by the correlation score for each CTQ.</li>
<li>Add up the scores vertically for each CTQ and place that value in the bottom score row.</li>
<li>Once the score is computed for all CTQs, the ones with the highest scores are the highest priority Six Sigma project objectives to work on.</li>
</ul>
<div class="KHDownload">
<h2>Download Free Six Sigma QFD Tool/Templates</h2>
<p><a title="SixSigma QFD Matrix in Excel" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'SixSigma-QFD-Matrix.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/SixSigma-QFD-Matrix.xlsx">Download the free Six Sigma QFD Template in MS Excel Spreadsheet (xlsx) Format.</a><br />
<a title="SixSigma QFD Matrix in Word" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'SixSigma-QFD-Matrix.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/SixSigma-QFD-Matrix.docx">Download the free Six Sigma QFD Template in MS Word (docx) Format.</a><br />
<a title="SixSigma QFD Matrix in Powerpoint" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'SixSigma-QFD-Matrix.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/SixSigma-QFD-Matrix.pptx">Download the free Six Sigma QFD Template in MS Powerpoint (pptx) Format.</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/AbvLSArPQI4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/what-is-six-sigma-quality-function-deployment-qfd-download-free-excel-qfd-template/50/feed/</wfw:commentRss>
		<slash:comments>4</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/what-is-six-sigma-quality-function-deployment-qfd-download-free-excel-qfd-template/50/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=what-is-six-sigma-quality-function-deployment-qfd-download-free-excel-qfd-template</feedburner:origLink></item>
		<item>
		<title>How to create and use Six Sigma SIPOC tool? Download Free SIPOC tool Template in Excel Spreadsheet</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/KiKE_wC9g8E/</link>
		<comments>http://sixsigmatutorial.com/how-to-create-use-six-sigma-sipoc-tool-download-free-sipoc-tool-template-excel/27/#comments</comments>
		<pubDate>Wed, 17 Aug 2011 05:25:03 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[DMAIC Define Phase]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[House of Quality]]></category>
		<category><![CDATA[QFD]]></category>
		<category><![CDATA[SIPOC]]></category>
		<category><![CDATA[Template]]></category>
		<category><![CDATA[Voice of the Customer]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=27</guid>
		<description><![CDATA[What is SIPOC SIPOC is a Six Sigma tool used in the phase 1 or the &#8220;Define Phase&#8221; of the DMAIC process, to gather information about any process. SIPOC stands for: Suppliers, Inputs, Process, Output and Customers. A SIPOC tool is usually an Excel spreadsheet which lists all the five elements into five columns as [...]]]></description>
			<content:encoded><![CDATA[<h2>What is SIPOC</h2>
<p style="text-align: justify;"><strong>SIPOC </strong>is a Six Sigma tool used in the phase 1 or the &#8220;Define Phase&#8221; of the DMAIC process, to gather information about any process. <strong>SIPOC </strong>stands for: <strong>Suppliers, Inputs, Process, Output and Customers. </strong>A SIPOC tool is usually an Excel spreadsheet which lists all the five elements into five columns as shown below. In this SIPOC diagram, we are describing a process of upgrading the memory of a laptop.<strong><br />
</strong></p>
<p><a title="Six-Sigma-SIPOC-Tool" href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-SIPOC-Tool.png"><img class="alignnone" title="Six-Sigma-SIPOC-Tool" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-SIPOC-Tool.png" alt="Six-Sigma-SIPOC-Tool" /></a></p>
<h2>What does SIPOC Include?</h2>
<p><span id="more-27"></span></p>
<p>SIPOC shows a clear understanding of the process by including:</p>
<ul>
<li>All the Suppliers who provide the inputs and services to the process.
<ul>
<li>Suppliers are individuals or divisions that supply inputs to the process.</li>
<li>Suppliers can be can be internal such as department, division, or individuals</li>
<li>Suppliers can be external such as vendors, government.</li>
<li>It is also possible that a supplier is also a customer.</li>
<li>In our example of upgrading the memory of a Laptop process, the suppliers are:
<ul>
<li>The Mechanic who provides his services</li>
<li>The vendors who supply the Memory, tools,</li>
<li>The utility that supplies electricity.</li>
</ul>
</li>
</ul>
</li>
<li>All the Inputs needed, including all raw materials, services, information.
<ul>
<li>In our example of upgrading the memory of a Laptop process, the inputs are the Laptop, Memory, Tools, Electricity.</li>
</ul>
</li>
<li>The Process as depicted as a sequence of actions represented by a Flowchart diagram.</li>
<li>Outputs of the process are the products, services, information that comes out of this process and is used by the Customers.
<ul>
<li>In our example process, the upgraded Laptop and the old memory modules removed from the laptop.</li>
</ul>
</li>
<li>The customers are the users who will use the outputs produced by the process.
<ul>
<li>In our example process, the customer is the Owner of the laptop.</li>
</ul>
</li>
</ul>
<h2>How to create a SIPOC</h2>
<ul>
<li>SIPOC creation is a team activity.</li>
<li>Brainstorming must be done to discover details about a process, especially if its a new process.</li>
<li>All the stakeholders of the process must be part of this brainstorming.</li>
<li>Brainstorming must be done for each of the five elements: suppliers, inputs, process, outputs and customers of SIPOC.</li>
<li>If the process is new, it is a good idea to start SIPOC from customer and move backwards to supplier.</li>
<li>For an existing process that needs to be documented, SIPOC diagram is best created by first defining the process flowchart, and then identify inputs, outputs, customers, and suppliers.</li>
</ul>
<h2>Advantages of SIPOC</h2>
<ul>
<li>Helps us understand the purpose and the scope of a process</li>
<li>If lists all the suppliers clearly so we can see who is supplying to the process.</li>
<li>It gives us insight in to all the inputs of a process</li>
<li>It gives us insight in to all the outputs of a process</li>
<li>Graphically shows the process as a flowchart/sequence of actions so the new team members can easily understand the process.</li>
<li>All the customers are clearly identified, who will use the process outputs.</li>
</ul>
<h2>What are the differences between QFD and SIPOC?</h2>
<p>Even though both <a title="QFD" href="http://sixsigmatutorial.com/what-is-six-sigma-quality-function-deployment-qfd-download-free-excel-qfd-template/50/">QFD</a> and SIPOC are used in the define stage of DMAIC, they are different.</p>
<ul>
<li>SIPOC helps define a process where as QFD is used to take the customer&#8217;s voice and translate into engineering/process requirements.</li>
<li>SIPOC identifies suppliers, Inputs, process, Outputs and Customers where as QFD is used after SIPOC to gather customers voice and translate into CTQs (critical to quality)</li>
</ul>
<div class="KHDownload">
<h2>Download Free Six Sigma SIPOC Tools and Templates</h2>
<p><a title="Six-Sigma-SIPOC-Template Excel" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-SIPOC-Template.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-SIPOC-Template.xlsx">Download the Six Sigma SIPOC Template in MS Excel Spreadsheet (xlsx) format</a><br />
<a title="Six-Sigma-SIPOC-Template Word" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-SIPOC-Template.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-SIPOC-Template.docx">Download the Six Sigma SIPOC Template MS Word (docx) format</a><br />
<a title="Six-Sigma-SIPOC-Template Powerpoint" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-SIPOC-Template.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-SIPOC-Template.pptx">Download the Six Sigma SIPOC Template MS Powerpoint (pptx) format</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/KiKE_wC9g8E" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/how-to-create-use-six-sigma-sipoc-tool-download-free-sipoc-tool-template-excel/27/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/how-to-create-use-six-sigma-sipoc-tool-download-free-sipoc-tool-template-excel/27/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=how-to-create-use-six-sigma-sipoc-tool-download-free-sipoc-tool-template-excel</feedburner:origLink></item>
		<item>
		<title>Six Sigma Scatter Plots – Download Free Excel Spreadsheet Six Sigma Scatter Plot template</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/kflt5KTgaiQ/</link>
		<comments>http://sixsigmatutorial.com/six-sigma-scatter-plots-download-free-excel-six-sigma-scatter-plot-template/81/#comments</comments>
		<pubDate>Mon, 15 Aug 2011 10:46:05 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[Coefficient of Determination]]></category>
		<category><![CDATA[Correlation Coefficient]]></category>
		<category><![CDATA[DMAIC Analyze Phase]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[R Squared]]></category>
		<category><![CDATA[Scatter Diagram]]></category>
		<category><![CDATA[Scatter Graph]]></category>
		<category><![CDATA[Scatter Plot]]></category>
		<category><![CDATA[Template]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=81</guid>
		<description><![CDATA[A scatter diagram is a graphical representation of two variables, one on X axis and the other on Y axis. Hence they are also known as XY plots. A Scatter plot depicts the relationship between the two variables and determines if there is a correlation between those two variables.When one variable changes if the other [...]]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">A scatter diagram is a graphical representation of two variables, one on X axis and the other on Y axis. Hence they are also known as XY plots. A Scatter plot depicts the relationship between the two variables and determines if there is a correlation between those two variables.When one variable changes if the other variable changes, then a correlation is said to exist between those two variables. We can use the correlation to predict behavior. Its very useful if one variable is easy to measure and the other variable is difficult to measure.</p>
<p>Scatter plots show large amounts of data in a chart form. When the points on the scatter plot come closer making it a straight line, the correlation between the variables is higher and the relationship between the variables is stronger.</p>
<h2>Correlation Coefficient (R) and Coefficient of determination (R Squared)</h2>
<p>Correlation Coefficient is measured as:</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Correlation-Coefficient-Formula.gif"><img class="alignnone size-full wp-image-82" title="Correlation-Coefficient-Formula" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Correlation-Coefficient-Formula.gif" alt="Correlation-Coefficient-Formula" width="615" height="49" /></a></p>
<p>R = [N * Sum(XY) - Sum(X)*Sum(Y)] / SQRT [N * Sum (X^2) - (Sum(X))^2] * SQRT [N * Sum (Y^2) - (Sum(Y))^2]</p>
<p>R is always between -1 and +1</p>
<p>Coefficient of determination is the square of R or R squared. This is always a positive number between 0 and +1<span id="more-81"></span></p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Scatter-Plot-Positive-Correlation.png"><img class="alignnone size-full wp-image-83" title="Six-Sigma-Scatter-Plot-Positive-Correlation" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Scatter-Plot-Positive-Correlation.png" alt="Six-Sigma-Scatter-Plot-Positive-Correlation" width="379" height="338" /></a></p>
<p style="text-align: justify;">If the straight line goes up from left to right with <strong>higher </strong>values of X  corresponding to <strong>higher </strong>values of Y then the correlation is said to be  positive. A perfect positive correlation is of value +1. A good example of perfect positive correlation of +1 is the case where you use X grams of flour to make Y grams of Cake. As X increases Y increases proportionally and the correlation is equal to +1.</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Scatter-Plot-Negative-Correlation.png"><img class="alignnone size-full wp-image-85" title="Six-Sigma-Scatter-Plot-Negative-Correlation" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Scatter-Plot-Negative-Correlation.png" alt="Six-Sigma-Scatter-Plot-Negative-Correlation" width="393" height="337" /></a></p>
<p style="text-align: justify;">If the straight line goes down from left to right with <strong>higher </strong>values of X  corresponding to <strong>lower </strong>values of Y then the correlation is said to be negative. A perfect negative correlation is of value -1. A good example of perfect negative correlation of -1 is the case where  you have X amount of money in the bank and Y amount of additional money needed to become a millionaire. As X increases Y decreases   proportionally and the correlation is equal to -1.</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Scatter-Plot-No-Correlation.png"><img class="alignnone size-full wp-image-84" title="Six-Sigma-Scatter-Plot-No-Correlation" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Scatter-Plot-No-Correlation.png" alt="Six-Sigma-Scatter-Plot-No-Correlation" width="396" height="339" /></a></p>
<p style="text-align: justify;">If there is no relationship between the variables, then the plot does not look like a straight line, rather it looks &#8220;scattered&#8221; all over the XY plane. If there is no correlation between the variables then the correlation value is 0.</p>
<p style="text-align: justify;">The correlation value thus ranges from -1 to +1. As the correlation number gets closer to +1 or -1 such as 0.8991 0r -0.9023 then the relationship is said to be stronger. If the correlation number is closer to 0 such as -0.1023 or + 0.122 then the relationship is considered to be week.</p>
<div class="KHDownload">
<h2>Download Free Six Sigma Scatter Plot Tools and Templates</h2>
<p><a title="Six-Sigma-ScatterPlot-Excel-R-Squared" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-ScatterPlot-Excel-R-Squared.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-ScatterPlot-Excel-R-Squared.xlsx">Download the six Sigma Scatter Plot Spreadsheet Template in Excel (xlsx) format</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/kflt5KTgaiQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/six-sigma-scatter-plots-download-free-excel-six-sigma-scatter-plot-template/81/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/six-sigma-scatter-plots-download-free-excel-six-sigma-scatter-plot-template/81/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=six-sigma-scatter-plots-download-free-excel-six-sigma-scatter-plot-template</feedburner:origLink></item>
		<item>
		<title>How to create Six Sigma Histograms? Download free template in MS Excel Spreadsheet</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/cc3r5WRHgKA/</link>
		<comments>http://sixsigmatutorial.com/how-to-create-six-sigma-histograms-download-free-template-in-ms-excel/91/#comments</comments>
		<pubDate>Sun, 14 Aug 2011 11:09:08 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[DMAIC Analyze Phase]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[Histogram]]></category>
		<category><![CDATA[Six Sigma]]></category>
		<category><![CDATA[Template]]></category>
		<category><![CDATA[Tutorial]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=91</guid>
		<description><![CDATA[Histograms are used to represent continuous data in the form of a diagram or chart. In the Analysis stage of DMAIC, Six Sigma histogram tools are used. Typically Histograms are represented as bar charts. Large amounts of data that is difficult to understand if represented in a tabular spreadsheet form. In the Measure stage of [...]]]></description>
			<content:encoded><![CDATA[<p style="text-align: justify;">Histograms are used to represent continuous data in the form of a diagram or chart. In the <strong>Analysis </strong>stage of DMAIC, Six Sigma histogram tools are used. Typically Histograms are represented as bar charts. Large amounts of data that is difficult to understand if represented in a tabular spreadsheet form.</p>
<p>In the <strong>Measure </strong>stage of DMAIC, the data is collected. Then this data is reviewed by the team. Typically the data collected is is of two types:</p>
<ol>
<li>Discrete data (true/false, fail/pass, success/failure )</li>
<li>Continuous data (example: frequency, color, time). Histograms are best suited for representing this data.</li>
</ol>
<p style="text-align: justify;">Histograms can provide a visual display of such data by dividing this large data into a finite number of groups or buckets. Once the buckets are defined, you need to match and find out for every number what bucket it belongs to. Once a number is assigned to a bucket, you need to increment the frequency value of that bucket. Once all numbers are counted, you take the buckets and their frequencies and represent them in a bar chart with buckets on X axis and the the frequencies on the Y axis.</p>
<ul>
<li>Histograms are used to understand how the output of a process effects customer expectations</li>
<li>They will help you find out if the process is capable of meeting customer requirements</li>
<li>Histograms are graphs of a distribution (frequency of occurrence) of data.</li>
<li>Histograms show centering, dispersion (spread), and shape (relative frequency) of the data.</li>
</ul>
<p>Lets take the example of a part (a screw) which is manufactured at a plant. The ideal diameter of the screw is 52.3 mm. Lets measure the diameter of a random sample of 16 screws. The diameters are measured as below:</p>
<p><span id="more-91"></span></p>
<p>52.1 52.2 52 52.3 52.2 52.5 52.3 52.3 52.2 52.1 52.6 52.4 52.3 52.4 52.5 52.4</p>
<p>Lets group them into the following buckets:</p>
<p>52<br />
52.1<br />
52.2<br />
52.3<br />
52.4<br />
52.5<br />
52.6</p>
<p>Now lets count how many screws belong to each bucket and compute the frequency</p>
<table width="115" border="1">
<tbody>
<tr>
<td>Bucket</td>
<td>Frequency</td>
</tr>
<tr>
<td>52</td>
<td>1</td>
</tr>
<tr>
<td>52.1</td>
<td>2</td>
</tr>
<tr>
<td>52.2</td>
<td>3</td>
</tr>
<tr>
<td>52.3</td>
<td>4</td>
</tr>
<tr>
<td>52.4</td>
<td>3</td>
</tr>
<tr>
<td>52.5</td>
<td>2</td>
</tr>
<tr>
<td>52.6</td>
<td>1</td>
</tr>
</tbody>
</table>
<p>The above data can be represented as a bar chart as shown below:</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Histogram.png"><img title="Six-Sigma-Histogram" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Histogram.png" alt="Six-Sigma-Histogram" width="694" height="346" /></a></p>
<p style="text-align: justify;">In Microsoft Excel, you can create a histogram very easily using the &#8220;Analysis Toolpack&#8221; Add-In. (Go to File/Options/Add-Ins and make sure the Analysis ToolPak AddIn is installed). All you need to do is input your data (in our case all the diameters) into a sheet. You can use one single column or multiple columns. Also decide what your buckets are. Put them in a separate column. Now go to data menu and choose Data Analysis/Histogram. For the Input range, choose the appropriate Excel range containing the diameter data. For the Bin Range choose the column that contains your buckets. For the output, you can choose a range or a new sheet option. Click OK and Excel will automatically create the histogram table and Chart for you. No need to count and find out manually the frequency. Its done for you by the Analysis Pack histogram tool.</p>
<div class="KHDownload">
<h2>Download Free Six Sigma Histogram Tools and Templates</h2>
<p><a title="Six-Sigma-Histogram-Tool" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Histogram-Tool.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-Histogram-Tool.xlsx">Download the Microsoft Excel (xlsx) Spreadsheet Template for Six Sigma Histogram</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/cc3r5WRHgKA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/how-to-create-six-sigma-histograms-download-free-template-in-ms-excel/91/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/how-to-create-six-sigma-histograms-download-free-template-in-ms-excel/91/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=how-to-create-six-sigma-histograms-download-free-template-in-ms-excel</feedburner:origLink></item>
		<item>
		<title>How to select a Six Sigma project? Download selection grid template in Excel Spreadsheet</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/q-GHtoIAdUY/</link>
		<comments>http://sixsigmatutorial.com/select-six-sigma-project-download-selection-grid-template-excel/97/#comments</comments>
		<pubDate>Fri, 22 Jul 2011 11:34:53 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[Improvement Opportunities]]></category>
		<category><![CDATA[Selection Grid]]></category>
		<category><![CDATA[Six Sigma]]></category>
		<category><![CDATA[Template]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=97</guid>
		<description><![CDATA[In any company there are many processes that need to be improved at any given time. When the time and resources are limited, we need to prioritize the options and pick those processes first, that give the quickest and best results in the short amount of time span and are relatively easy to implement. This [...]]]></description>
			<content:encoded><![CDATA[<p>In any company there are many processes that need to be improved at any given time. When the time and resources are limited, we need to prioritize the options and pick those processes first, that give the quickest and best results in the short amount of time span and are relatively easy to implement. This can be compared to an apple tree where there are low hanging fruit that is easy and quicker to pick compared to the rest of the fruit. One should always pick the low hanging processes first and fix them for problems and proceed to fix the rest of the processes.</p>
<p>When the quality level of a process is not very high, we can use the basic six sigma tools. Typically the sigma level for such processes is 2σ or 3σ. Once the quality level gets better pass beyond 3σ, we will need to use more sophisticated tools such as DOE (Design of Experiments), SPC (Statistical Process Control) and DSS (Design for Six Sigma).</p>
<h2>How to identify improvement opportunities ?</h2>
<p><span id="more-97"></span></p>
<ol>
<li>Identify the top 10 problems with high variation, top hidden factory problems, backlogs, or high down time issues.</li>
<li>For each of the above problems, identify all the underlying processes.</li>
<li>Pick the processes that are:
<ul>
<li>Very well defined</li>
<li>Have easily identifiable starting and ending points</li>
<li>Have clearly defined objectives</li>
</ul>
</li>
</ol>
<p>Do Not Pick</p>
<ol>
<li>Processes that are being fixed by another team</li>
<li>Problems for which the solution is identified but causes of the problem are not known</li>
</ol>
<p>Once you go through the above list, you will have now identified a bunch of processes that meet the above criterion. Now you need use <strong>&#8220;Selection Grid&#8221;</strong> or <strong>&#8220;Selection Matrix&#8221;</strong> method to prioritize from this list and pick the process with the highest <strong>&#8220;Selection grid/Matrix Score&#8221;</strong>.</p>
<h2>Selection Grid/Matrix</h2>
<p>We need to identify and define all possible criterion to which each of these projects can be measured. Good examples of criterion are:</p>
<ul>
<li>Doability by the existing team (resource criterion)</li>
<li>Financial Viability (Financial criterion)</li>
<li>Importance to other divisions (Cross division/company criterion)</li>
<li>How important is it to the customer (Customer Criterion)</li>
</ul>
<p>Once you define these criterion, assign a weight-age on a scale of 1 to 3 to each of the above criterion.</p>
<p>Create an excel worksheet with a table containing criterion along the horizontal axis (columns) and the projects along the vertical axis (rows). Insert one row above the criterion labels and in that put the weight of the criterion (which is a constant across all projects). Now for each of the projects, define how well it meets a given criterion on a scale of 1-5. Put that number in the cell corresponding to the Project row and criterion column. Once this grid is filled with the scores for all projects for all criterion, we need to compute the overall score of the project which is the sum of products of criterion weightage and the project score for meeting that criterion.</p>
<p>For example, for project 1, the score is: 1X3 + 3X2 + 3X1 + 3X3 + 2X2 + 5X1 = 30</p>
<p>Once the total score is computed for all projects, you can order them in descending sort order and the top project with the highest score is the first choice to pick.</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Project-Selection-Grid-Matrix.png"><img class="alignnone size-full wp-image-98" title="Six-Sigma-Project-Selection-Grid-Matrix" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Project-Selection-Grid-Matrix.png" alt="Six-Sigma-Project-Selection-Grid-Matrix" width="801" height="209" /></a></p>
<div class="KHDownload">
<h2>Download Free Six Sigma Project Selection Tools and Templates</h2>
<p><a title="Six Sigma Project Selection Grid template in Microsoft Excel" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Project-Selection-Grid-Matrix.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-Project-Selection-Grid-Matrix.xlsx">Download the for Six sigma Project Selection Grid template in Microsoft Excel Spreadsheet (xlsx) format</a><br />
<a title="Six Sigma Project Selection Grid template in Microsoft Word" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Project-Selection-Grid-Matrix.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-Project-Selection-Grid-Matrix.docx">Download the for Six sigma Project Selection Grid template in Microsoft Word (docx) format</a><br />
<a title="Six Sigma Project Selection Grid template in Microsoft Powerpoint" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Project-Selection-Grid-Matrix.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-Project-Selection-Grid-Matrix.pptx">Download the for Six sigma Project Selection Grid template in Microsoft Powerpoint (pptx) format</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/q-GHtoIAdUY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/select-six-sigma-project-download-selection-grid-template-excel/97/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/select-six-sigma-project-download-selection-grid-template-excel/97/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=select-six-sigma-project-download-selection-grid-template-excel</feedburner:origLink></item>
		<item>
		<title>Six Sigma Tools and Calculators – Calculations of DPMO, DPM, Sample Size and Confidence Interval</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/sLMXjy6PRSE/</link>
		<comments>http://sixsigmatutorial.com/six-sigma-tools-calculators-dpmo-dpm-sample-size-confidence-interval/119/#comments</comments>
		<pubDate>Thu, 12 May 2011 09:20:40 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Calculators]]></category>
		<category><![CDATA[Confidence Interval]]></category>
		<category><![CDATA[DMAIC Analyze Phase]]></category>
		<category><![CDATA[DPM]]></category>
		<category><![CDATA[DPMO]]></category>
		<category><![CDATA[Sample Size]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=119</guid>
		<description><![CDATA[These Six Sigma online calculators help you calculate your process metrics such as DPMO, DPM, Sample Size, Six Sigma. Click on the buttons to show the Six Sigma Calculator DPMO Calculator: Number Of Defects: Number Of Oppurtunities: Number Of Defect Oppurtunities per Unit: Click to Calculate DPMO: Six Sigma: DPM Calculator: Number Of Defects: Sample [...]]]></description>
			<content:encoded><![CDATA[<p><script type="text/javascript" src="/Scripts/jquery-1.4.1.js"></script><script type="text/javascript" src="/Scripts/dpmo.js"></script>These Six Sigma online calculators help you calculate your process metrics such as DPMO, DPM, Sample Size, Six Sigma.<br />
<span id="more-119"></span></p>
<h2>Click on the buttons to show the Six Sigma Calculator</h2>
<input id="_dpmo_button" type="button" value="DPMO Calculator" />
<input id="_dpm_button" type="button" value="DPM Calculator" />
<input id="_ss_button" type="button" value="Sample Size Calculator" />
<div class="KHSSCalcForm">
<div id="_dpmo" class="_sscalc">
<p>DPMO Calculator:</p>
<p>Number Of Defects:</p>
<input id="NDefects" type="text" value="160" /> Number Of Oppurtunities:</p>
<input id="NOpps" type="text" value="78970" /> Number Of Defect Oppurtunities per Unit:</p>
<input id="DOppsUnit" type="text" value="8" /> <span id="calculate_dpmo" style="background: lightblue;">Click to Calculate DPMO: </span><br />
<span id="calculate_dpmo_ss" style="background: lightblue;">Six Sigma: </span></div>
<hr />
<div id="_dpm" class="_sscalc">
<p>DPM Calculator:</p>
<p>Number Of Defects:</p>
<input id="NDefects1" type="text" value="16" /> Sample Size:</p>
<input id="NSampleSize" type="text" value="12340" /> <span id="calculate_dpm" style="background: lightblue;">Click to Calculate DPM: </span><br />
<span id="calculate_dpm_ss" style="background: lightblue;">Six Sigma: </span></div>
<hr />
<div id="_ss" class="_sscalc">
<p>Sample Size Calculator:</p>
<p>Confidence Level: 95%<br />
Confidence Interval:</p>
<input id="ConfidenceInterval" type="text" value="3" /> Population:</p>
<input id="Population" type="text" value="100000" /> <span id="calculate_ss" style="background: lightblue;">Click to Calculate Sample Size:</span></div>
</div>
<div id="_dpmo_desc" class="_sscalc_desc">
<h2>DPMO &#8211; Defects Per Million Oppurtunities Calculator</h2>
<p>Defects per million opportunities (<strong>DPMO</strong>) is also known as nonconformities per million opportunities (<strong>NPMO</strong>).</p>
<h3>DPMO is calculated using the below formula:</h3>
<p><strong><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/DPMO-Formula.png"><img class="alignnone size-full wp-image-122" title="DPMO-Formula" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/DPMO-Formula.png" alt="DPMO-Formula" width="640" height="85" /></a><br />
</strong></p>
</div>
<div id="_dpm_desc" class="_sscalc_desc">
<h2>DPM &#8211; Defects Per Million Calculator</h2>
<h3>DPM is calculated using the below formula:</h3>
<p><strong><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/DPM-Formula.png"><img class="alignnone size-full wp-image-123" title="DPM-Formula" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/DPM-Formula.png" alt="DPM-Formula" width="364" height="115" /></a><br />
</strong></p>
</div>
<div id="_ss_desc" class="_sscalc_desc">
<h2>Sample Size Calculator</h2>
<h3>Sample Size is calculated using the below formula:</h3>
<p><span style="font-size: small;"><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Sample-Size-Formula.png"><img class="alignnone size-full wp-image-124" title="Six Sigma Sample Size Formula" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Sample-Size-Formula.png" alt="Six Sigma Sample Size Formula" width="395" height="102" /></a><br />
</span><br />
Where <strong>CI</strong> is the confidence Interval in decimal format. If the Confidence Interval is ±4% then use 0.04<br />
<strong>p</strong> is Percentage of the sample picking a choice, expressed in decimal. For Sample Size Calculation, we use a <strong>p</strong> of 0.50<br />
<strong>Z</strong> value is 1.96 for a Confidence Level of 95%, which is the most commonly used Confidence Level by researchers.A confidence level of 95% means that you are 95% certain about the outcome.</p>
<h3>Sample Size Correction For finite Population</h3>
<p>The above formula works for bigger populations. For smaller or finite populations, you need to correct the value obtained from the above using the below formula.<br />
<a href="http://sixsigmatutorial.com/wp-content/uploads/2011/03/Sample-Size-Correction-Formula.png"><img class="alignnone size-full wp-image-131" title="Sample Size Correction For finite Population Formula" src="http://sixsigmatutorial.com/wp-content/uploads/2011/03/Sample-Size-Correction-Formula.png" alt="Sample Size Correction For finite Population Formula" width="485" height="116" /></a></p>
</div>
<p>Related Tutorial: <a href="http://sixsigmatutorial.com/six-sigma-tools-calculators-dpmo-dpm-sample-size-confidence-interval/119/"> </a><a href="http://sixsigmatutorial.com/defect-based-six-sigma-metrics-dpo-dpmo-ppm-dpu-yield/276/">Understanding defect based six sigma metrics: DPO, DPMO, PPM, DPU, Yield</a></p>
<div class="KHDownload">
<h2><img title="MS Excel" src="/images/MS-Excel-Icon.png" alt="MS Excel" /> Free Download: Defect Metrics Calculators in Microsoft Excel Spreadsheet</h2>
<p><a title="Six-Sigma Calculator DPO DPMO Sample Size" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Calculator-DPO-DPMO-Sample-Size.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-Calculator-DPO-DPMO-Sample-Size.xlsx">Download Six-Sigma Calculators for DPO, DPMO, Sample-Size in Excel</a>
</div>

<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/sLMXjy6PRSE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/six-sigma-tools-calculators-dpmo-dpm-sample-size-confidence-interval/119/feed/</wfw:commentRss>
		<slash:comments>3</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/six-sigma-tools-calculators-dpmo-dpm-sample-size-confidence-interval/119/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=six-sigma-tools-calculators-dpmo-dpm-sample-size-confidence-interval</feedburner:origLink></item>
		<item>
		<title>How to perform Six Sigma Pareto Analysis using Pareto Chart? download free template in Excel Spreadsheet</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/_FLQ-2mb1S4/</link>
		<comments>http://sixsigmatutorial.com/sigma-pareto-analysis-pareto-chart-download-free-template-microsoft-excel/104/#comments</comments>
		<pubDate>Sun, 03 Apr 2011 03:02:45 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[Decision Making tool]]></category>
		<category><![CDATA[DMAIC Analyze Phase]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[Pareto]]></category>
		<category><![CDATA[Pareto Analysis]]></category>
		<category><![CDATA[Pareto Chart]]></category>
		<category><![CDATA[Pareto Diagram]]></category>
		<category><![CDATA[Root Cause Analysis]]></category>
		<category><![CDATA[Template]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=104</guid>
		<description><![CDATA[Pareto chart is a Lean and Six Sigma tool. Pareto chart can be used in Pareto Analysis to perform root cause analysis. Pareto rule is also known as 80/20 rule since it states that 80% of the problems are caused by 20% of the causes or issues. Pareto Chart or Pareto Diagram is named after [...]]]></description>
			<content:encoded><![CDATA[<p>Pareto chart is a Lean and Six Sigma tool. Pareto chart can be used in <strong>Pareto Analysis</strong> to perform root cause analysis. Pareto rule is also known as 80/20 rule since it states that 80% of the problems are caused by 20% of the causes or issues. <strong>Pareto Chart</strong> or <strong>Pareto Diagram </strong>is named after the Italian economist Vilfredo Pareto of the 19 th century.</p>
<p>Using this Pareto tool, one can visually identify the most occurring defects, most important factors or the most common problems. These &#8220;Most Important&#8221; factors are also known as &#8220;<strong>The vital few</strong>&#8220;.</p>
<h2>Data for Pareto Analysis</h2>
<p>Lets take the example of customer returns of toys made by a toy manufacturer. Lets start collecting data about these rejection over a fixed time period, say one month. 854 data points have been collated and grouped into 5 categories:</p>
<ol>
<li>Category 1 (Example: Damaged Packaging) 155 Occurrences</li>
<li>Category 2 (Example: Color Faded) 221 Occurrences</li>
<li>Category 3 (Example: Missing Part) 33 Occurrences</li>
<li>Category 4 (Example: Missing Brochure) 112 Occurrences</li>
<li>Category 5 (Example: Wrong Toy Sent) 333 Occurrences</li>
</ol>
<p>Now lets take the above defect categories and sort them in descending order based on the frequency of the problem occurance.</p>
<ol>
<li>Category 5 → 333 Occurrences → percentage of total occurrences = 333 ÷ 854 = 38.99 %</li>
<li>Category 2 → 221 Occurrences → percentage of total occurrences = 221 ÷ 854 = 25.88 %</li>
<li>Category 1 → 155 Occurrences → percentage of total occurrences = 155 ÷ 854 = 18.15 %</li>
<li>Category 4 → 112 Occurrences → percentage of total occurrences = 112 ÷ 854 = 13.11%</li>
<li>Category 3 → 33 Occurrences → percentage of total occurrences = 33 ÷ 854 = 3.86%</li>
</ol>
<p>Lets create an excel worksheet and place this data into it, sorted high to low. Column one is the Defect category, column 2 is the frequency of occurrence, column 3 is the percentage from the above list.</p>
<p><span id="more-104"></span></p>
<p>Lets create one more column and place the cumulative percentage of the frequency. Notice that for the Category 5 the cumulative frequency percentage is same as the frequency percentage. For the next category Category 2, its the some of category 5 and 2 which amounts to 38.99+ 25.88 = 64.87. For the next category in list the cumulative is 38.99+ 25.88 + 18.15 = 83.02 and so on. Finally the last category, category 3 has a cumulative frequency percentage of 100%.</p>
<p>The below picture shows the screenshot of the excel table that we just created. We used &#8220;Format As Table&#8221; feature to format the data into a table so we can sort on the columns easily by clicking on the arrow next to the column headings in Excel.</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Pareto-Data.png"><img class="alignnone size-full wp-image-107" title="Six-Sigma-Pareto-Data" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Pareto-Data.png" alt="Six-Sigma-Pareto-Data" width="676" height="151" /></a></p>
<p>Next thing we need to do is create a Pareto Chart to represent the above the data graphically. Pareto chart is a bar chart with line chart overlay-ed on top of the bar chart. The bar chart represents the categories with the frequencies in descending order. We use the left Y Axis to represent the values and X Axis to represent the categories. The line chart represents the &#8220;Cumulative Frequency percentage&#8221;. We used the secondary Y axis to represent the line chart values since the scales or ranges of these values do not match.</p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Pareto-Chart.png"><img class="alignnone size-full wp-image-108" title="Six-Sigma-Pareto-Chart" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Six-Sigma-Pareto-Chart.png" alt="Six-Sigma-Pareto-Chart" width="1077" height="428" /></a></p>
<p>The above chart shows all the defect categories clearly in descending order in a bar chart along with the cumulative frequency of occurrence as a line chart with values on the secondary Y axis.</p>
<div class="KHDownload">
<h2>Download Free Six Sigma Pareto Chart Tools and Templates</h2>
<p>Download: <a onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Pareto-Chart-And-Analysis-Template.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/Six-Sigma-Pareto-Chart-And-Analysis-Template.xlsx">Microsoft Excel Spreadsheet (xlsx) &#8211; Six sigma Pareto chart/analysis template</a>
</div>

<h2>How to do Pareto Analysis based on the above Pareto Chart</h2>
<p>Pareto Analysis is analyzing the data from the above chart and finding out where the line graph crosses 80% mark on the secondary Y axis (right hand side). Then find out all the categories to the left of that point which are <strong>&#8220;vital few&#8221;</strong> or most significant factors. The remaining categories (or factors) are called <strong>&#8220;Useful Many&#8221; </strong>and they are less significant.</p>
<p><strong>Vital Few</strong> = Categories with cumulative freq 80 below = Categories 5,2,1</p>
<p><strong>Useful Many</strong> = Categories with cumulative freq 80 above = Categories 3,4</p>
<h2>Pareto Chart and Analysis Summary</h2>
<ul>
<li>Pareto Charts help finding which issues are causing most problems</li>
<li>Pareto Charts are used in root cause analysis</li>
<li>Pareto Charts are a decision making tool and do not contain data such as detail data analysis and costs of failure.</li>
<li>Pareto analysis results in finding the efforts where it will have the most impact.</li>
<li>Pareto Charts decide the order in which the issues will be addressed.</li>
</ul>
<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/_FLQ-2mb1S4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/sigma-pareto-analysis-pareto-chart-download-free-template-microsoft-excel/104/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/sigma-pareto-analysis-pareto-chart-download-free-template-microsoft-excel/104/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=sigma-pareto-analysis-pareto-chart-download-free-template-microsoft-excel</feedburner:origLink></item>
		<item>
		<title>What are Hidden Factory, Cost of Quality? The two types of cost of quality – Visible and Hidden</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/e6Yww9OEVnM/</link>
		<comments>http://sixsigmatutorial.com/hidden-factory-the-two-types-of-cost-of-quality-visible-and-hidden/113/#comments</comments>
		<pubDate>Mon, 07 Mar 2011 18:19:45 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tutorials]]></category>
		<category><![CDATA[COPQ]]></category>
		<category><![CDATA[Cost Of Poor Quality]]></category>
		<category><![CDATA[Cost of Quality]]></category>
		<category><![CDATA[Hidden Costs]]></category>
		<category><![CDATA[Hidden Factory]]></category>
		<category><![CDATA[Tutorial]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=113</guid>
		<description><![CDATA[What is cost of quality defects? Cost of quality defects is the cost incurred due to poor quality. The cost can be measured as a percentage of lost sales. For many companies, the costs for quality defects amounts upto 40% of total sales turnover. In other words, you can improve your sales by upto 40% [...]]]></description>
			<content:encoded><![CDATA[<h2>What is cost of quality defects?</h2>
<p>Cost of quality defects is the cost incurred due to poor quality. The cost can be measured as a percentage of lost sales. For many companies, the costs for quality defects amounts upto 40% of total sales turnover. In other words, you can improve your sales by upto 40% by simply improving your quality.</p>
<p>It is difficult to increase sales turnover in bad economic conditions, recession etc but one can increase the company&#8217;s profit by reducing the company&#8217;s unnecessary costs for deficient product and/or information quality.</p>
<p><span id="more-113"></span></p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Cost-Of-Quality-Hidden-Factory.png"><img class="alignnone size-full wp-image-114" title="Six-Sigma-Cost-Of-Quality-Hidden-Factory" src="http://sixsigmatutorial.com/wp-content/uploads/2011/08/Cost-Of-Quality-Hidden-Factory.png" alt="Six-Sigma-Cost-Of-Quality-Hidden-Factory" width="624" height="361" /></a></p>
<h2>What is Hidden factory ? The visible costs of quality versus hidden costs of quality</h2>
<p>The cost of quality can be divided into the <strong>visible </strong>costs of quality and hidden or unmeasured costs of quality.</p>
<h3>The visible costs of quality is a small percentage of the total costs of quality, and include:</h3>
<ul>
<li>Scrap</li>
<li>Returns</li>
<li>Re-working</li>
<li>Refurbishing</li>
</ul>
<h3>The hidden cost of quality</h3>
<p>Most of the costs of poor quality are hidden from our normal quality measures. These costs of quality are often referred to as the <strong>Hidden Factory</strong>. This includes:</p>
<ul>
<li>Unhappy customers</li>
<li>Schedule interruptions</li>
<li>Fire Fighting</li>
<li>Unnecessary Procedures</li>
<li>Equipment Failures</li>
<li>Extra Operations such as touch ups and trimming</li>
<li>Distracted Engineers</li>
<li>Expediting time</li>
<li>Poorly performing product</li>
<li>Extra inspection and testing</li>
<li>Wasted materials and energy</li>
<li>Sorting</li>
<li>Extra inventory</li>
<li>Unexplained budget variations</li>
<li>Missed shipments</li>
<li>Complaint Investigation Cost</li>
</ul>
<p>Many companies only work on eliminating the visible costs. They usually miss the hidden ones. The hidden costs of quality defects are often hidden as an overhead cost which is smoothed over or thrown together with other costs, which means that the cost of the quality defect is difficult to identify. In 1977, the quality guru Armand Feigenbaum estimated the cost within the hidden factory can be 10% to 40% of total company effort. Many companies do not know where quality defects originate, nor how to identify them. Systematically focusing on identifying and eliminating visible as well as hidden costs for quality defects can give big results for relatively little effort.</p>
<h2>What is COPQ</h2>
<p>The term Cost Of Poor Quality (COPQ) is also used to represent the above two costs. The <strong>COPQ </strong>can be estimated by multiplying the number of defects per period of time by the average unit cost to fix a defect (labour and materials). Such a benign calculation however omits costs such as loss of goodwill and loss of competitiveness, and other matters such as warranty costs and legal damages.</p>
<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/e6Yww9OEVnM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/hidden-factory-the-two-types-of-cost-of-quality-visible-and-hidden/113/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/hidden-factory-the-two-types-of-cost-of-quality-visible-and-hidden/113/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=hidden-factory-the-two-types-of-cost-of-quality-visible-and-hidden</feedburner:origLink></item>
		<item>
		<title>What is Fishbone Analysis? Download Fishbone Diagrams &amp; Charts in Excel &amp; Powerpoint</title>
		<link>http://feedproxy.google.com/~r/sixsigmatutorial/~3/vPHY8c3UgRA/</link>
		<comments>http://sixsigmatutorial.com/fishbone-analysis-download-diagrams-charts-in-excel-powerpoint/245/#comments</comments>
		<pubDate>Sat, 19 Feb 2011 16:31:08 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Tools & Templates]]></category>
		<category><![CDATA[Cause & Effect]]></category>
		<category><![CDATA[Chart]]></category>
		<category><![CDATA[DMAIC Analyze Phase]]></category>
		<category><![CDATA[Download]]></category>
		<category><![CDATA[Excel Spreadsheet]]></category>
		<category><![CDATA[Fishbone]]></category>
		<category><![CDATA[Ishikawa]]></category>
		<category><![CDATA[Powerpoint Slide]]></category>
		<category><![CDATA[Template]]></category>

		<guid isPermaLink="false">http://sixsigmatutorial.com/?p=245</guid>
		<description><![CDATA[What is a Fishbone diagram or Fishbone Analysis? Fishbone diagram is a analysis tool to provide systematic way of understanding effects and the causes that create those effect. The design of the diagram looks like the skeleton of a fish hence, it is referred to as the fishbone diagram. Dr. Kaoru Ishikawa, a Japanese quality [...]]]></description>
			<content:encoded><![CDATA[<h2>What is a Fishbone diagram or Fishbone Analysis?</h2>
<p>Fishbone diagram is a analysis tool to provide systematic way of understanding effects and the causes that create those effect. The design of the diagram looks like the skeleton of a fish hence, it is referred to as the fishbone diagram.</p>
<p>Dr. Kaoru Ishikawa, a Japanese quality control statistician, invented the fishbone diagram. Also referred to as the Ishikawa diagram. Also fishbone is referred to as a cause-and-effect diagram.</p>
<p>Fishbone diagram is a great value in assisting teams in categorizing the many potential causes of problems or issues in a systematic way and helps identifying root causes.</p>
<h2>A fishbone diagram be used when:</h2>
<ul>
<li>The team needs to study a problem to determine the root cause</li>
<li>Want to study all the possible reasons why a process is having difficulties, problems, or breakdowns in the initial stages of the process.</li>
<li>Need to identify areas for data collection</li>
<li>To study why a process is not performing properly and/or producing the expected results</li>
</ul>
<p><span id="more-245"></span></p>
<h2>Creating a Fishbone Diagram</h2>
<ol>
<li>Draw a fishbone diagram</li>
<li>List the problem/issue to be studied in the head of the fish</li>
<li>Label each bone of the fish. The major categories typically used are:
<ul type="square">
<li>The 6 M’s: Methods, Machines, Materials, Manpower, Measurement, Management</li>
<li>The 4 P’s: Place, Procedure, People, Policies</li>
<li>The 4 S’s: Surroundings, Suppliers, Systems, Skills</li>
</ul>
</li>
<li>Repeat this procedure with each factor under the category to produce sub-factors. Continue asking, &#8220;Why is this happening?&#8221; and put additional segments each factor and subsequently under each sub-factor.</li>
<li>Continue until you no longer get useful information as you ask, &#8220;Why is that happening?&#8221;</li>
<li>Analyze the results of the fishbone after team members agree that an adequate amount of detail has been provided under each major category. Do this by looking for those items that appear in more than one category. These become the &#8216;most likely causes&#8221;.</li>
<li>For those items identified as the &#8220;most likely causes&#8221;, the team should reach consensus on listing those items in priority order with the first item being the most probable&#8221; cause.</li>
</ol>
<div class="KHDownload">
<h2>Download Microsoft Excel Templates for Sample Fishbone Analysis and Fishbone Diagram Example</h2>
<p>Just fill in your Effects and Causes to create your own Fish-bone diagram/chart/graph. Very useful for your six sigma projects.</p>
<h2><img style="vertical-align: middle;" title="MS Excel" src="/images/MS-Excel-Icon.png" alt="MS Excel" /> Free Download: Fishbone Analysis Diagram Templates are in Microsoft Excel (xlsx) Format</h2>
<p><a title="FishBone Diagram Template - 4Ps (Plant, People, Policies and Procedure) " onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'SixSigma-FishBone-Diagram-Template-in-Microsoft-Excel-4Ps.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/SixSigma-FishBone-Diagram-Template-in-Microsoft-Excel-4Ps.xlsx">FishBone Diagram Template &#8211; 4Ps (Plant, People, Policies and Procedure) in Excel</a><br />
<a title="FishBone Diagram Template - 6Ms (Man, Machine, Management, Measurement, Material and Method) " onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'SixSigma-FishBone-Diagram-Template-in-Microsoft-Excel-6Ms.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/SixSigma-FishBone-Diagram-Template-in-Microsoft-Excel-6Ms.xlsx">FishBone Diagram Template &#8211; 6Ms (Man, Machine, Management, Measurement, Material and Method) in Excel</a><br />
<a title="FishBone Diagram Template - 4Ss (Surroundings, Suppliers, Systems, Skills)" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'SixSigma-FishBone-Diagram-Template-in-Microsoft-Excel-4Ss.xlsx']);" href="http://sixsigmatutorial.com/tools-templates/excel/SixSigma-FishBone-Diagram-Template-in-Microsoft-Excel-4Ss.xlsx">FishBone Diagram Template &#8211; 4Ss (Surroundings, Suppliers, Systems, Skills) in Excel</a></p>
<h2><img style="vertical-align: middle;" title="MS PPT" src="/images/MS-PPT-Icon.png" alt="MS PPT" /> Free Download: Fishbone Analysis Diagram Templates in Microsoft PowerPoint (pptx) Format</h2>
<p><a title="FishBone Diagram Template - 4Ps (Plant, People, Policies and Procedure) in PowerPoint" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-4Ps-Template.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-Fishbone-Analysis-Diagram-4Ps-Template.pptx">FishBone Diagram Template &#8211; 4Ps (Plant, People, Policies and Procedure) in PowerPoint</a><br />
<a title="FishBone Diagram Template - 6Ms (Man, Machine, Management, Measurement, Material and Method) in PPT" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-6Ms-Template.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-Fishbone-Analysis-Diagram-6Ms-Template.pptx">FishBone Diagram Template &#8211; 6Ms (Man, Machine, Management, Measurement, Material and Method) in PowerPoint</a><br />
<a title="FishBone Diagram Template - 4Ss (Surroundings, Suppliers, Systems, Skills) in PPT" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-4Ss-Template.pptx']);" href="http://sixsigmatutorial.com/tools-templates/powerpoint/Six-Sigma-Fishbone-Analysis-Diagram-4Ss-Template.pptx">FishBone Diagram Template &#8211; 4Ss (Surroundings, Suppliers, Systems, Skills) in PowerPoint</a></p>
<h2><img style="vertical-align: middle;" title="MS Word" src="/images/MS-Word-Icon.png" alt="MS Word" /> Free Download: Fishbone Analysis Diagram Templates in Microsoft Word (docx) Format</h2>
<p><a title="FishBone Diagram Template - 4Ps (Plant, People, Policies and Procedure) in Word" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-4Ps-Template.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-Fishbone-Analysis-Diagram-4Ps-Template.docx">FishBone Diagram Template &#8211; 4Ps (Plant, People, Policies and Procedure) in Microsoft Word</a><br />
<a title="FishBone Diagram Template - 6Ms (Man, Machine, Management, Measurement, Material and Method) in Word" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-6Ms-Template.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-Fishbone-Analysis-Diagram-6Ms-Template.docx">FishBone Diagram Template &#8211; 6Ms (Man, Machine, Management, Measurement, Material and Method) in Microsoft Word</a><br />
<a title="FishBone Diagram Template - 4Ss (Surroundings, Suppliers, Systems, Skills) in Word" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-4Ss-Template.docx']);" href="http://sixsigmatutorial.com/tools-templates/word/Six-Sigma-Fishbone-Analysis-Diagram-4Ss-Template.docx">FishBone Diagram Template &#8211; 4Ss (Surroundings, Suppliers, Systems, Skills) in Microsoft Word</a></p>
<h2><img style="vertical-align: middle;" title="MS Word" src="/images/PDF-Icon.png" alt="PDF" /> Free Download: Fishbone Analysis Diagram Templates in PDF Format</h2>
<p><a title="FishBone Diagram Template - 4Ps (Plant, People, Policies and Procedure) in PDF" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-4Ps-Template.pdf']);" href="http://sixsigmatutorial.com/tools-templates/pdf/Six-Sigma-Fishbone-Analysis-Diagram-4Ps-Template.pdf">FishBone Diagram Template &#8211; 4Ps (Plant, People, Policies and Procedure) in PDF</a><br />
<a title="FishBone Diagram Template - 6Ms (Man, Machine, Management, Measurement, Material and Method) in PDF" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-6Ms-Template.pdf']);" href="http://sixsigmatutorial.com/tools-templates/pdf/Six-Sigma-Fishbone-Analysis-Diagram-6Ms-Template.pdf">FishBone Diagram Template &#8211; 6Ms (Man, Machine, Management, Measurement, Material and Method) in PDF</a><br />
<a title="FishBone Diagram Template - 4Ss (Surroundings, Suppliers, Systems, Skills) in PDF" onclick="javascript: _gaq.push(['_trackEvent', 'Download', 'Six-Sigma-Fishbone-Analysis-Diagram-4Ss-Template.pdf']);" href="http://sixsigmatutorial.com/tools-templates/pdf/Six-Sigma-Fishbone-Analysis-Diagram-4Ss-Template.pdf">FishBone Diagram Template &#8211; 4Ss (Surroundings, Suppliers, Systems, Skills) in PDF</a>
</div>
<p><br />
<a href="http://sixsigmatutorial.com/wp-content/uploads/2011/02/FishBone-Diagram-6Ms-Man-machine-management-measurement-material-method.png"><img class="alignnone size-full wp-image-247" title="FishBone-Diagram-6Ms-(Man-machine-management-measurement-material-method)" src="http://sixsigmatutorial.com/wp-content/uploads/2011/02/FishBone-Diagram-6Ms-Man-machine-management-measurement-material-method.png" alt="FishBone-Diagram-6Ms-(Man-machine-management-measurement-material-method)" width="637" height="442" /></a></p>
<p><a href="http://sixsigmatutorial.com/wp-content/uploads/2011/02/FishBone-Diagram-4Ss-Surroundings-Suppliers-Systems-Skills.png"><img title="FishBone-Diagram-4Ss-Surroundings-Suppliers-Systems-Skills" src="http://sixsigmatutorial.com/wp-content/uploads/2011/02/FishBone-Diagram-4Ss-Surroundings-Suppliers-Systems-Skills.png" alt="FishBone-Diagram-4Ss-Surroundings-Suppliers-Systems-Skills" width="761" height="587" /></a></p>
<img src="http://feeds.feedburner.com/~r/sixsigmatutorial/~4/vPHY8c3UgRA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://sixsigmatutorial.com/fishbone-analysis-download-diagrams-charts-in-excel-powerpoint/245/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://sixsigmatutorial.com/fishbone-analysis-download-diagrams-charts-in-excel-powerpoint/245/?utm_source=rss&amp;utm_medium=rss&amp;utm_campaign=fishbone-analysis-download-diagrams-charts-in-excel-powerpoint</feedburner:origLink></item>
	</channel>
</rss>

