Question 1

All other things equal, in which of the following buckets would you expect the least amount of aged receivables to be?

Accepted Answer

A)  31-60 days 
B)  61-90 days 
C)  1-30 days 
D)  91-120 days 
A)  31-60 days 
B)  61-90 days 
C)  1-30 days 
D)  91-120 days

Question 2

If you have minimums and maximums that are far away (several standard deviations away from the mean) from the rest of the data observations, medians would be the best measure of central tendency?

Accepted Answer

A) True 
 B)False

Question 3

Which measure would help us evaluate what happens in the highest and lowest 20 percent of the data?

Accepted Answer

A)  Quintiles 
B)  Quartiles 
C)  Average 
D)  Deciles 
A)  Quintiles 
B)  Quartiles 
C)  Average 
D)  Deciles

Question 4

To compute the percentage change in a horizontal analysis from last year to this year, the computation will be:

Accepted Answer

A)  (Current Year - Last Year)/ Last Year. 
B)  (Last Year- Current Year)/ Last Year. 
C)  (Last Year- Current Year)/ Current Year. 
D)  (Current Year- Last Year)/ Current Year. 
A)  (Current Year - Last Year)/ Last Year. 
B)  (Last Year- Current Year)/ Last Year. 
C)  (Last Year- Current Year)/ Current Year. 
D)  (Current Year- Last Year)/ Current Year.

Question 5

While a __________ reorganizes and summarizes certain data using cross-tabulations without changing the underlying spreadsheet (or data), a __________ is a graphical depiction of those cross-tabulations.

Accepted Answer

A)  pivot chart; pivottable 
B)  pivottable; pivot chart 
C)  histogram; pivottable 
D)  graph; table 
A)  pivot chart; pivottable 
B)  pivottable; pivot chart 
C)  histogram; pivottable 
D)  graph; table

Question 6

Dupont analysis allows an analysis of profit margins, asset turnover and liquidity.

Accepted Answer

A) True 
 B)False

Question 7

An analysis which expresses financial information in relation to some relevant figure or base is called __________.

Accepted Answer

A)  Dupont analysis 
B)  vertical analysis 
C)  horizontal analysis 
D)  ratio analysis 
A)  Dupont analysis 
B)  vertical analysis 
C)  horizontal analysis 
D)  ratio analysis

Question 8

If the profit margin is 0.2158, asset turnover is 0.5389 and financial leverage is 1.2047, what is the return on equity?

Accepted Answer

A)  0.1401 
B)  0.6492 
C)  0.1163 
D)  0.5389 
A)  0.1401 
B)  0.6492 
C)  0.1163 
D)  0.5389

Question 9

The __________ provide details on the accounting policies chosen.

Accepted Answer

A)  management discussion and analysis section 
B)  footnotes 
C)  analyst report 
D)  financial statements 
A)  management discussion and analysis section 
B)  footnotes 
C)  analyst report 
D)  financial statements

Question 10

The Dupont Analysis measures which of these performance categories?

Accepted Answer

A)  Profitability, Liquidity, and Solvency 
B)  Profitability, Activity, and Solvency 
C)  Activity, Liquidity, and Solvency 
D)  Activity, Liquidity, and Profitability 
A)  Profitability, Liquidity, and Solvency 
B)  Profitability, Activity, and Solvency 
C)  Activity, Liquidity, and Solvency 
D)  Activity, Liquidity, and Profitability

Question 11

Descriptive analytic measures of central tendency include all except which of the following?

Accepted Answer

A)  Counts 
B)  Means 
C)  Medians 
D)  Modes 
A)  Counts 
B)  Means 
C)  Medians 
D)  Modes

Question 12

Descriptive analytics is part of which component of the AMPS model?

Accepted Answer

A)  Ask the Question 
B)  Perform the Analysis 
C)  Share the Story 
D)  Master the Data 
A)  Ask the Question 
B)  Perform the Analysis 
C)  Share the Story 
D)  Master the Data

Question 13

The __________ explains the changes in retained earnings from net income or losses and any (cash) dividends paid to investors.

Accepted Answer

A)  Statement of cash flows 
B)  Balance sheet 
C)  Income statement 
D)  Statement of stockholders' equity 
A)  Statement of cash flows 
B)  Balance sheet 
C)  Income statement 
D)  Statement of stockholders' equity

Question 14

Of the following measures, the best measure for evaluating firm efficiency in handling and using assets is __________.

Accepted Answer

A)  asset turnover 
B)  return on assets 
C)  profit margin 
D)  return on equity 
A)  asset turnover 
B)  return on assets 
C)  profit margin 
D)  return on equity

Question 15

If the profit margin is 0.2158, asset turnover is 0.5389 and financial leverage is 1.2047, what is the return on asset?

Accepted Answer

A)  0.1401 
B)  0.6492 
C)  0.1163 
D)  0.5389 
A)  0.1401 
B)  0.6492 
C)  0.1163 
D)  0.5389

Question 16

Comparing the extent of long-term debt to equity is an example of __________.

Accepted Answer

A)  Vertical analysis 
B)  Horizontal analysis 
C)  Ratio analysis 
D)  Pivottables 
A)  Vertical analysis 
B)  Horizontal analysis 
C)  Ratio analysis 
D)  Pivottables

Question 17

A company's descriptive statistics are appropriately compared to either 1) the economy as a whole, 2) the company's respective industry, 3) competitors and 4) the company's own prior performance.

Accepted Answer

A) True 
 B)False

Question 18

