Limited Time Offer: Save 10% on all 2021 and 2022 Premium Study Packages with promo code: BLOG10    Select your Premium Package »

Data Types

Data Types

In this reading, you will learn about the tools and techniques used to organize, visualize, and describe data. In addition, you will learn how to convert data into useful information that analysts can use to make important investment decisions.

Data Types

Data refer to a collection of facts such as numbers, characters, measurements, observations, audios, and videos.  Data can either be raw or formatted. Futher, data can be classified as follows:

  1. Numerical versus categorical data.
  2. Cross-sectional versus time-series versus panel data.
  3. Structured versus unstructured data.

Numerical versus Categorical Data

Numerical data represent values that can be measured or counted. Examples of numerical data include age, height, weight, or the number of shares in a portfolio.

Numerical (quantitative) data can further be classified into two types: continuous data and discrete data.

  • Continuous data are data that can be measured on an infinite scale. Such data can take any numerical value in a specified range of values, no matter how small. Examples include measures of temperature (25.5 degrees Celsius), height (1.81 meters), length (25.256 meters), etc.
  • Discrete data refer to quantitative data that can be counted and have a finite number of possible values. For example, days in a week (7 days), number of employees in a company (3 employees — we cannot have 3.5 workers).

Categorical data (also called qualitative data) represent qualitative outcomes (i.e., quality or characteristic) of a group of observations. The groups are mutually exclusive. This means that each individual fits only into one category. Examples of categorical data include investment style (i.e., growth vs. value stock), or investment-grade and junk bonds.

Categorical data are split into the following two types:

  • Nominal data are categorical values that have no inherent numerical significance as they do not rank data. A good example would be gender representation, e.g., 1 to represent ‘male’ and 2 to represent ‘female.’
  • Ordinal data are categorical values that rank data according to some characteristic where each category has an ordered relationship to all the other categories. Although ordinal scales can rank data in some order, the magnitude of the difference in categories cannot be quantified or measured. A good example is a rating scale from 1 to 3, where 1 represents ok, 2 represents good, and 3 represents excellent. Although ordinal data can be ranked or ordered, they do not necessarily indicate a numerical difference between them.

Cross-sectional versus Time-series versus Panel Data

Data can be classified into cross-sectional, time-series, and panel data depending on the data collection method employed.

  • Cross-sectional data refer to a set of observations made at a point in time. Samples are constructed by simultaneously collecting the data of interest across a range of observational units — people, objects, firms, etc. A good example of cross-sectional data can be the stock returns earned by shareholders of Microsoft, IBM, and Samsung in the year ended, 31st December 2021.
  • Time-series data refer to a set of observations made over a given period of time at specific and equally-spaced time intervals. That the observations are made at specific points in time shows that time intervals are discrete. A good example of time-series data could be the daily or weekly closing price of a stock recorded over a period spanning 13 weeks. Other appropriate examples could be the set of monthly profits (both positive and negative) earned by Samsung between the 1st of October 2021 and the 1st of December 2021.
  • Panel data comprise a combination of time series data and cross-sectional data. An Example of panel data can be studying the GDP of three developing countries for a period spanning three years, from 2019 to 2021.

A variable is a characteristic or quantity that can be measured, counted, or categorized and is subject to change. A variable can also be called a field, an attribute, or a feature. For example, stock price, market capital­ization, dividend and dividend yield, earnings per share (EPS), and price-to-earnings ratio (P/E) are basic data variables for the financial analysis of a public company.

An observation is the value of a specific variable collected at a point in time or over a specified time period. For example, last year DEF Inc. recorded an EPS (earnings per share) of $7.50 — this could be our first observation related to the EPS variable. That value represented a 15% annual increase — this could be our second observation.

Structured versus Unstructured Data

Structured data are organized in any pre-defined manner (i.e., rows and columns), and there is a relationship between different rows and columns. Since it is highly organized and formatted, it is easy to access, process, and store. It can work easily with most standard analytical models. Typical examples of structured com­pany financial data include:

  • Market data: For example, daily trading yields of a bond, daily closing stock prices, bond prices, and trading volumes.
  • Fundamental data: Data available in the financial statements, i.e., earnings per share, dividend per share, and gross margins.
  • Analytical data: Data derived from analytics, i.e., forecast operating profit growth, forecast cashflow from operations.

Unstructured data are not organized in any pre-defined manner. They can be textual, numbers, dates, etc. Examples of unstructured data include financial news, posts on social media, company filings with the regulator, audio or video recordings, etc. Due to irregularities and disorganization within unstructured data, they are difficult to handle and understand. Unstructured data are usually collected from unconventional sources. Based on the source from which the unstructured data are sourced, they can be classified into the following three groups:

  1. Produced by individuals (i.e., via social media posts, web searches, etc.).
  2. Generated by business processes (i.e., via credit card transactions, corporate regulatory filings, etc.).
  3. Generated by sensors (i.e., via satellite imagery, foot traffic by mobile devices, etc.).

Example: Data Types

Identify the data type for each of the following items:

  1. Stock returns earned by shareholders of Microsoft, IBM, and Samsung as for the year ended 31st December, 2020.
  2. Price change of a stock.
  3. Number of students in a class.
  4. Color of a smartphone.
  5. Grades of a student in a quiz.

Solution

  1. Cross-sectional data: Stock returns earned by shareholders of Microsoft, IBM, and Samsung as for the year ended 31st December 2020.
  2. Continuous data: Price change of a stock.
  3. Discrete data: Number of students in a class.
  4. Nominal data: Color of a smartphone.
  5. Ordinal data: Grades of students in a quiz.

Question

Which of the following is most likely panel data?

  1. Yearly remittances of five countries from Asia for the past 10 years.
  2. Customers’ online comments regarding the quality of a product of a company.
  3. Monthly profits earned by a company from 1st of July 2019 to 30th of June 2020.

Solution 

The correct answer is A.

Remember that panel data are a mix of time-series and cross-sectional data. Panel data consist of observations through time on one or more variable(s) for multiple observational units. The observations in panel data are usually organized in a matrix format called a data table.

Therefore, yearly remittances of five countries from Asia for the past 10 years qualify to be referred to as panel data.

B is incorrect. Customers’ online comments regarding the quality of product of a company qualify to be referred to as structured data.

C  is incorrect. Monthly profits earned by a company from 1st of July 2019 to 30th of June 2020 are examples of time series data.

Featured Study with Us
CFA® Exam and FRM® Exam Prep Platform offered by AnalystPrep

Study Platform

Learn with Us

    Subscribe to our newsletter and keep up with the latest and greatest tips for success
    Online Tutoring
    Our videos feature professional educators presenting in-depth explanations of all topics introduced in the curriculum.

    Video Lessons



    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.