CPA Bar Quiz: Analyze Data Sets To Support Decisions

What this quiz covers

This quiz focuses on Analyze Data Sets To Support Decisions, giving you a quick way to practice the rules, question types, and explanations that matter most for CPA Bar.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

Question 1

1. Data organized in a predefined format, typically stored in rows and columns such as a relational database (correct answer)
2. Data that has no predefined format, including items such as emails, social media posts, and images
3. Data that is partially organized and requires transformation before it can be analyzed
4. Data collected from external sources that has been validated for accuracy and completeness

Explanation: Structured data is organized according to a predefined schema - typically rows and columns in a relational database or spreadsheet - making it immediately accessible to standard query tools and analysis. Option B describes unstructured data, which lacks a predefined format. Option C describes semi-structured data, which has some organizational properties but requires further transformation. Option D describes data validation status, not a data type classification.

Question 2

1. $15,200
2. $10,600
3. $7,600
4. $12,800 (correct answer)

Explanation: Estimated cost = Intercept + (Slope x Activity) = $5,200 + ($3.80 x 2,000) = $5,200 +$7,600 = $12,800. Option A multiplies the slope by an incorrect base and omits the intercept properly. Option B adds the intercept and the product of slope times 1,000 rather than 2,000. Option C represents only the variable component ($3.80 x 2,000) without adding the fixed intercept.

Question 3

1. $6,500 (correct answer)
2. $4,500
3. $13,500
4. $22,500

Explanation: For a special order with idle capacity, only variable costs are relevant. Contribution = (Special order price - Variable cost) x Units = ($45 -$32) x 500 = $13 x 500 =$6,500. Fixed costs are irrelevant because they will be incurred regardless of whether the order is accepted. Option B uses the normal price to compute contribution rather than the special order price. Option C multiplies the full price by units, omitting variable costs. Option D multiplies the normal selling price by units without deducting any costs.

Question 4

1. Reduce prices to restore transaction volume, since total revenue has likely declined
2. Increase marketing spend to address declining volume, which indicates insufficient brand awareness
3. Launch a loyalty program to reward existing customers for their higher per-transaction spend
4. Investigate whether a pricing change, product mix shift, or customer segment change is driving the value increase before modifying strategy (correct answer)

Explanation: The data presents two diverging signals without explaining their cause. A higher average transaction value could result from deliberate price increases, a shift toward premium products, or a loss of lower-value customers. Each explanation implies a different strategic response. Investigating the root cause first prevents committing to a strategy based on an incorrect interpretation. Option A assumes revenue declined, which is not certain (15% x 0.92 = approximately 6% net increase). Option B assumes brand awareness is the cause of volume decline without evidence. Option C assumes the existing customers are the source of value growth, which requires verification.

Question 5

1. Making costs $18 per unit; buying costs$19 per unit - making is less expensive by $1 per unit (correct answer)
2. Making costs $19 per unit; buying costs$19 per unit - the options are equivalent
3. Making costs $23 per unit; buying costs$19 per unit - buying is less expensive by $4 per unit
4. The fixed overhead must be included, making the total make cost $23 per unit versus$19 per unit to buy

Explanation: Only avoidable (relevant) costs are included in the make-or-buy decision. The allocated fixed overhead of $50,000 is not avoidable and is excluded. Relevant make cost = ($80,000 + $60,000 +$40,000) / 10,000 = $180,000 / 10,000 =$18 per unit. The buy price is $19 per unit. Making is$1 per unit less expensive. Option B incorrectly equates the two. Option C includes the unavoidable fixed overhead in the make cost. Option D also incorrectly includes unavoidable fixed overhead and reaches the wrong conclusion.

Question 6

1. Center 4 only, because it is the furthest below target
2. Centers 1, 2, and 4, because Center 3 is the only high performer
3. All four centers, because none has achieved 100% on-time delivery
4. Centers 2 and 4, because both fall below the 90% target (correct answer)

Explanation: The stated performance threshold is 90%. Centers 2 (88%) and 4 (82%) are both below this target and require corrective action. Centers 1 (94%) and 3 (97%) exceed the target and do not require corrective action based on this metric. Option A identifies only the worst performer, ignoring Center 2 which also misses the target. Option B incorrectly includes Center 1, which exceeds the 90% target. Option C applies a standard of 100% that was not established as the target.

Question 7

1. The over-90-days balance of $28,000 requires immediate collection follow-up as it represents the highest credit risk in the aging schedule (correct answer)
2. The 0-30 day balance is excessive and indicates the company is extending credit too liberally
3. The aging distribution is healthy because the majority of AR is in the current 0-30 day bucket
4. The company should write off all balances over 60 days to reduce its bad debt exposure

