What type of data is contained in the following spreadsheet?EmployeeMonthSalesT. Marks1/22$30,928T. Marks2/22$26,989T. Marks3/22$28,760W. Bungee1/22$45,002W. Bungee2/22$39,726W. Bungee3/22$36,0111 分UnstructuredLongTallWide
Question
What type of data is contained in the following spreadsheet?EmployeeMonthSalesT. Marks1/2226,989T. Marks3/2245,002W. Bungee2/2236,0111 分UnstructuredLongTallWide
Solution
The spreadsheet contains structured data. It is organized in a tabular format with clear rows and columns. The data types include:
-
Text/String: This is seen in the 'Employee' column which contains the names of the employees.
-
Date/Time: This is seen in the 'Month' column which contains the month and year.
-
Numeric: This is seen in the 'Sales' column which contains the sales figures for each employee for each month.
The data is also wide, as it contains different types of data (names, dates, and numbers) across multiple columns.
Similar Questions
What type of data is contained in the following spreadsheet?CustomerYearSpend100482023$593100482022$719100482021$488299012023$1,045299012022$992299012021$1,180
Employee data from Human Resource Information System is an example of which one of the following data Type? A. Big data B. Small data C. Structured data D. Unstructured data
Question 1What data type is typically found in databases and spreadsheets?1 pointSocial media contentStructured dataSemi-structured dataUnstructured data
Different types of data
Question 7What do the columns contain in long data?1 pointSpecific constraintsThe values and the context for the valuesThe data typesDifferent formats
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.