Solution Manual For Data Analytics for Accounting, 3rd Edition Richardson

Richardson, Teeter, Terrell – Data Analytics for Accounting, 3e mq mq mq mq mq mq mq mq




SOLUTION MANUAL FOR m q m q




Data Analytics for Accounting, 3rd EditionRichardson Chapter
mq mq mq mq mq mq mq




mq 1-9
SolutionsManual –Chapter 1 m
q mq m
q mq




Solutions to Multiple Choice Questions
mq mq mq mq




1. (LO 1-1) Big Data is often described by the four Vs, or
mq mq mq mq mq mq mq mq mq mq mq




a. volume, velocity, veracity, and variability.mq mq mq mq




b. volume, velocity, veracity, and variety. mq mq mq mq




c. volume, volatility, veracity, and variability.
mq mq mq mq




d. variability, velocity, veracity, and variety. mq mq mq mq




Answer: b mq




2. LO 1-4) Which data approach attempts to assign each unit in a population into a small set of
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




classes (or groups) where the unit best fits?
mq mq mq mq mq mq mq mq




a. Regression
b. Similarity matching mq




c. Co-occurrence grouping mq




d. Classification

Answer: d mq




3. (LO 1-4) Which data approach attempts to identify similar individuals based on data known
mq mq mq mq mq mq mq mq mq mq mq mq mq




about them?
mq mq




a. Classification
b. Regression
c. Similarity matching mq




d. Data reduction mq




Answer: c mq




4. (LO 1-4) Which data approach attempts to predict connections between two data items?
mq mq mq mq mq mq mq mq mq mq mq mq




a. Profiling
b. Classification
c. Link prediction mq




d. Regression




1

, Richardson, Teeter, Terrell – Data Analytics for Accounting, 3e mq mq mq mq mq mq mq mq




Answer: c mq




5. (LO 1-6) Which of these terms is defined as being a central repository of descriptions for all of the
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




data attributes of the dataset?
mq mq mq mq mq




a. Big Data
mq




b. Data warehouse mq




c. Data dictionarymq




d. Data Analytics mq




Answer: c mq




6. (LO 1-5) Which skills were not emphasized that analytic-minded accountants should have?
mq mq mq mq mq mq mq mq mq mq mq




a. Developed an analytics mindset mq mq mq




b. Data scrubbing and data preparation
mq mq mq mq




c. Classification of test approaches mq mq mq




d. Statistical data analysis competency mq mq mq




Answer: c mq




7. (LO 1-5) In which areas were skills not emphasized for analytic-minded accountants?
mq mq mq mq mq mq mq mq mq mq mq




a. Data quality mq




b. Descriptive data analysis mq mq




c. Data visualization and data reporting
mq mq mq mq




d. Data and systems analysis and design
mq mq mq mq mq




Answer: d mq




8. (LO 1-4) The IMPACT cycle includes all except the following steps:
mq mq mq mq mq mq mq mq mq mq




a. perform test plan. mq mq




b. visualize the data. mq mq




c. master the data. mq mq




d. track outcomes. mq




Answer: b mq




9. (LO 1-4) The IMPACT cycle specifically includes all except the following steps:
mq mq mq mq mq mq mq mq mq mq mq




a. data preparation.
mq




b. communicate insights. mq




c. address and refine results. mq mq mq




d. perform test plan. mq mq




2

, Richardson, Teeter, Terrell – Data Analytics for Accounting, 3e mq mq mq mq mq mq mq mq




Answer: a mq




10. LO 1-1) By the year 2024, the volume of data created, captured, copied, and consumed
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




worldwide will be 149
mq mq . mq mq mq




a. zettabytes
b. petabytes
c. exabytes
d. yottabytes

Answer: a mq




Solutions to Discussion and Analysis Questions
mq mq mq mq mq




1. The accounting function is one of being an information provider. To the extent that data is
mq mq mq mq mq mq mq mq mq m q mq mq mq mq mq




available to address accounting questions, be they tax, managerial, audit or financial questions.
mq mq mq mq mq mq mq mq mq mq mq mq mq




With such rich available data, and software tools to prepare and analyze the data, data analytics will
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




continue to be an important tool for accountants to use.
mq mq mq mq mq mq mq mq mq mq




2. Data analytics is defined as the process of evaluating data with the purpose of drawing
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




conclusions to address business questions. Indeed, effective Data Analytics provides a way to
mq mq mq mq mq mq mq mq mq mq mq mq mq




search through large structured and unstructured data to identify unknown patterns or
mq mq mq mq mq mq mq mq mq mq mq mq




relationships.
mq




A university might learn from the analyzing the demographics of its current set of students in order
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




to attract its future student recruits. Did they come from cities or high schools that were close by?
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




