Scatter Diagram Template | Industrial Example | Download Excel Format

Scatter Diagram Template

 Industrial Example of Scatter Diagram | Interpretation of result | Scatter Diagram Template:

Hi readers! Today we will discuss on Scatter diagram Example with the interpretation of its results. The scatter diagram is one of the popular tools of 7QC tools. It’s a type of diagram to displays the value for typically two continuous variables for a set of data. One variable can be positioned on the X-axis and another variable can be positioned on the Y-axis. This diagram will help you to find out the significant causes among the total collection of potential causes. When you have variable types of data collection of potential causes and you do not know the positive or negative relationship that time you can plot the scatter diagram to know the relationship among them. You can download our simple Excel Scatter Diagram Template from the below link.  

DOWNLOAD– Sample Scatter Diagram Excel Template/ Format.

Example:

An organization has tried to know the significant causes for the high compressive strength of “X” quantity sand, so initially quality engineer drew the cause& effect diagram with the help of CFT team members and then he started the validation of each potential cause. The same C&F diagram is mentioned below.

Scatter Diagram Template

Here, we have not mentioned the other potential causes like mixing time, water%, etc. because these are already validated but now we have to know the relationship among the two variables as additive quantity v/s compressive strength through a scatter diagram. To do so data has to be collected and then a scatter diagram needs to be drawn.

Data table:

Additives in Kg. Compressive Strength (gm/cm²)
2.5 1245
3.5 1290
5 1330
6.5 1395
7.5 1435

 Scatter Diagram:

Scatter Diagram Template

Interpretation of result:

The above scatter diagram indicates us there is a perfect positive correlation between two variables i.e. Additives in Kg. vs. Compressive Strength (gm/cm²). So we can conclude that more the additive addition can result in high compressive strength.

 Interpolation: you can guess the value from the set of data points. From the above graph, I would like to know the compressive strength if I will add 5.5 Kg additives in “X” Kg of Sand.

Scatter Diagram Template

FAQ:

Q1: What are the common possibilities of correlation between two variables of the scatter diagram?

 Ans.: There are so many possibilities but three common correlations are positive, negative, and no correlation. Positive and Negative correlations are further categorized into three types as.

Positive Correlation:

  • Low positive correlation
  • High positive correlation
  • Perfect positive correlation

Negative Correlation:

  • Low negative correlation
  • High negative correlation
  • Perfect negative correlation

Q2: What types of data are used to plot the scatter diagram?

Ans.: Continuous variable type data.

Useful Articles:

Types of Fishbone Diagram |Dispersion Analysis |Enumeration |Process Classification

7 QC Tools Template.

Repeatability vs Reproducibility | Discussion of Key difference.

Free Templates / Formats of QM: we have published some free templates or formats related to Quality Management with manufacturing / industrial practical examples for better understanding and learning. if you have not yet read these free template articles/posts then, you could visit our “Template/Format” section. Thanks for reading…keep visiting techiequality.com

Popular Post

4M Checklist Template | Free Download Format

4M Checklist Template

 4M Checklist Template |Free Download Format:

Hi Readers! Today we will discuss here on 4M Checklist Template. Generally, the 4M concept is used in several methodologies, In the Cause and effect diagram it represents the potential causes and similarly, it is also used as a checklist for Kaizen. In the kaizen approach, there are some checklists used as [1] 5MUs checklist [2] 5W1H checklist [3] 4M Checklist. But here we will only explain on the 4M checklist. We have prepared the 4M checklist for your ready reference. You can easily download this checklist/check sheet from the below link.

DOWNLOAD-4M Checklist/Check-sheet / 4m analysis template excel

Sample 4M Checklist Copy:

4M Checklist Template
4M Checklist Template:

4M i.e. Men, Machines, Materials & Methods are the common aspects and important for quality improvement and KAIZEN. Questions to be asked related to 4M to implement kaizen activities effectively are;

