Quick Way of Segmentation in Univariate Analysis of Excel

In the last lecture, you learnt the process of segmentation. But, what if you have a large number of variables in your dataset. It is a very repetitive task to perform the same analysis on the large bunch of variables. One way of solving this problem is to make a table with the categorical variables on one axis and the numeric variables (or measures/facts) on the other. Let’s see what such a table would look like.

Once you are done with segmentation, the next step is to compare your results within the category. You can either compare the means, or you can go for other descriptive statistics such as median, max, min, etc. We will discuss this in the next lecture.