Were their parents alumni of the university? Did they score high on certain parts of the ACT? Were
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




those offered a scholarship more likely to attend, etc.? Was social media effective in attracting
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




new, potentially stronger students? By analyzing this type of data, previously unknown patterns
mq mq mq mq mq mq mq mq mq mq mq mq mq




will emerge that will make recruiting students more effective.
mq mq mq mq mq mq mq mq mq




3. There are many potential answers. For example, Monsanto may use mathematical and
mq mq mq mq m q mq mq mq mq mq mq




statistical models to plot out the best times to plant both male and female plants and where to
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




plant them to maximize yield. (https://www.cio.com/article/3221621/analytics/6-data-
mq mq mq mq mq mq




analytics-success-stories-an-inside-look.html#tk.cio_rs)
mq




4. There are many potential answers. Data analytics gives both internal and external auditors
mq mq mq mq mq mq mq mq mq mq mq mq




additional tools to examine every accounting transaction and assess for compliance with GAAP.
mq mq mq mq mq mq mq mq mq mq mq mq mq




The audit process is changing from a traditional process toward a more automated one, which will
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




allow audit professionals to focus more on the logic and rationale behind data queries and less on
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




the gathering of the actual data. No longer will they be simply checking for errors, material
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




misstatements, fraud, and risk in financial statements or merely be reporting their findings at the
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




end of the engagement. Instead, audit professionals will now be collecting and
mq mq mq mq mq mq mq mq mq mq mq mq




3

, Richardson, Teeter, Terrell – Data Analytics for Accounting, 3e mq mq mq mq mq mq mq mq




analyzing the company’s data similar to the way a business analyst would help management make
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




better business decisions. In this way, data analytics offers value to the audit function.
mq mq mq m q mq mq mq mq mq mq mq mq mq mq




5. There are many potential answers. For example, data analytics associated with financial
mq mq mq mq mq mq mq mq mq mq mq




reporting may help accountants determine if any of their inventory obsolete? It may also help the
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




company benchmark on the financial statements and financial reporting of other similar
mq mq mq mq mq mq mq mq mq mq mq mq




companies and understand their accounting practices to help infer their own.
mq mq mq mq mq mq mq mq mq mq mq




6. Management accountants address the information needs of management. They will often see mq mq mq mq mq mq mq m q mq mq mq




what questions management has, find applicable data to address those questions, conduct
mq mq mq mq mq mq mq mq mq mq mq mq




analysis of the data, and report the results to management to help them make data-driven
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




decisions. This is consistent with the data analytics process and the IMPACT model.
mq m q mq mq mq mq mq mq mq mq mq mq mq




7. The IMPACT cycle suggests an order of 1) Identifying the Questions; 2) Mastering the Data; 3)
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




Performing the test plan; 4) Addressing and refining results; 5) Communicating insights and 6)
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




Tracking outcomes. The cycle starts with a question and then identifying data and test plan that
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




might address that question. The results of the data analysis are communicated and tracked
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




which may lead to additional, possibly more refined questions that then restart the cycle.
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




8. Data analysis is most effective when a question is identified that needs to be addressed. That will
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




focus the analysis on which data and which test method might be most effective in addressing
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




or answering the question.
mq mq mq mq




9. Mastering the data requires one to know what data is available and whether it might be able to mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




help address the business problem. We need to know everything about the data, including how to
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




access it, its availability, how reliable it is (if there are errors), and what time periods it covers to
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




make sure it coincides with the timing of our business problem, etc.
mq mq mq mq mq mq mq mq mq mq mq mq




10. Facebook uses link prediction to predict a relationship between two people when it suggests
mq mq mq mq mq mq mq mq mq mq mq mq mq




people that one likely knows due to similar other friends, extended family, high schools, college or
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




work locations, etc.
mq mq mq




11. While sampling is useful, it is still just that, sampling. By looking at all of the transactions and testing
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




them in a way that will highlight the ones that are the biggest dollar items, or are most unusual,
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




that will allow auditors to focus on specific items that might be of material significance.
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




12. There are several correct answers. One data approach might be regression analysis where, given a
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




balance of total accounts receivable held by a firm, how long it has been outstanding, if they have
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




paid debts in the past all will help predict the appropriate level of allowance for doubtful accounts
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




for bad debts.
mq mq mq




13. The Debt-to-Income ratio might suggest to LendingClub that the person asking for the loan was
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




simply asking for too big of a loan and they would have little ability to repay it. The lower the credit
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




score, the less likely the potential borrower would be able to repay the loan.
mq mq mq mq mq mq mq mq mq mq mq mq mq mq




14. There are many other potential predictors of whether the LendingClub would pay a loan. Here are
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




a few possibilities: What other debt do they have? How much is their disposable income? Do
mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq mq




4