MA: Data analysis
22 free practice questions on data analysis, Section B of the ACCA Management Accounting (MA) question bank. Topics include High-low method, Sampling, Index numbers, Time series, Correlation and regression, Probability and expected values. Each question carries its syllabus reference and a worked explanation. Practise them in the quiz with instant feedback, or read every question with its answer further down this page.
→ Full MA question bank and timed mock exam
→ MA Common Mistakes
→ MA Formula Sheet
Loading questions…
All 22 data analysis questions
The same questions the quiz above draws on, in syllabus order, each with its answer and worked explanation. 11 are multiple choice and 11 are numerical, where you work the answer out before choosing it.
A retailer wants to survey customer satisfaction. It instructs researchers to interview exactly 50 customers from each of four age groups: under 25, 25–40, 41–60, and over 60. Researchers select any available customers until each quota is filled. Which sampling method does this describe?
- Stratified random sampling
- Systematic sampling
- Cluster sampling
- Quota sampling
Show answer and explanation
Answer: D. Quota sampling divides the population into groups and sets a target number (quota) to interview from each group. Crucially, the selection within each group is not random — researchers interview whoever is available until the quota is met. This distinguishes it from stratified random sampling, where members within each stratum are selected randomly. Systematic sampling selects every nth item from a list. Cluster sampling selects entire subgroups (clusters) at random.
A factory's total costs at 4,000 units of output were £28,000 and at 10,000 units were £46,000. Using the high-low method, what is the variable cost per unit? Enter your answer in pounds to two decimal places.
- 2.50
- 4.60
- 3.00
- 7.00
Show answer and explanation
Answer: C. High-low method: Variable cost per unit = (Highest cost − Lowest cost) ÷ (Highest activity − Lowest activity). Variable cost per unit = (£46,000 − £28,000) ÷ (10,000 − 4,000) = £18,000 ÷ 6,000 = £3.00 per unit. Fixed costs can then be found: £46,000 − (10,000 × £3.00) = £16,000. Option A (£2.50) divides cost by highest volume only. Option B (£4.60) divides total cost at high level by units. Option D (£7.00) divides the cost difference by the low volume figure.
Total costs are £18,000 at 1,500 units and £25,000 at 2,500 units. One supervisor costing £3,000 is needed per 1,000 units of production. What is the variable cost per unit?
- 7.00
- 4.00
- 10.00
- 3.50
Show answer and explanation
Answer: B. This involves stepped fixed costs which must be stripped out before applying the high-low method. Supervisor cost at 1,500 units = 2 × £3,000 = £6,000. Supervisor cost at 2,500 units = 3 × £3,000 = £9,000. Variable costs only: Low = £18,000 − £6,000 = £12,000. High = £25,000 − £9,000 = £16,000. Variable cost per unit = (£16,000 − £12,000) ÷ (2,500 − 1,500) = £4,000 ÷ 1,000 = £4.00. Option A is the error of not stripping out supervisor costs. This question type is flagged as a common exam weakness in the examiner's report.
A company's sales revenue was £240,000 in year 1 (the base year). In year 3, revenue was £300,000. What is the index number for year 3, expressed to one decimal place?
- 80.0
- 125.0
- 60.0
- 140.0
Show answer and explanation
Answer: B. Index number = (Current year value ÷ Base year value) × 100. Index = (£300,000 ÷ £240,000) × 100 = 125.0. This means revenue in year 3 is 125% of the base year value — an increase of 25%. Option A (80.0) divides base by current (the inverse). Option C (60.0) calculates the increase as a percentage of current revenue. Option D (140.0) uses an incorrect calculation.
A time series analysis of quarterly sales shows an underlying upward trend. Quarter 3 consistently shows sales significantly above the trend line. Which component of time series analysis does this quarterly variation represent?
- Cyclical variation — a long-term wave pattern linked to economic cycles
- Random variation — unpredictable fluctuations with no identifiable pattern
- Seasonal variation — a regular, predictable pattern that repeats over a consistent time period
- The underlying trend — the general direction of the time series over the long term
Show answer and explanation
Answer: C. Seasonal variation is the regular, predictable fluctuation that repeats within a year (or other consistent cycle). A consistently higher Q3 is a seasonal pattern. Cyclical variation (A) operates over multiple years linked to economic cycles, not regular quarters. Random variation (B) is unpredictable by definition. The trend (D) is the overall long-run direction, not the regular quarterly deviation from it.
A scatter diagram of advertising spend and sales revenue shows that as advertising spend increases, sales revenue also increases in a broadly consistent pattern. Which term best describes the relationship shown?
- Negative correlation — the two variables move in opposite directions
- Zero correlation — there is no relationship between the two variables
- Causation — advertising spend directly and definitively causes higher sales
- Positive correlation — the two variables tend to move in the same direction
Show answer and explanation
Answer: D. Positive correlation means both variables tend to increase or decrease together. The scatter shows this pattern. Negative correlation (A) means one rises as the other falls. Zero correlation (B) means no discernible relationship. Causation (C) is a critical distinction — correlation does not prove causation. Higher advertising may cause higher sales, but other factors (economic conditions, competitor actions) may also be at work. This is a classic exam point.
A project has three possible outcomes: profit of £60,000 with probability 0.3, profit of £20,000 with probability 0.5, and a loss of £10,000 with probability 0.2. What is the expected value of the project?
- £26,000
- £23,333
- £70,000
- £30,000
Show answer and explanation
Answer: A. Expected value = Σ(outcome × probability). EV = (£60,000 × 0.3) + (£20,000 × 0.5) + (−£10,000 × 0.2) = £18,000 + £10,000 − £2,000 = £26,000. Check probabilities sum to 1: 0.3 + 0.5 + 0.2 = 1.0 ✓. Option B divides the simple average by 3. Option C sums the outcomes without weighting. Option D is a common error — forgetting to deduct the loss scenario.
A company makes two products. Product X has a contribution of £30 per unit and requires 4 machine hours. Product Y has a contribution of £20 per unit and requires 2 machine hours. Only 1,200 machine hours are available. Maximum demand is 200 units of X and 300 units of Y. How many units of each product should be made to maximise contribution?
- 150 units of X and 300 units of Y
- 200 units of X and 100 units of Y
- 200 units of X and 200 units of Y
- 300 units of X and 150 units of Y
Show answer and explanation
Answer: A. Step 1 — contribution per machine hour: X = £30 ÷ 4 = £7.50/hr; Y = £20 ÷ 2 = £10.00/hr. Rank Y first (higher contribution per limiting factor). Step 2 — allocate hours to Y at maximum demand: 300 units × 2 hrs = 600 hrs. Step 3 — remaining hours for X: 1,200 − 600 = 600 hrs ÷ 4 hrs = 150 units of X. Optimal plan: 150 X and 300 Y — option A. Contribution = (150 × £30) + (300 × £20) = £4,500 + £6,000 = £10,500. Option B (200X, 100Y) prioritises X, which has the lower contribution per machine hour. Option C (200X, 200Y) uses 800 + 400 = 1,200 hrs but yields only £10,000 contribution — feasible but not optimal. Option D exceeds maximum demand for X (300 > 200).
Product A has a contribution of £24 per unit and requires 4 kg of material. Product B has a contribution of £15 per unit and requires 2 kg of material. Material is the scarce resource. Which product should be prioritised and why?
- Product B — it generates £7.50 contribution per kg versus £6.00 for Product A
- Product B — it uses fewer kg of material so less waste is incurred
- Product A — it generates the higher total contribution per unit
- Product A — it has the higher selling price per unit
Show answer and explanation
Answer: A. When a resource is scarce, rank by contribution per unit of the scarce resource, not by contribution per unit of product. Product A = £24 ÷ 4kg = £6.00/kg. Product B = £15 ÷ 2kg = £7.50/kg. Product B earns more contribution per kg of material, so it should be prioritised — option A, which gives both the right product and the right reasoning. Option B reaches the right product but for the wrong reason ('less waste' is irrelevant; the limiting-factor principle is about contribution per unit of the constraint). Option C applies total contribution per unit, the classic error when a constraint exists. Option D uses selling price, which ignores variable costs and the constraint entirely.
A regression line for monthly sales (£'000) against time (months) is: Y = 120 + 8X, where X=1 is month 1. What is the forecast sales for month 15?
- £232,000
- £120,000
- £240,000
- £248,000
Show answer and explanation
Answer: C. Y = 120 + 8(15) = 120 + 120 = 240. Sales = £240,000 (in £'000). The regression equation extrapolates the trend. Option A uses X=14 (120+112=232). Option B uses only the constant term (ignoring X). Option D uses X=16 (120+128=248). Always substitute the correct time period value — a common exam error is using the wrong X value.
What is the primary purpose of drawing a scatter diagram before applying linear regression analysis to cost data?
- To calculate the exact equation of the line of best fit automatically
- To visually inspect whether a linear relationship exists between the variables before applying a linear model
- To determine which of the two variables is the dependent variable
- To identify the fixed cost element of a semi-variable cost
Show answer and explanation
Answer: B. A scatter diagram plots the raw data points to allow visual inspection of the relationship. If the points appear randomly scattered, a linear model is inappropriate. If they suggest a non-linear pattern, regression will produce a misleading equation. Inspection confirms linearity before computation. The regression equation is calculated separately (A). The choice of dependent variable is determined by the analysis objective, not the scatter diagram (C). Identifying fixed costs uses the high-low method, not a scatter diagram (D).
The following quarterly sales data is given (£'000): Q1: 120, Q2: 140, Q3: 180, Q4: 160, Q1 next year: 130. What is the 4-point moving average centred on Q3 of the first year?
- 151.25
- 150.00
- 145.00
- 155.00
Show answer and explanation
Answer: A. A 4-point moving average must be centred because 4 is an even number — each MA falls between quarters, not on one. First 4-point MA (Q1–Q4): (120 + 140 + 180 + 160) ÷ 4 = 150.0, centred between Q2 and Q3. Second 4-point MA (Q2–Q1 next year): (140 + 180 + 160 + 130) ÷ 4 = 152.5, centred between Q3 and Q4. Centred MA for Q3 = (150.0 + 152.5) ÷ 2 = 151.25 — option A. Option B (150.0) is the first uncentred moving average; forgetting the centring step is the most common error in time series questions.
A company uses sensitivity analysis to assess a capital investment decision. It finds that NPV becomes zero if sales volume falls by 15%. Which of the following correctly interprets this finding?
- The project should be rejected as a 15% fall in sales volume is highly likely in the current market
- Sensitivity analysis proves the project will succeed as a 15% reduction is within normal forecasting error
- The project has a 15% margin of safety on sales volume — the investment is viable as long as sales do not fall more than 15% below forecast
- A 15% sensitivity indicates the project is completely risk-free as NPV cannot fall below zero
Show answer and explanation
Answer: C. Sensitivity analysis identifies the percentage change in a variable that would make NPV zero — the margin of safety for that variable. A 15% margin on sales volume means the project remains viable unless sales fall more than 15% below forecast. Whether to proceed depends on management's assessment of how likely that fall is — sensitivity analysis does not make the decision, it informs it. Options A, B and D either misapply the finding or draw unwarranted conclusions.
Which of the following best describes the advantage of presenting data in a table compared to presenting it as raw text?
- Tables automatically calculate totals and highlight variances without further analysis
- Tables organise data into rows and columns, making it easier to compare values and identify patterns quickly
- Tables are only suitable for financial data and cannot be used for operational or non-financial information
- A table presents data in a way that eliminates the need for any explanatory commentary
Show answer and explanation
Answer: B. Tables present data in a structured grid format that facilitates comparison — the eye can quickly scan rows and columns to spot patterns, outliers, and relationships. Tables do not automatically calculate (A) — that requires formulas or manual work. Tables can present any quantitative or qualitative data (C). Tables complement but do not replace commentary (D) — the meaning of the data still needs to be explained.
In a linear programming problem with two products and two constraints, where is the optimal solution always found?
- At the midpoint of the longest constraint line
- At a corner point (vertex) of the feasible region
- At the origin of the graph where both products equal zero
- At the intersection of the objective function with the vertical axis
Show answer and explanation
Answer: B. In linear programming, the optimal solution (maximum or minimum of the objective function) always lies at a corner point of the feasible region — this is a fundamental property of linear programming. The feasible region is bounded by the constraint lines, and the optimal corner is found by substituting corner coordinates into the objective function and selecting the best value. The midpoint (A), origin (C), and axis intersection (D) are not generally optimal.
Which of the following best describes the Delphi method of forecasting?
- A statistical technique that extrapolates historical trends into the future using regression analysis
- A simulation method that generates thousands of random scenarios to estimate probability distributions
- An iterative process of gathering and refining expert opinion anonymously until consensus is reached
- A simple method that averages the last three periods of actual data to forecast the next period
Show answer and explanation
Answer: C. The Delphi method aggregates expert opinion through anonymous, iterative rounds — experts respond, see a summary of others' views, and revise their estimates, converging toward consensus without groupthink. Regression analysis (A) is a quantitative statistical technique. Monte Carlo simulation (B) generates random scenarios. Simple moving average (D) averages recent data. The Delphi method is qualitative and relies on expert judgement rather than historical data.
A company's actual Q2 sales are £180,000. The seasonal variation for Q2 is +£15,000 (additive model). What is the trend (seasonally adjusted) figure for Q2?
- £195,000
- £165,000
- £180,000
- £15,000
Show answer and explanation
Answer: B. In an additive model: Actual = Trend + Seasonal variation. Therefore: Trend = Actual − Seasonal variation = £180,000 − £15,000 = £165,000. The positive seasonal variation means Q2 is typically above trend — removing it gives the underlying trend. Option A adds the variation (incorrect direction). Option C ignores the adjustment. Option D is just the seasonal variation. Seasonal adjustment reveals the underlying trend by removing the predictable seasonal component.
A company sells two products: X (contribution £30, 60% of sales mix) and Y (contribution £20, 40% of sales mix). Fixed costs are £130,000. What is the breakeven point in terms of total units?
- 4,333 units
- 6,500 units
- 5,000 units
- 3,250 units
Show answer and explanation
Answer: C. Weighted average contribution = (0.60 × £30) + (0.40 × £20) = £18 + £8 = £26 per unit. Breakeven = Fixed costs ÷ Weighted average contribution = £130,000 ÷ £26 = 5,000 units total. Of these: X = 5,000 × 60% = 3,000 units; Y = 5,000 × 40% = 2,000 units. Option A divides by £30 (X contribution only). Option B divides by £20 (Y contribution only). Option D is half the correct answer.
A management accountant wants to test whether there is a statistically significant association between product type sold and sales region. Which statistical test is most appropriate?
- Linear regression — suitable for predicting a continuous dependent variable from an independent variable
- T-test — suitable for comparing the means of two groups
- Standard deviation analysis — suitable for measuring the spread of values around a mean
- Chi-squared test — suitable for testing association between two categorical variables
Show answer and explanation
Answer: D. The chi-squared test assesses whether two categorical variables are associated — product type (categorical) and sales region (categorical) is exactly this situation. Regression (A) is for continuous variables with a predictive relationship. T-tests (B) compare means of continuous variables between groups. Standard deviation (C) describes spread within a data set — not a test of association. The MA syllabus includes awareness of when different statistical tools are appropriate.
A regression analysis produces the equation Y = 50 + 3.5X with a correlation coefficient (r) of 0.92. Which of the following correctly interprets both outputs?
- Y increases by 50 for every unit increase in X; r=0.92 means 92% of variation is explained
- For every unit increase in X, Y increases by 3.5; the correlation coefficient of 0.92 indicates a strong positive linear relationship
- The fixed cost is 3.5 and the variable cost is 50 per unit; r=0.92 is the coefficient of determination
- The regression is perfectly accurate as r=0.92 is close to 1.0
Show answer and explanation
Answer: B. In Y=a+bX: 'a' (50) is the intercept (fixed element); 'b' (3.5) is the slope — for each unit increase in X, Y increases by 3.5. The correlation coefficient r=0.92 indicates a strong positive relationship (r near +1 = strong positive, near −1 = strong negative, near 0 = no relationship). Option A misidentifies the slope and intercept. Option C reverses a and b and confuses r with r². Option D — r=0.92 means strong but not perfect correlation; r=1.0 would be perfect.
Project A has an expected return of £50,000 with a standard deviation of £10,000. Project B has an expected return of £80,000 with a standard deviation of £20,000. Which project has higher relative risk, and why?
- Project B — it has the higher standard deviation in absolute terms
- Project A — it has the lower expected return making any loss proportionally larger
- Project B — coefficient of variation 0.25 versus Project A 0.20, so B carries the higher relative risk
- Both have equal risk as the ratio of standard deviation to expected return is the same
Show answer and explanation
Answer: C. Relative risk is measured by the coefficient of variation (CV) = standard deviation ÷ expected value, which scales risk to the size of the return. CV(A) = £10,000 ÷ £50,000 = 0.20; CV(B) = £20,000 ÷ £80,000 = 0.25. The higher CV means higher relative risk, so Project B is riskier in relative terms — option C. Option A looks only at the absolute standard deviation (£20,000 > £10,000), ignoring that B also offers a much larger return. Option B reasons loosely from the expected return alone. Option D wrongly claims the ratios are equal; 0.25 does not equal 0.20.
Sales are normally distributed with a mean of 10,000 units and a standard deviation of 800 units. Approximately what percentage of months will have sales between 8,400 and 11,600 units?
- 95%
- 68%
- 99.7%
- 50%
Show answer and explanation
Answer: A. 8,400 = 10,000 − 2×800 (two standard deviations below mean). 11,600 = 10,000 + 2×800 (two standard deviations above mean). The empirical rule for normal distributions: ±1 SD = ~68% of values; ±2 SD = ~95% of values; ±3 SD = ~99.7%. The range 8,400–11,600 is ±2 standard deviations, covering approximately 95% of observations. Option B (68%) covers ±1 SD. Option C (99.7%) covers ±3 SD. Option D (50%) covers half the distribution.
Other MA topics
- Management information (13 questions)
- Cost accounting (38 questions)
- Budgeting (32 questions)
- Standard costing (22 questions)
- Performance measurement (23 questions)
- All MA sections, with the timed mock exam
- Spotted a mistake? Report it and it will be corrected.