Man (Workforce)
Is he responsible?
Is he accountable?
Is he qualified?
Is he experienced?
Is he assigned to the right job?
Is everything in a good working order?
Does he follow standards?
Is his work efficiency acceptable?
Is he willing to improve?
Machine
Does it meet process capabilities?
Is the oiling/greasing adequate?
Does it meet production requirements?
Does it meet precision requirements?
Does it make any unusual noise?
Is the layout adequate?
Are there enough resources available?
Are there any mistakes in the material grade?
Is PM done as per plan?
Material
Is there any issue with material flow?
Are there any impurities mixed in?
Are there any mistakes in quantity?
Is the inventory level adequate?
Is there any wastage of materials?
Is the material quality standard adequate?
IS it a method that ensures a good product?
Method
Is the SOP adequate?
Is the SOP available on the shop floor?
Is the SOP upgraded?
Is it a safe method?
Is the setup adequate?
Is it a safe method?
Is it an efficient method?
Is the sequence of work adequate?
Are there any mistakes in the material grade?
Are the process characteristics set as per standard?
Are the product characteristics meeting the standard requirement?
Template
Example: We had audited the manufacturing process and got the below observations;
4M Checklist Template
4M Checklist Template

During the process audit through the 4M checklist, we have observed so many improvement points, these are mentioned in the above checklist remark column. In this way, you can easily find out the process improvement points. Download the above 4M Checklist and try to customize it according to your manufacturing process.

How to Implement the 4M checklist /Check sheet in Manufacturing Industries?

I always try to share my own industrial experience so that my readers can easily understand, learn, and implement the skill-based concept in their operational process.

Posts/articles on this website are skilled base, you can read our articles for your personal learning, for training purposes, and for practical implementation in the industry as well.

Generally, we use the 4M, and 6M check sheets to audit /investigate and to check the condition and lacking points of 4M factors (Men, Machine, Method, and Material). Some industries plan the checking schedule on a weekly and some on a monthly basis as per the production plan. By doing so we can easily maintain the machine condition, reduce the B/D, Increase the machine run time, we can identify the on-job training of operators /workers, maintain the material inventory, monitor the effectiveness of the Method, we can further improve our process, etc.

Below are the steps for implementation of 4M checklist/ check sheet:
  • Prepare the 4M checklist /Check sheet as per your Process in detail considering with past 6 months’ quality defect causes, B/D nature causes, customer complaints, etc.
  • Define the Checking plan (e.g. weekly, monthly, etc.)
  • Check 4M factors by using the 4M check sheet as per your plan,
  • Write the observations.
  • Discuss with the concerned department and formulate the Action plan / CAPA.
  • Implement the CAPA /Action Plan.
  • Monitor the implementation of the action plan (For example, verify it in the next checking).
4M Change Management:

After doing the 4M Audit you can easily identify the 4M-related changes. the above 4m checklists is mentioned for your reference but the checking points are not limited. you can customize the above checklist as per your manufacturing process.

You can identify and monitor the 4M changes in the 4M change Record sheet as per below.

Sl. No.ProcessType of ChangeNature of ChangeDetails of ChangeAction TakenSet-up ApprovalRetroactive checkContainment Action
4M Change record

Example:

Type of Change: Man, Machine, Method, and Material.

Nature of Change: Plan change, Unplan change, Abnormal change

FAQ (Frequently Asked Question):
What is 4M in Manufacturing Industries?

Ans.: In Industries the term 4M is generally used as [1] Man [2] Machine [3] Material & [4] Method.

What is 4M method?

Ans.: The 4M method is generally used in manufacturing industries for problem-solving /analysis. These terms are generally represented in 4M change management and also in the Cause and effect diagram or Fishbone diagram. The potential causes are basically represented under the category of 4M- Cause and effect diagram for further processing like causes/problem analysis and validation of causes, etc.

More on TECHIEQUALITY

Dispersion Analysis Cause & Effect Diagram Template |Download Excel Format

Dispersion Analysis Cause & Effect Diagram Template

Dispersion Analysis & Process Classification Cause & Effect Diagram Template

