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

How to Plot Scatter Diagram in Excel? | Guides with example | Interpretation

How to Plot Scatter Diagram in Excel

 How to Plot Scatter Diagram in Excel |Guides with example | Interpretation:

Hi reader! Today we will discuss on How to Plot Scatter Diagram in Excel? The scatter diagram is a type of tool that is generally used to know the correlation between two variables. We have published a separate post on the concept of scatter diagrams with industrial examples and interpretation of results, if you are interested in knowing the concept before reading this article then you may read more, the link is provided below.

Scatter Diagram Template |Industrial Example |Download Excel Format.

How to Plot Scatter Diagram in Excel?

We would like to explain it with examples.

Example:

A class teacher tried to survey their top five students’ marks obtained in % v/s study hours. Details of the data are given below.

Variable-1 Variable-2
Study hours Mark obtained in %
5 40
6 50
7 65
8 82
10 89

Now class teacher has drawn the scatter diagram to know the correlation between variables. Step by step guide is mentioned below;

Step-1:

Open the excel sheet and make a table.

process-1

Step-2:

Select the table to plot the diagram.

process-2

Step-3:

Choose the pattern of the Scatter diagram as you wish, To do so first go to the option “Insert” and then select the scatter diagram option with your preferred pattern. Details are mentioned in the below figure.

Scatter Diagram process

Step-4:

Now, your Scatter Diagram is ready.

How to Plot Scatter Diagram in Excel

Interpretation of the above scatter diagram:

All sample points are nearer to the trend line and in a positive direction. So the scatter diagram indicates us there is a perfect positive correlation between two variables. Read more…to know more about common possibilities of correlation.

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