Excel 5 why template

5 Why or why why analysis is a methodology to support finding the root cause of problems. In this article you will get a excel 5 why template filled with an example. And the example is demonstrated in this article. We are doing why why analysis in-depth here. Really in-depth.

So let’s get started…

Before start this article I ask you to read the previous post about Why-Why Analysis on KIE website.

Today we are going to explore a little bit more about Why-Why Analysis, using the same methodology but as a little more depth,
we´ll talk about the 3 pillars behind the 5 whys.

3 pillars of 5 Why analysis – Occurrence, Detective and Systemic Root cause.

Before we begin, download the template in excel, to support you in you daily routine. Excel template are editable, which you can use for other projects.

[wpdiscuz-feedback id=”sooaaqum4n” question=”Please leave a feedback on this” opened=”0″]<strong>Comment and win</strong> : Do you have any experience with 5 Why analysis ? or anything more to contribute to this article ? or Is it necessary to ask 5 why every time?. Contribute to this as comment in comment section and <a href=”https://knowindustrialengineering.com/comment-and-win/” target=”_blank” rel=”noreferrer noopener”>get a chance to win</a> exciting prize monthly. Click this icon to go to comment section.[/wpdiscuz-feedback]

Earnylink program : Get a chance to win exciting prize monthly by sharing this valuable article to your LinkedIn friends and groups, and submit the link to your LinkedIn post in this form.

Download 5 Why excel template

Click the below ‘download’ button, to download the excel template.

Now let’s do the why why analysis

Why Why Analysis in-depth analysis

Let´s see below how to perform a complete 5 whys analysis to identify the root cause of a problem.

In total, we have 3 causes that we can attack in more depth in order to mitigate system errors, they are:

  1. Occurrence Root Cause – Why did the problem occur?
  2. Detection Root Cause – Why was the problem not detected?
  3. Systematic Root Cause – Why did not prevent the problem?
A schematic diagram representing 5 Why

And here we have an additional information that will aggregate your analysis, that is “validate” the correlate among the problem , the 5 whys and the root cause.

As soon as you start asking the questions and get the answers, as soon as you detect the root cause (last answer you get) you will return adding 5 therefore in order to “validate” the answers obtained in the analysis.

Doing so will make the analysis more robust to the root cause detected.

Occurrence Root Cause

Continue reading with KIE Premium

Unlock this article and all KIE premium articles.

Read the complete article and access all KIE premium content
Where are you located?

Now or Never

We’ve got your back on your manufacturing journey — Stay in touch

Follow us for step-by-step guidance, templates, and insights that save time and reduce mistakes.

Know Industrial Engineering Platform – Helping manufacturing industry professionals worldwide since 2019

2 thoughts on “Excel 5 why template”

Leave a Comment

Your email address will not be published. Required fields are marked *