Hi readers! Today we will discuss on types of Cause & Effect Diagram/Fishbone diagram. The cause and effect diagram is the most popular and frequently used tool among the seven QC tools. Basically Fishbone diagram is classified into mainly two types as [1] Dispersion Analysis Cause and Effect diagram, and [2] Process Classification Fishbone diagram. The Dispersion analysis fishbone diagram involves identifying the potential cause for a specific quality problem. However, a Process classification cause & effect diagram involves establishing causes related to the Process. In the manufacturing industry, both types of diagrams are used but Dispersion types are most frequently used to identify the potential causes of the quality-related problems.  If you are interested in downloading the Dispersion Analysis Cause & Effect Diagram Template & Process Classification fishbone diagram, then click on the given below links.

DOWNLOAD– Dispersion analysis cause & effect diagram template. (4Ms).

Dispersion Analysis Cause & Effect Diagram Template
4Ms

Dispersion analysis Fishbone Diagram Excel Template. (4Ps)-DOWNLOAD.

Dispersion Analysis Cause & Effect Diagram Template
4Ps

DOWNLOAD– Dispersion analysis cause & effect diagram format. (8Ms).

Dispersion Analysis Cause & Effect Diagram Template
8Ms

Process Classification cause & effect diagram excel format-DOWNLOAD.

Dispersion Analysis Cause & Effect Diagram Template
Process Classification

Steps for construction of Cause & Effect Diagram:

  • Form a CFT- Team with a multifunctional experienced workforce.
  • The facilitator will listen carefully to the member’s potential causes to represent it in a diagram.
  • Draw a backbone line from left to right, terminating at the Head, and write the Problem statement.
  • Draw the small bone and write the potential cause.
Dispersion Analysis Cause & Effect Diagram Template

Advantages:

  • It helps to identify the potential cause to improve the process.
  • Helps in the root cause identification of the problem.
  • C&E diagram is easily constructed & understood.
  • It is an effective tool for the diagnosis of the various causes of the problem and helping to solve the problem.

Disadvantages:

  • Waste of time to identify the other causes that are not critical to the Problem.
  • It’s a time-consuming methodology.

Dispersion Analysis Cause & Effect diagram V/S Process Classification Fishbone diagram:

ishikawa Template
fishbone  Template

Useful Links:

Strategies for Manufacturing Process Improvement |11+ Strategies

7QC Tools for Problem Solving | What are 7 QC Tools

Fishbone Diagram Template With Example

Root Cause Analysis | 8 Steps of RCA

More on TECHIEQUALITY

Thanks for Reading…Keep visiting Techiequality.Com

Popular Post

Fault tree analysis template | Download format free…

Fault tree analysis template

 Fault tree analysis template | Download format | FTA with Example:

Hi Readers! Today we will discuss on FTA. And also we have prepared some templates/formats considering with some situations. You can download the same templates from the below links. FTA (Fault tree analysis template) was developed by H.A Watson at Bell Laboratory in 1962. Fault tree analysis is generally used to analyze the undesired state of a system through Boolean algebra. This is commonly applicable in the fields of the Nuclear power sector, Chemical manufacturing and service sector, Pharmaceutical, Petrochemical, Aerospace, and other high-hazard industries but now it has become a popular diagram that is being used in almost all types of organizations or sectors.

DOWNLOAD –Fault Tree Analysis Sample Template.

As we know, if any incidents occur (may be due to high-risk factors or particular system level failure) in a high-hazard factory may lead to a high Severity score in health, environment, and safety concerns. So here we will explain the FTA in detail with EHS-related Examples.

FTA Event and Gate Symbols:

Fault tree analysis template

Frequently used gates are “OR gate” & “AND gate”.

Fault tree analysis template

You could also like to read our other articles:

5W2H Analysis Example |Download 5W2H Format.

5W1H Analysis Example |Download Template.

7 principles of QMS | Quality Management Principles.

Risk identification tools and techniques |Download Format.

SPC Format |DOWNLOAD Excel Template of SPC Study

