Data Visualization

Data Visualization

Data visualization refers to the presentation of data in a pictorial or graphical format using different graphs such as histograms, polygons, line charts, bar charts, etc.

Histogram

A histogram is a graphical representation of the data contained in a frequency distribution. It is a bar chart of data that groups data into intervals. The intervals should capture all the data points, and, in addition, the intervals should not overlap. A histogram is constructed by plotting intervals on the horizontal axis and the absolute frequencies on the vertical axis.

If a histogram has equal size intervals, a rectangle should be erected over it, with its height being proportional to the absolute frequency. If intervals are of unequal sizes, then the erected rectangle has an area proportional to the absolute frequency of that particular interval. In such a case, we would have the vertical axis labeled as ‘density’ instead of frequency. There should be no space between bars to indicate that the intervals are continuous.

Example: Histogram 

Consider the previous example of the returns offered by a stock. To bring you up to speed, these were the intervals and the corresponding frequencies:

$$
\begin{array}{c|c|c}
\text { Interval } & \text { Tally } & \text { Frequency } \\
\hline-30 \% \leq \mathrm{R}_{\mathrm{t}} \leq-20 \% & \text { II } & 2  \\
-20 \% \leq \mathrm{R}_{\mathrm{t}} \leq-10 \% & \text { I } & 1  \\
-10 \% \leq \mathrm{R}_{t} \leq 0 \% & \text { III } & 3 \\
0 \% \leq \mathrm{R}_{t} \leq 10 \% & \text { IIIII } & 6  \\
10 \% \leq \mathrm{R}_{t} \leq 20 \% & \text { IIIIII } & 7  \\
20 \% \leq \mathrm{R}_{t} \leq 30 \% & \text { IIII } & 5\\
30 \% \leq \mathrm{R}_{t} \leq 40 \% & \text { I } & 1  \\ \hline
\text { Total } & & 25 & =25 / 25=100 \%
\end{array}
$$

As mentioned earlier, histograms can also be created with relative frequencies—the choice of using either absolute or relative frequency depends on the question being answered. An absolute frequency histogram best answers the question of how many items are in each bin. In contrast, a relative frequency histogram gives the proportion or percentage of the total observations in each bin.

Frequency Polygon

A frequency polygon is used to represent the distribution of data graphically. However, there is a major difference between a frequency polygon and a histogram. Instead of having the class intervals on the horizontal axis clearly showing their upper and lower limits, a frequency polygon uses the midpoints of the class intervals where:

$$\text{Midpoint of a class interval}= \text{Lower limit}+\frac{\text{Upper limit-Lower limit}}{2}$$

The vertical axis features the absolute frequencies, which are then joined using straight lines and markers.

Example: Frequency Polygon

Going back to the stock return data, we could come up with a frequency polygon. To come up with the midpoints, we use the formula above. As an example, the midpoint of the interval -30% ≤ Rt ≤ -20% is:

$$ \text{Midpoint} = -30 + \cfrac {(-20 – – 30)}{2} = -25 $$

We can calculate the midpoints for the other intervals in a similar manner. The final frequency polygon should look like this:

The frequency polygon is important because it shows the shape of a distribution of data. It can also be very useful when comparing two sets of data side-by-side. Note that the endpoints touch the X-axis. The vertical scale can also be positioned at the left margin.

A cumulative frequency distribution graph can plot the cumulative frequency or relative frequency against the upper interval limit. The cumulative frequency distribution allows us to see how many or what percentage of the observations lie below a certain value. The figure below is an example of a cumulative frequency distribution.

As we move from one interval to the next, The change in the cumulative relative frequency represents the interval’s relative frequency. A steep slope of the cumulative frequency distribution indicates that the frequencies are large. It is pertinent to note that the slope of the cumulative absolute distribution at any particular interval is proportional to the number of observations in that interval.

Bar Chart

A bar chart is used to plot the frequency distribution of category-based data. In a bar chart, each bar represents a distinct category, while the height of a bar is proportional to the frequency of the corresponding category. Bar charts can be vertical or horizontal.

  • In a vertical (horizontal) bar chart, the y-axis (x-axis) represents the absolute or relative frequency.
  • In contrast, the x-axis (y-axis) represents the mutually exclusive categories to be compared rather than bins that group numerical data (unlike histogram).

cfa-level-1-bar-charts

Pareto Chart

A bar chart in which categories are ordered by frequency in descending order and has a line displaying cumulative relative frequency is known as a Pareto Chart. This chart is used to highlight dominant categories or the most important groups.

Grouped Bar Chart

A grouped bar chart (also known as a clustered bar chart) plots two category-based variables to represent their joint frequencies.

cfa-level-1-grouped-bar-chart

Stacked Bar Chart

A stacked bar chart also presents the joint frequency distribution of two cat­egory-based variables. In a vertically stacked bar chart, the bars representing the sub-groups are placed on top of each other to form a single bar. Each sub-section of the bar is shown in a different color to represent the contribution of each sub-group. Further, the stacked bar’s overall height represents the category’s marginal frequency.

cfa-level-1-stacked-bar-chart

Tree-map

A tree-map chart displays hierarchical data. A rectangular shape represents each item on a tree-map. It is critical to note that smaller rectangles represent the sub-groups. Further, there is a correlation between the color and size of rectangles and the tree structure. Equally worth noting is the fact that the area of each rectangle is proportional to the value of the corresponding group.

