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.

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.

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.

**How to do it in Excel**

**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.

**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.