Logic of “OR-Gate” & “AND-Gate”:

The output occurs if any input occurs. In the above figure you can see there is I/P-1 and I/P-2 in Or-Gate, The output of OR-gate will occur when any one of among two inputs will occurs. But in the case of AND-gate, the output will occur when both the input (I/P-1 & I/P-2) will occur.

Example: AFT of High Pollution:

Fault tree analysis template
Fault tree analysis template
Similar Post:

7QC Tools Excel Template |DOWNLOAD Format.

why why analysis methodology | 5-why analysis step by step guide.

MSA interview questions and answers.

Decision of process capability analysis |Download Format.

How to measure process capability (Cp & Cpk)? Download Excel Template.

How to measure process performance (Pp & Ppk)?

Thank you for reading…keeps visiting Techiequality.Com

Popular Post:

Histogram Template with example | Download

Histogram Template

Histogram Template with example | Download

The Histogram Template is prepared in a simple format with an industrial example. We have described the example in below, just go through this article and Download the Template / Format. It’s a very useful tool and is frequently used in manufacturing industries. The main function is to know the frequency distribution, symmetry, and skewness, and it also helps to determine the normality of data by drawing the bell curve.

DOWNLOAD [Histogram Template in Excel format].

Histogram Template
Histogram Template

Basic Information on Histogram:

A histogram is one of the 7QC tools and commonly used graph to show frequency distribution. Helps summarize data from a process that has been collected over a period of time.

A histogram is a representation of the frequency distribution of numerical data. it was first familiarized by Karl Pearson. A histogram is related to merely one type of variable data. You should calculate the interval value to represent the bins. Bins shall give an idea about the how much data falls within the selected data range’s width. Histogram gives the indication about data distribution as normal, skewed, or bi-modal.

How to use our Histogram Template:

Step-1: Download the Histogram Template from the above link.

Step-2: Carefully read the “Note” mentioned in the Excel template.

Step-3: Enter the reading only in the yellow color box. Then other values will calculate automatically and your histogram will be ready for interpretation.

Note:

1. Only yellow colour boxes are changeable

2. Make sure that the sum of frequency is equal to the total count, e.g. sum of frequency in a given example [example is given in histogram excel format, just download and see the example] is 30 and the count is also 30, if not then you have to adjust the parameters and frequency table in frequency distribution format for doing so click on the link given “How to adjust parameters and frequency table in Histogram Template?”.

Useful Links:

How to Plot Pareto Chart in Excel ( with example)

What is SPC | SPC Tools?

Corrective and Preventive Action Format | CAPA with Example.

OEE Calculation-How To Calculate OEE (Overall Equipment Effectiveness) with Example

Implementation of KAIZEN in Industry

Thank you for reading…. Keep visiting Techiequality.Com

Let us know if you have any questions…and drop your comments below.

Popular Post:

Pareto Chart Excel Template | Download format

Pareto Chart Excel Template

Pareto Chart Excel Template | Step by Step guide of template usages:-

Hi Readers! In this article, we have discussed on Pareto Chart Excel Template with a manufacturing example. and also you can learn here, the Pareto chart principle (80/20 rule). if you would like to download our excel template or format then, go through the below link.

DownloadPareto chart Excel Template.

Pareto Chart Excel Template

[Figure 1]

How to Use Pareto Chart Excel Template:

After downloading, the above Pareto Chart Excel Template Carefully read the Note and red highlighted box marked in excel.

Note 1:- White cells are only changed values. The sky colour cells will automatically calculate based on the formula within the cells.

Note 2:- Starting from the top, enter the name of causes into the table below in descending order (Largest to Smallest Values)

Example of Pareto chart:

Let us have ten causes as Damage, Crack, Shrinkage, Short-run, Blowhole, Pin-hole, Extra Metal, Sand-wash, Rough Surface, Low hardness, and High elongation.

