CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation
A dataset records the month-end closing price of a share for 12 months, in time order, for trend analysis. Which classification of data organisation best describes it?
The data is time-series data, because one variable, the share's closing price, is observed at successive month-ends in chronological order. Cross-sectional data would instead compare many entities at one point in time.
- ACross-sectional data
- BTime-series dataCorrect
- CNominal categorical data
- DUnstructured data
Explanation
Observations of one variable recorded at successive time points form a time series. Cross-sectional data would capture many entities at a single point in time, for example the prices of 12 different shares on one date. The data is numeric and tabular, so it is neither nominal nor unstructured.
Did you get it right without looking?
One question tells you little. A timed set on Data Processing, Organisation, Cleaning and Validation shows your real accuracy, how long you take and where you lose marks.
More Data Processing, Organisation, Cleaning and Validation questions
- Two tables are to be integrated: a customer master with 500 unique customer IDs and a transactions table with 2,000 rows, each carrying one …
- Which situation most clearly requires real-time processing rather than batch processing?
- A company records revenue figures in two source systems. System A reports in rupees and System B reports in rupees lakh. Before merging, Sys…
- In a payroll file, the 'Date of Joining' column holds dates in mixed formats such as 05/03/2021, 2021-03-05 and 5 March 2021. Which data qua…
- A company keeps its sales invoices in a table where Invoice No. is unique for each row. A separate Customer table has Customer ID as its uni…
- A finance team receives sales data in which the 'Region' column holds 'North', 'north' and 'NORTH ' (with a trailing space) for the same reg…