Creating a side-by-side chart in
Excel:
1. Choose your data
2. Insert -> Charts -> Clustered Column
Selecting more than one series (groups
of data) will automatically prompt Excel to create a side-by-side bar (column)
chart
When we want to represent two numerical variables
on the same graph, we usually use a scatter plot. Scatter plots are useful especially later on, when we talk about regression analysis, as they help us detect patterns (linearity, homoscedasticity).
Scatter plots
usually represent lots and lots of data. Typically, we are not interested in single
observations, but rather in the
structure of the dataset.
plot in Excel:
1. Choose the two
datasets you want to plot.
2. Insert -> Charts -> Scatter
A scatter
plot that looks in the following way (down) represents data that doesn’t
have a pattern. Completely
vertical ‘forms’ show no association.
Conversely, the plot above shows a linear pattern, meaning that the observations move together.
