Name all levels of Bloom’s taxonomy from lowest to highest:
Remember, Understand, Apply, Analyze, Evaluate, Create
Name the four stages of the AMPS model:
Ask, Master, Perform, Share
What does ‘EDGAR’ stand for?
Electronic Data Gathering, Analysis, and Retrieval
What are the four types of analytics?
Descriptive, Diagnostic, Predictive, Prescriptive
Name the four V’s of Big Data:
Volume, Velocity, Variety, Veracity
Name two types of numerical data that might be used in accounting analytics, but are not from accounting systems:
Stock prices and economic indicators (e.g., interest rates or inflation rates).
Name three common SEC filings required for public companies:
10-K (annual), 10-Q (quarterly), 8-K (significant events)
Name four sources of accounting data:
Financial statements, journals and ledgers, managerial accounting reports, tax systems
Name the two major types of data and their sub-types:
Categorical (Nominal, Ordinal) and Numerical (Interval, Ratio)
What is a subledger? How is it related to a general ledger?
A subledger is a detailed record supporting a general ledger account.
Give an example of a number being used as categorical data:
An employee ID number.
In Excel, if you drop categorical data into the ‘values’ field of a pivot table, it will default to displaying it as what?
Count
Fahrenheit is an example of _______ data and Celsius temperature scales are an example of _______ data.
Interval data and interval data.
What is ‘data about data’ called?
Metadata (or a data dictionary).
A relational database is composed of ________, and these can be described as having _____________ and ___________.
Tables with fields (columns) and records (rows).
What is an E-R diagram and where might you find one?
An Entity-Relationship diagram shows relationships between entities and is used in database design.
What two terms refer to the connections within a relational database?
Primary keys and foreign keys.
In SQL, what two commands are in every query?
SELECT and FROM.
In Excel, what formula is used to link two worksheets?
VLOOKUP or XLOOKUP.
What is a Z-score and how do you calculate it?
Z = (X - μ) / σ
Give one question that goes with each of the four types of analytics:
Descriptive – How much did we pay in federal taxes last year?; Diagnostic – Why did labor costs increase?; Predictive – What is the chance the company will go bankrupt?; Prescriptive – Should we outsource production?
Classification, regression, and time series are most often used in what kind of analytics?
Predictive analytics.
The purpose of regression is to find the _____________ between ______________ and ______________ variables.
Relationship between independent and dependent variables.
If the alpha of a statistical test is set at 0.05, and the p-value is 0.003, should the null hypothesis be accepted or rejected?
Rejected, because p < α.