The tree-map below depicts the revenues of different companies in the food sector. We can observe that ABC Company has the highest revenue in the sector, represented by the rectangle with the largest area.

Word Cloud

A word cloud (also known as a tag cloud) is a visual representation of textual data. The size of each specific word is proportional to the frequency of words within a given body of text. We can use a different colors to convey different sentiments. For example, we can use green color to display profit. On the other hand, we can use red color to symbolize loss. A word cloud is generally used to display unstructured data.

Word Cloud

Line Chart

A line chart is used to display the change in data series over time. It’s important to note that both the frequency polygons and the cumulative frequency distribution charts are line charts, representing data frequency distributions. However, they do not display the change in data over time.

In a line chart, the x-axis represents the period (say years), while the y-axis represents the data we want to plot (say, the real GDP growth rate).

A line chart can be drawn using more than one set of data points, which can be used for comparisons.

Bubble Line Chart

In a bubble line chart, data points are represented by bubbles of various sizes. The bubbles represent the third dimension of data. These bubbles can be of different colors to represent additional information, i.e., red bubbles for negative values and green bubbles for positive values.

Scatter Plot

A scatter plot is a graph that shows the relationship between two numerical variables. It helps in displaying and understanding potential relationships between two variables. In a scatter plot, one variable is plotted on the x-axis and another, on the y-axis.

As shown above, a positive slope for a line of data points indicates a positive relationship between two variables, and vice-versa. The strength of the relationship between variables can be determined based on how closely the data points are clustered around the line. Tight clustering indicates a potentially stronger relationship. Further, data points located toward the ends of each axis represent the maximum or minimum values (i.e., outliers).

Scatter Plot Matrix

A scatter plot matrix is a grid of scatter plots used to visualize bivariate relationships between combinations of variables.

Heat Map

A heat map is a graphical representation of data that uses a system of color-coding to represent different values. More intense color is displayed as the marks “heat up” due to their higher values or density of records. Heat maps can display frequency distributions and visualize the degree of correlation among different variables.

Question

Which of the following most likely represents the graph drawn by connecting successive mid-points in a histogram by straight lines?

  1. Histogram.
  2. Frequency curve.
  3. Frequency polygon.

Solution

The correct answer is C.

When straight lines connect successive midpoints in a histogram, the graph is called a frequency polygon.

A is incorrect. A histogram is a graphical representation of the data contained in the frequency distribution but not using mid-points. Instead, a rectangle should be erected over the whole interval.

B is incorrect. When a frequency polygon is smoothed, a frequency curve is obtained.

Shop CFA® Exam Prep

Offered by AnalystPrep

Featured Shop FRM® Exam Prep Learn with Us

    Subscribe to our newsletter and keep up with the latest and greatest tips for success
    Shop Actuarial Exams Prep Shop Graduate Admission Exam Prep


    Sergio Torrico
    Sergio Torrico
    2021-07-23
    Excelente para el FRM 2 Escribo esta revisión en español para los hispanohablantes, soy de Bolivia, y utilicé AnalystPrep para dudas y consultas sobre mi preparación para el FRM nivel 2 (lo tomé una sola vez y aprobé muy bien), siempre tuve un soporte claro, directo y rápido, el material sale rápido cuando hay cambios en el temario de GARP, y los ejercicios y exámenes son muy útiles para practicar.
    diana
    diana
    2021-07-17
    So helpful. I have been using the videos to prepare for the CFA Level II exam. The videos signpost the reading contents, explain the concepts and provide additional context for specific concepts. The fun light-hearted analogies are also a welcome break to some very dry content. I usually watch the videos before going into more in-depth reading and they are a good way to avoid being overwhelmed by the sheer volume of content when you look at the readings.
    Kriti Dhawan
    Kriti Dhawan
    2021-07-16
    A great curriculum provider. James sir explains the concept so well that rather than memorising it, you tend to intuitively understand and absorb them. Thank you ! Grateful I saw this at the right time for my CFA prep.
    nikhil kumar
    nikhil kumar
    2021-06-28
    Very well explained and gives a great insight about topics in a very short time. Glad to have found Professor Forjan's lectures.
    Marwan
    Marwan
    2021-06-22
    Great support throughout the course by the team, did not feel neglected
    Benjamin anonymous
    Benjamin anonymous
    2021-05-10
    I loved using AnalystPrep for FRM. QBank is huge, videos are great. Would recommend to a friend
    Daniel Glyn
    Daniel Glyn
    2021-03-24
    I have finished my FRM1 thanks to AnalystPrep. And now using AnalystPrep for my FRM2 preparation. Professor Forjan is brilliant. He gives such good explanations and analogies. And more than anything makes learning fun. A big thank you to Analystprep and Professor Forjan. 5 stars all the way!
    michael walshe
    michael walshe
    2021-03-18
    Professor James' videos are excellent for understanding the underlying theories behind financial engineering / financial analysis. The AnalystPrep videos were better than any of the others that I searched through on YouTube for providing a clear explanation of some concepts, such as Portfolio theory, CAPM, and Arbitrage Pricing theory. Watching these cleared up many of the unclarities I had in my head. Highly recommended.