Causes Rejection Quantity
Damage 23
Shrinkage 20
Crack 11
Short-run 7
Blow-hole 8
Extra Metal 5
Sand wash 6
Rough surface 3
Low hardness 4
High elongation 1

Now you have to do the sorting of Rejection Quantity in Descending order (Largest to smallest value)

Descending order of Rejection Quantity of above causes are,-

Causes Rejection Quantity
Damage 23
Shrinkage 20
Crack 11
Blow-hole 8
Short-run 7
Sand wash 6
Extra Metal 5
Low hardness 4
Rough surface 3
High elongation 1

Now directly we have to enter the name of causes and Rejection quantity (After sorting the value in descending order) into white cells of the Excel template sheet. After entering the values the Pareto chart will look like as below.

Pareto chart example
Pareto Principle (80/20 Rule):-

The 80/20 Rule or Pareto Principle is the most important part of Pareto Analysis. The rule 80/20 says that 80% of the effects come from 20% of the causes.

In Italy, Vilfredo Pareto has originally observed that 20% of people were owned 80% of the land. This principle was applied to quality control and favoured the use of the statement of phrase, which is “The Vital few and useful many” to define the 80/20 rule in the 20th century by Dr. Joseph M. Juran. Nowadays this principle is so popular and very useful in describing the contribution of the causes.

Understanding of Principle:-

Let’s get started with this principle, and how it is applicable in different sectors like manufacturing and non-manufacturing unit or service sectors. This principle is not limited to any particular sector or unit’s problems or defects to identify the contribution. It will help you to resolve 80% of problems/causes/defects among the 100% of problems.  

How this principle is related to the different fields: – (Example)-

  • Filed failure (for example (a)-80% of the field failure comes from 20% of the Causes.
    (b)-80% of the field failure comes from 20% of the Customer).
  •  80% of the results come from 20% of the Team.
  • Risk Management (e.g. 80% of the Risk comes from 20% of the Causes).

Let us have ten types of Causes and individual causes having a number of defects. Now we need to work on merely an 80% contribution to resolve the problem. But the things are how to identify the causes those are coming under the 80% contribution. So to identify the contribution we need to use the Pareto chart for knowing the contribution. So I would recommend you to download the above Pareto Chart Excel Template then, follow the steps and identify the contribution.

Advantages of Pareto Chart:

1. Production Optimisation.

2. Rejection Reduction.

3. Cost of Poor Quality Reduction.

4. Quality level Improvement.

5. Product Performance Improvement

6. Customer satisfaction Enhancement.

7. Rework cost reduction.

Etc.

The Pareto chart is the most commonly used tool in manufacturing industries, I remember when I was working in the quality department, how frequently I used this tool in our daily quality issue analysis. I used this tool on a daily line rejection analysis, as well as in different types of QA or QC projects like quality circle projects, SGA projects, Six Sigma projects, etc. With the help of the Pareto chart, you can easily visualize the defect’s contribution and accordingly, you can do an analysis of the majority contribution for improvement.

FAQ:

The Pareto chart is one of the commonly used 7 QC tools in manufacturing industries.

Similar Articles:

Histogram Example | Foundry Industries Examples.

Histogram Template with example | Download.

How to plot Histogram in Excel (Step by step guide with example)

SPC Format |DOWNLOAD Excel Template of SPC Study

7QC Tools for Problem Solving | What are 7 QC Tools

Root Cause Analysis | 8 Steps of RCA

More on TECHIEQUALITY

Thanks for reading…Keeps Visiting Techiequality.Com

Popular Post:

Fishbone Diagram Template With Example

Fishbone Diagram Template

Fishbone Diagram Template With Example | Download Template

Download the Fishbone Diagram Template by clicking on the below link. Fishbone Diagram will help you to represent the Potential Causes of a Problem.

DOWNLOAD the Cause & Effect Diagram / Fishbone Diagram.

How to Use Fishbone Diagram Template:

Fishbone Diagram Template

[Figure-1]

Step-1: Download the Fishbone Diagram Template (Link is given at the top)