Explanation: The over-90-days bucket represents the highest-risk receivables - balances that have remained uncollected well beyond normal payment terms. These accounts are at the greatest risk of becoming uncollectible and merit immediate collection action or escalation. Option B incorrectly interprets a large current balance as a problem; having most receivables in the 0-30 day bucket is typical and healthy. Option C is partially correct but is passive - a healthy current balance does not eliminate the need to act on the high-risk aging buckets. Option D is inappropriate without first attempting collection; writing off collectible balances reduces assets unnecessarily.

Question 8

1. Permanently increase quality inspection staffing because defect rates are unpredictable
2. Remove weeks 14-17 from the annual defect rate calculation to present a more accurate picture
3. Identify what changed in production inputs, processes, or personnel during weeks 14-17 to isolate the root cause (correct answer)
4. Conclude the spike was random variation and take no further action since rates normalized in week 18

Explanation: A localized, time-bounded spike in defect rates strongly suggests a specific, identifiable cause - a change in raw material supplier, equipment malfunction, new operator, or process deviation - rather than random variation. Root cause analysis during the affected weeks is the most productive response. Option A is an overreaction that does not address the cause and adds unnecessary cost. Option B removes data from the record, reducing accountability and eliminating information that could improve future quality. Option D treats the spike as random, but the pattern (four weeks of elevated rates followed by return to normal) is more consistent with a discrete cause than with random variation.

Question 9

1. Whether the revenue data is reported on a cash basis or an accrual basis
2. Whether all departments use the same method for recognizing revenue
3. Whether the correlation coefficient between headcount and revenue exceeds 0.80
4. Whether higher revenue is driving the need for more employees or more employees are driving revenue growth (correct answer)

Explanation: Before recommending an action based on a correlation, the direction of causality must be established. It is plausible that more revenue creates more demand for staff, rather than more staff creating revenue. Acting on the wrong causal direction could lead to hiring more employees for revenue-support roles without generating additional sales. Options A and B address revenue measurement consistency, which affects comparability but not the core causal question. Option C focuses on the strength of correlation, but even a strong correlation does not establish which variable is the cause.

Question 10

1. Inventory purchasing costs have decreased each year
2. Inventory is turning over more slowly, suggesting a buildup of stock relative to cost of goods sold (correct answer)
3. The company is improving its supply chain efficiency over time
4. Cost of goods sold has increased each year relative to average inventory

Explanation: Inventory turnover = COGS / Average inventory. A declining ratio means inventory is selling more slowly relative to COGS - inventory levels are rising faster than sales, or sales are declining relative to inventory held. This signals a potential buildup of slow-moving or excess stock. Option A is incorrect; purchasing costs affect COGS and margins, not directly the turnover ratio. Option C is incorrect; improving supply chain efficiency would increase the turnover ratio, not decrease it. Option D describes the opposite of what a declining ratio indicates - a higher ratio would result if COGS increased relative to inventory.

Question 11

1. Performance is strong because the most important metric, revenue growth, exceeds its target
2. Performance is poor because three of four metrics are below target
3. Revenue growth may be masking operational problems in customer experience, workforce stability, and inventory management (correct answer)
4. The dashboard should be reconfigured to remove metrics that consistently underperform

Explanation: The dashboard tells a nuanced story: strong top-line growth accompanies weak customer satisfaction, high employee turnover, and elevated inventory days. These operational metrics often serve as leading indicators - deteriorating customer satisfaction and high turnover can erode future revenue even when current growth looks strong. A balanced assessment recognizes that the favorable revenue metric may be obscuring systemic operational concerns. Option A assigns priority to revenue without acknowledging the lagging nature of that metric. Option B is overly negative given that three of four metrics have meaningful targets, but the revenue outperformance is material. Option D is counterproductive; removing underperforming metrics from dashboards hides rather than resolves problems.

Question 12

1. The accounting rate of return for each project, which provides a simpler comparison metric
2. Whether the NPV calculations used the same tax rate assumptions
3. The payback period, because NPV does not account for the time required to recover the initial investment
4. The initial investment required for each project, since a higher NPV may require a disproportionately larger investment (correct answer)

Explanation: NPV measures absolute dollar value created, not return on investment. Project A's higher NPV might require, for example, $1,000,000 of initial investment (NPV/Investment = 8.5$200,000 (NPV/Investment = 31%). In that case, Project B creates far more value per dollar invested. The profitability index (NPV / Initial investment) reconciles this comparison. Option A substitutes a less theoretically sound metric without addressing the scale issue. Option B addresses consistency of assumptions, which is important but secondary to the scale question when comparing projects. Option C mischaracterizes NPV; while NPV does not display payback explicitly, the time value of cash flows is already embedded in the discounting process.

Question 13

1. Displaying the intensity or concentration of values across two dimensions simultaneously (correct answer)
2. Showing changes in a single variable over a continuous time period
3. Comparing the proportional composition of a whole across multiple categories
4. Illustrating the statistical distribution of a continuous variable around its mean

