Scatter Diagram

One of the Quality Monitoring tools – A scatter diagram is a two-dimensional chart that shows the relationship between two variables. It is also called a scatter plot or scatter graph. The diagram shows how each value on the vertical axis (Y) is correlated to another value on the horizontal axis (X); used to visualize the correlation between one independent and one dependent variable.

Scatter Diagram tool 4 final_page-0003

Correlation – Correlation is a statistical term for the relationship between two variables. Types of Correlation are Positive, Negative, and No Correlation

  • Positive correlation means that as one variable increases, the other variable increases at the same rate.

 

  • Negative correlation means that as one variable increases, the other variable decreases at the same rate.
  • No correlation means that there is no relationship between the two variables.
1200px-Circle_arrow_down_font_awesome.svg-64x64

We also calculate the R-squared value to measure the correlation between two variables. The value of R-squared can range from 0 to 1, which explains the degree to which your input variables explain the variation of your output / predicted variable. So, if R-squared is 0.8, it means 80% of the variation in the output variable is explained by the input variables. the higher the R-squared, the better the model fits your data.

In simple terms, it represents how much of a change in one variable causes a change in another.

For example, if you have two variables (say X and Y) and you know that they are strongly correlated then it would be reasonable to assume that most of the variation in X can be predicted by knowing Y.

1200px-Circle_arrow_down_font_awesome.svg-64x64
Scatter Diagram tool 4 final_page-0004

How to do it in Excel

Scatter Diagram tool 4 final_page-0005

Example of Scatter Diagram (Prepare it on Excel) –

Let’s suppose we want to identify whether there is any relation between the Call Quality score and the agent’s age on network (AON). So now, we will figure it out through a Scatter Diagram.

1200px-Circle_arrow_down_font_awesome.svg-64x64

Step 1

 

  • Collect AON and CQ for each agent in the process or map AON-wise CQ for each agent.

Step 2

  • Select the data range and click on Insert -> Scatter Diagram

Step 3

 

  • Click on the graph, for adding chat elements. Check the “Trendline” box.

Step 4

  • Then Click on the trendline -> Right Click -> Format Trendline -> check the box for adding equation on chart and displaying the R-squared value on chart.

Eventual Outcome

  • In this example, by looking at the trendline and R-squared value, we can say that the relation between AON and the CQ score is positive – the CQ score increases along with the AON.
Scatter Diagram tool 4 final_page-0010