how to make a pie chart in excel with categorical data

A mosaic plot is another name for a grouped bar chart where the bars are stacked on top of each other. Grouped pie charts and grouped bar charts graphically display the data within contingency tables. By comparing the conditional and marginal distributions, we can see how hair color differs between the two genders. The conditional distribution of hair color for women is 47% blonde/53% brunette (considering only the 17 subjects in the “female” column), while the conditional distribution of hair color for men is 36% blonde/67% brunette (considering only the 11 subjects in the “male” column). The marginal distribution of hair color is 43% blonde/57% brunette because, of the 28 total subjects in this dataset, 12 had blonde hair and 16 had brown hair. The marginal distribution is the overall distribution of one variable, ignoring the other.įor example, consider the following contingency table: A conditional distribution is the distribution of one variable given that the other variable equals some value.

When describing the relationship between two categorical variables, it is important to investigate the differences between the conditional and marginal distributions of the variables. They can be used to show how different the distribution of one variable is across the values of the other.Ĭontingency tables, also known as two-way tables, contain the frequency of responses for every combination of values across two categorical variables. Contingency tables, grouped pie charts, and grouped bar charts display the distributions of two categorical variables and how they relate to each other.

How to make a pie chart in excel with categorical data