Explanation: A heat map uses color gradients to represent the magnitude or density of values at intersections of two dimensions - for example, sales performance by region and product category, or risk levels by likelihood and impact. Option B describes a line chart or time series plot. Option C describes a pie chart or stacked bar chart. Option D describes a histogram or bell curve visualization.

Question 14

1. 57.2%
2. 66.9% (correct answer)
3. 72.4%
4. 63.5%

Explanation: Salary percentage = $320 /$478 = 66.9%. Option A results from dividing $320 by an incorrect total. Option C overstates the percentage using an understated denominator. Option D applies an incorrect denominator derived from summing only selected line items.

Question 15

1. The price increase should be implemented because higher unit prices always improve profitability
2. The price increase should not be implemented because any decline in volume is unacceptable
3. The price increase would likely reduce total revenue, and its net effect on profitability depends on whether the per-unit margin gain offsets the contribution lost from lower volume (correct answer)
4. The model is inconclusive because historical elasticity data may not predict future consumer behavior

Explanation: Net revenue effect = 1.05 x 0.92 - 1 = approximately -3.4%, meaning total revenue would likely decline. However, profitability is not determined by revenue alone - if variable costs are a large portion of unit cost, each unit sold at a higher price may generate enough additional contribution margin to offset the lost volume. The correct conclusion is that the data supports a probable revenue decline, and further analysis of the margin structure is needed. Option A ignores the volume loss entirely. Option B is overly rigid and does not consider whether the margin improvement on remaining units compensates. Option D is a valid caveat but does not constitute a conclusion supported by the data.

Question 16

1. The company should eliminate the direct sales channel because it is declining in share
2. The distributor channel is most stable and should receive the most incremental investment
3. The online growth is unsustainable and will likely reverse in the near term
4. The structural shift toward online warrants a review of cost structure and margin by channel to understand the profitability implications (correct answer)

Explanation: A consistent three-year shift in channel mix from direct to online is a structural change, not a short-term fluctuation. Different channels carry different cost structures - direct sales involve headcount and travel costs, while online may involve lower variable costs but higher technology and fulfillment investments. Understanding margin by channel is essential before determining whether the shift is favorable or unfavorable for profitability. Option A is premature; declining share does not mean a channel is unprofitable or should be eliminated. Option B prioritizes stability without evidence that the distributor channel is the highest-margin or most strategically valuable. Option C makes a predictive claim without supporting data.

Question 17

1. Include the $480,000 figure in all trend analyses because all reported data points are valid
2. Investigate the $480,000 month to determine whether it represents a data error or a genuine business event (correct answer)
3. Remove the $480,000 month from all analyses because it distorts the trend line
4. Replace the mean with the median to reduce the statistical influence of the outlier

Explanation: An outlier that falls far outside the range of all other observations requires investigation before any analytical decision is made about it. It could represent a data entry error, a system glitch, or a genuine business event such as a large one-time contract. The appropriate action is to verify the source before including or excluding it. Option A accepts the figure without verification. Option C removes it without understanding its cause, which could discard valid information. Option D is a defensive measure that does not address the underlying question of whether the data point is accurate.

Question 18

1. Electronics, with a $40,000 regional difference
2. Home Goods, with a $115,000 regional difference (correct answer)
3. Apparel, with a $55,000 regional difference
4. Electronics and Apparel are tied for the largest regional variance

Explanation: Regional differences: Electronics = $420,000 -$380,000 = $40,000; Apparel =$240,000 - $185,000 =$55,000; Home Goods = $310,000 -$195,000 = $115,000. Home Goods has the largest absolute variance between regions at$115,000. Option A understates the Electronics difference and ignores the larger variances. Option C identifies Apparel correctly as second but misses the larger Home Goods variance. Option D is incorrect because Electronics ($40,000) is not tied with Apparel ($55,000).

Question 19

1. $488,000
2. $492,000
3. $500,000 (correct answer)
4. $510,000

Explanation: The data shows a constant increase of $20,000 per quarter. Extending the trend: Quarter 6 =$480,000 + $20,000 =$500,000. Option A applies an incorrect incremental amount. Option B applies a declining increment rather than the consistent $20,000 pattern. Option D overstates the trend by applying a larger increment than the data supports.

Question 20

1. Customer A, with a direct contribution of $35,000
2. Customer B, with a direct contribution of $23,000 (correct answer)
3. Customer A, with a direct contribution of $15,000
4. Customer B, with a direct contribution of $35,000

Explanation: Direct contribution = Revenue - Direct costs - Customer-specific overhead. Customer A: $120,000 -$85,000 - $20,000 =$15,000. Customer B: $90,000 -$55,000 - $12,000 =$23,000. Customer B is more profitable despite lower revenue. Option A uses only revenue minus direct costs for Customer A, omitting the customer-specific overhead. Option C correctly calculates Customer A's contribution but does not identify which is more profitable. Option D applies the incorrect contribution amount to Customer B.