Step-2: Enter the Name of the Problem in the Red Highlighted Box, marked in the Excel template (e.g. refer to the above Figure-1 for easy understanding)

Step-3: Identify and then enter the Potential causes in the Sky color box in the Excel template under Man, Machines, Material, Method, Measurement, and Environment. 

How to Identify the Potential Causes of a Problem:

Step-1: To make a CFT Team (Cross-Functional team). Members of CFT should be from different and different processes/areas or departments. E.g. someone from production, Quality, technical, R&D, Maintenance, etc.

Step-2: Individually identify the Causes through Brainstorming.

Step-3:  Before you identify the causes by all team members, you have to list up all causes without any repetition. Next, all members of the team should sit together to identify the new causes through Brainstorming. And finally, do the list up of all causes identify by individual and team.

Step-4: Represent all potential causes in the Cause and Effect Diagram Template or Fishbone Diagram Template or Ishikawa Diagram Template.

Step-5: Identify the Significant Causes with the help of Hypothesis testing.

Step-6: Do the Root cause analysis with the help of Why- why Analysis to identify the Root Cause

Step-7: Take Corrective and Preventive Action on the Root cause.

Example-1: Casting Shrinkage Problem.

I have taken a Problem from the Iron casting Process as Shrinkage. Here I need to represent the Potential causes of Shrinkage in the Fishbone Diagram Template or Cause and Effect Diagram Template or the Ishikawa Diagram template. First of all, I made a CFT team considering the members from the production process, quality, Development, and Maintenance Department.

Instructed all members to identify the Potential cause relevant to their work function in individually through Brainstorming. Next, collect all Potential causes. And then call a meeting for further identification of Causes together with all members through Brainstorming. List up all Causes and represent those in the Fishbone Diagram Template, just like the below figure.  

Fishbone Diagram Example
Example-2: Casting Blow-hole Problem:

Below are the potential causes that may cause the blow-hole problem in raw casting products;

  • Improper manual core spray.
  • Improper manual mould spray.
  • Unskilled operators.
  • Core curing time is not validated w.r.t season.
  • Core curing m/c burner problem.
  • LP gas regulator issue.
  • Electric heater -heating issue.
  • Mould spray gun damage.
  • No deslagging.
  • Wet core used.
  • Low permeability.
  • Extremely high sand strength.
  • No venting system.
  • High moisture.
  • Core used without treatment.
Fishbone Diagram Template
Benefits of Fishbone Diagram:
  • It represents and displays the relationship of potential causes w.r.t Problem: – All Possible causes will represent them under which category among the man, machines, method, measurement, material, and environment.
  • Accumulate the possible Reasons in a single diagram: – It will be very difficult to resolve the problem without any idea of the Possible or Potential causes of any problem. So this diagram will show you all the causes simultaneously.
  • Involvement in Brainstorming: – It will help you to boost and structure the brainstorming to identify the possible causes or reasons.
  • It will help you to maintain the team focus to achieve the common goal: – As you know the team mission is to achieve the common goal means to identify the possible causes or reasons. All team members will identify the Causes or Reasons individually and together in a team to list-up the possible causes.

How to plot Ishikawa or cause and effect diagram of customer complaint:

first of all, download the cause and effect diagram template or Ishikawa diagram template from the given above link (at the top) and then follow the below steps. As per my own experience regarding the preparation of cause and effect diagrams related to customer complaints. at first, when I received a customer complaint, I just tried to understand the nature and type of problem and immediately called for a meeting for initial problem understanding with team members. Once it’s understood by all the team members, then we form a special team for 8D or CAPA formation.

Before doing the why-why analysis we have to identify the potential causes by using popular tools i.e. fishbone or cause & effect or Ishikawa diagram. To do so, the individual team members should identify the potential cause w.r.t customer complaints, Once you collect the all identified potential causes by individual members, then you have to plot the final fishbone diagram to keep in your mind with the repeated potential causes. when you choose to form the team at that time members should be in CFT of that process where the customer problem is related.

More on TECHIEQUALITY