Of the following measures, the best way to analyze the variability in the sample is to consider the __________.

Accepted Answer

A)  mean 
B)  maximum or minimum 
C)  mode 
D)  standard deviation 
A)  mean 
B)  maximum or minimum 
C)  mode 
D)  standard deviation

Question 19

__________ are brief, generally small, visuals that fit within one cell in Excel that visually depict what happened in the cells next to it.

Accepted Answer

A)  Small graphics 
B)  Sparklines 
C)  Pivot charts 
D)  Analytic charts 
A)  Small graphics 
B)  Sparklines 
C)  Pivot charts 
D)  Analytic charts

Question 20

Summarizing data to understand what has happened is what type of analytics?

Accepted Answer

A)  Descriptive analytics 
B)  Diagnostic analytics 
C)  Predictive analytics 
D)  Prescriptive analytics 
A)  Descriptive analytics 
B)  Diagnostic analytics 
C)  Predictive analytics 
D)  Prescriptive analytics

All other things equal, in which of the following buckets would you expect the least amount of aged receivables to be?

If you have minimums and maximums that are far away (several standard deviations away from the mean) from the rest of the data observations, medians would be the best measure of central tendency?

Which measure would help us evaluate what happens in the highest and lowest 20 percent of the data?

To compute the percentage change in a horizontal analysis from last year to this year, the computation will be:

While a reorganizes and summarizes certain data using cross-tabulations without changing the underlying spreadsheet (or data), a is a graphical depiction of those cross-tabulations.

Dupont analysis allows an analysis of profit margins, asset turnover and liquidity.

An analysis which expresses financial information in relation to some relevant figure or base is called __________.

If the profit margin is 0.2158, asset turnover is 0.5389 and financial leverage is 1.2047, what is the return on equity?

The __________ provide details on the accounting policies chosen.

The Dupont Analysis measures which of these performance categories?

Descriptive analytic measures of central tendency include all except which of the following?

Descriptive analytics is part of which component of the AMPS model?

The __________ explains the changes in retained earnings from net income or losses and any (cash) dividends paid to investors.

Of the following measures, the best measure for evaluating firm efficiency in handling and using assets is __________.

If the profit margin is 0.2158, asset turnover is 0.5389 and financial leverage is 1.2047, what is the return on asset?

Comparing the extent of long-term debt to equity is an example of __________.

A company's descriptive statistics are appropriately compared to either 1) the economy as a whole, 2) the company's respective industry, 3) competitors and 4) the company's own prior performance.

Of the following measures, the best way to analyze the variability in the sample is to consider the __________.

__________ are brief, generally small, visuals that fit within one cell in Excel that visually depict what happened in the cells next to it.

Summarizing data to understand what has happened is what type of analytics?

Using Data Analytics to Ask and Answer Accounting Questions

Master the Data: an Introduction to Accounting Data

Accounting Data Data Types and How They Are Used

Master the Data: Preparing Data for Analysis

Perform the Analysis: Types and Tools of Data Analyses

Perform the Analysis: Diagnostic Analyses

Perform the Analysis: Predictive Analytics

Perform the Analysis: Prescriptive Analytics

Share the Story

Filters

Exam 6: Perform the Analysis: Descriptive Analyses

All other things equal, in which of the following buckets would you expect the least amount of aged receivables to be?

If you have minimums and maximums that are far away (several standard deviations away from the mean) from the rest of the data observations, medians would be the best measure of central tendency?

Which measure would help us evaluate what happens in the highest and lowest 20 percent of the data?

To compute the percentage change in a horizontal analysis from last year to this year, the computation will be:

While a __________ reorganizes and summarizes certain data using cross-tabulations without changing the underlying spreadsheet (or data), a __________ is a graphical depiction of those cross-tabulations.

Dupont analysis allows an analysis of profit margins, asset turnover and liquidity.

An analysis which expresses financial information in relation to some relevant figure or base is called __________.

If the profit margin is 0.2158, asset turnover is 0.5389 and financial leverage is 1.2047, what is the return on equity?

The __________ provide details on the accounting policies chosen.

The Dupont Analysis measures which of these performance categories?

Descriptive analytic measures of central tendency include all except which of the following?

Descriptive analytics is part of which component of the AMPS model?

The __________ explains the changes in retained earnings from net income or losses and any (cash) dividends paid to investors.

Of the following measures, the best measure for evaluating firm efficiency in handling and using assets is __________.

If the profit margin is 0.2158, asset turnover is 0.5389 and financial leverage is 1.2047, what is the return on asset?

Comparing the extent of long-term debt to equity is an example of __________.

A company's descriptive statistics are appropriately compared to either 1) the economy as a whole, 2) the company's respective industry, 3) competitors and 4) the company's own prior performance.

Of the following measures, the best way to analyze the variability in the sample is to consider the __________.

__________ are brief, generally small, visuals that fit within one cell in Excel that visually depict what happened in the cells next to it.

Summarizing data to understand what has happened is what type of analytics?

Using Data Analytics to Ask and Answer Accounting Questions

Master the Data: an Introduction to Accounting Data

Accounting Data Data Types and How They Are Used

Master the Data: Preparing Data for Analysis

Perform the Analysis: Types and Tools of Data Analyses

Perform the Analysis: Diagnostic Analyses

Perform the Analysis: Predictive Analytics

Perform the Analysis: Prescriptive Analytics

Share the Story

Filters

While a reorganizes and summarizes certain data using cross-tabulations without changing the underlying spreadsheet (or data), a is a graphical depiction of those cross-tabulations.