Acct 3007 ch3
_______________ data tend to classify items represented by words, such as identifying a group of people by gender (male, female, nonbinary), labeling transaction types (sales vs. returns) or ordering outcomes.
Categorical
True or false: Eye color is an example of ordinal data.
False
True or false: Product price for an Amazon product is an example of a calculated variable.
False
______ data is so named because there is an equal distance between two observations.
Interval
____________ data is categorical data that cannot be ranked.
Nominal
____________ data includes both interval data and ratio data.
Numerical
_____ are one of the best methods for summarizing many types of raw data in Excel.
Pivottables
_______________ help run summary statistics quickly and provide the flexibility to explore data and interact with it based on the results through analysis without modifying the data.
Pivottables
True or false: Databases and other statistical analysis tools use more than the four data types to categorize data.
True
True or false: Sometimes we need to reformat structured data to make it more useful.
True
Since average customer rating is computed each time a product is displayed in Amazon, it is an example of a _____ variable.
calculated
Data regarding inventory being in stock is an example of _____ data.
categorical
Proportions are used to summarize _____ data.
categorical
The asset description from a fixed asset ledger is an example of __________ data
categorical
In a data dictionary, product price is an example of the _____ data type.
currency
A data __________ is a centralized repository of information about a set of data.
dictionary
The numerical data type that has a meaningful distance between observations uses a(an) _____ scale.
interval
The results of an IQ (intelligence quotient) test is an example of ____ data.
interval
Categorical and _____ data make up the two major data types.
numerical
Product price is an example of _____ data.
numerical
The net book value of each asset from a fixed asset ledger is an example of ____________ data.
numerical
Examples of _____ data include blue, red, and yellow ribbons awarded at the state fair.
ordinal
Ranking is associated with ___________ data.
ordinal
Ranking is associated with_____________data.
ordinal
The data type that ranks, or orders, items is called the ___________ data type.
ordinal
Transactions categorized as the date of sales or returns are examples of _____________ data types.
ordinal
Calculating the ______________ of sales to returns each day for a retail organization is an example of summarizing ordinal data.
proportion
Ordinal data is summarized by counting and grouping, proportions and__________
ranking
The average time outstanding for a company's accounts receivable is an example of which type of data?
ratio data
The height of each basketball player on a team is an example of which type of data?
ratio data
The data dictionary contains a separate _____ for each field (or variable).
record
Ranking used as a means of summarizing ordinal data refers to a position on a____________
scale
In string, short text, or alphanumeric data type, the data can be made up of ______.
several different data types
In a data dictionary, product name is an example of the _____ data type.
short text
In a data dictionary, transaction ID, a unique identifier for each transaction is an example of the _____ data type.
short text
In a data dictionary, transaction type, whether it be the sale of a product or return of the product, is an example of the _____ data type.
short text
____________ data tends to be text data without internal organization.
unstructured
