Comparison of Other Metrics in Segmented Univariate Analysis Using Excel

Once you have identified the variables based on the business problem for analysing the segments, the next step is to know the distribution of segments and compare the average of each segment. But this is not the only way of comparing segments. There are various metrics that you can use to understand and explain your data easily.

Let's see how Anand compares the other metrics.

So far in this session, you have learnt new metrics, concepts and techniques for performing segmented univariate analysis on the variables based on business understanding. In conclusion, the three steps of segmented univariate analysis are as follows:

• Basis of segmentation

• Comparison of averages

• Comparison of other metrics

Besides finding the segments and comparing the metrics, your primary focus should be on understanding the results arising from the segments.

You can go through this link to understand how to read a box plot.

So, this is all about analysing the variables one at a time. But what if you want to analyse more than one variable at the same time? How would you find the relationship between two variables? We will take this up in the next session.