Original synthetic exercises · 1.0.0

Try a problem before opening its answer

Choose an independent attempt, open the hints if needed, then compare your reasoning with the worked answer. All three versions use the same numbers. Completing a repeated example does not demonstrate transfer to a new dataset.

Use paper or any calculator. No account, timer or upload is required. State the unit and denominator in your answer. Educator review: Not obtained.

Download the complete educator package and answer key · Download all twelve structured exercises

1. Combine unequal class sizes

Use group size to combine completion rates.

Combine unequal class sizes — original synthetic data
GroupCompletedEnrolled
Small1820
Large5480

Assumptions

  • Each learner occurs in exactly one group.
  • Completion status is known for all 100 learners.

Independent prompt: What percentage of all enrolled learners completed? State the numerator and denominator.

Show hints for exercise 1
  • Combine the counts before dividing.
  • The two classes have different numbers of learners; an equal average of their percentages changes the weighting.
Show worked answer for exercise 1

72 percent

  1. Count all completions: 18 + 54 = 72.
  2. Count all enrolled learners: 20 + 80 = 100.
  3. Compute 72 / 100 × 100 = 72%.

The population contains 100 learners, so each learner gets equal weight. The group rates, 90% and 67.5%, should not receive equal group weight.

Common wrong answers

  • 78.75: This is (90 + 67.5) / 2: it gives a group of 20 the same weight as a group of 80.

2. Average cost per notebook

Weight unit costs by quantities.

Average cost per notebook — original synthetic data
BatchNotebooksCost per notebook (dollars)
First102
Second304

Assumptions

  • All notebooks are interchangeable for this calculation.
  • Costs include all charges; quantities are fully received.

Independent prompt: What is the average cost per notebook across both batches?

Show hints for exercise 2
  • Compute total dollars spent on each batch.
  • Divide total dollars by total notebooks, not by the number of batches.
Show worked answer for exercise 2

3.5 dollars per notebook

  1. First batch cost: 10 × 2 = 20 dollars; second batch cost: 30 × 4 = 120 dollars.
  2. Total cost is 140 dollars for 40 notebooks.
  3. 140 / 40 = 3.50 dollars per notebook.

Each notebook, rather than each purchase event, is the unit being averaged.

Common wrong answers

  • 3: Averaging the two listed unit prices ignores that three times as many notebooks cost 4 dollars.

3. Count removable exact duplicates

Distinguish excess rows from every row in a duplicate group.

Count removable exact duplicates — original synthetic data
Learner IDWorkshop
AMapping
AMapping
BCharts
CTables
CTables
CTables

Assumptions

  • A duplicate means identical values in both columns.
  • Keep one copy of each distinct row; no empty values occur.

Independent prompt: How many rows are removed when one copy of each distinct row is retained?

Show hints for exercise 3
  • Count how many copies to retain, not how many rows belong to a repeated group.
  • For a group containing n identical rows, remove n − 1.
Show worked answer for exercise 3

3 rows

  1. There are six input rows and three distinct rows: A/Mapping, B/Charts and C/Tables.
  2. The A group removes one excess row; the C group removes two.
  3. Total removed: 1 + 2 = 3 rows.

Five rows belong to duplicate groups, but retaining one from each group means only three are removable.

Common wrong answers

  • 5: This counts all rows in repeated groups, including the copies that must remain.
  • 2: This counts repeated groups, not excess rows.

4. Count repeated identifiers

Keep repeated keys distinct from identical rows.

Count repeated identifiers — original synthetic data
Record keyState
K1draft
K1final
K2draft
K3draft
K3final
K3archived

Assumptions

  • A repeated key is any key appearing more than once.
  • Different states are meaningful; do not remove rows based on the key alone.

Independent prompt: How many distinct keys occur more than once?

Show hints for exercise 4
  • Group by the first column only.
  • Count groups whose size exceeds one; do not sum their row counts.
Show worked answer for exercise 4

2 keys

  1. K1 appears twice, K2 once and K3 three times.
  2. Only K1 and K3 meet the more-than-once condition.
  3. There are two repeated keys; all six full rows are different.

Repeated identifiers can signal multiple versions, not accidental copies. This question counts groups and does not authorize deletion.

Common wrong answers

  • 3: This is the number of excess occurrences if one row per key were retained, a different question.
  • 0: There are no identical full rows, but there are repeated keys.

5. Average only observed readings

State the missing-value policy and keep genuine zeros.

Average only observed readings — original synthetic data
RecordReading
R10
R210
R3null (not observed)
R45
R5null (not observed)

Assumptions

  • null means not observed, never zero.
  • Compute the mean of observed readings only.
  • No claim is made about the mean of all five underlying true values.

Independent prompt: What is the mean of the observed readings, retaining the real zero?

Show hints for exercise 5
  • A real zero is a measured value and belongs in the denominator.
  • Write both the included values and the number of included values.
Show worked answer for exercise 5

5 reading units

  1. Observed readings are 0, 10 and 5; the two null entries are excluded.
  2. Their total is 15 and their count is three.
  3. 15 / 3 = 5 reading units.

The observed mean uses three readings. Treating unknown values as zero invents observations; deleting the genuine zero also changes the question.

Common wrong answers

  • 3: Dividing 15 by all five records silently treats the missing readings as zero.
  • 7.5: Dropping the real zero leaves only 10 and 5 and overstates the observed mean.

6. Report a bound with unknown statuses

Distinguish a lower bound from a completed-data estimate.

Report a bound with unknown statuses — original synthetic data
LearnerStatus
L1complete
L2complete
L3complete
L4complete
L5complete
L6incomplete
L7incomplete
L8null (not observed)
L9null (not observed)
L10null (not observed)

Assumptions

  • Every row is a distinct enrolled learner.
  • null means completion status unknown.
  • Known statuses are correct; unknown learners may be complete or incomplete.

Independent prompt: What is the smallest possible completion percentage among all ten enrolled learners?

Show hints for exercise 6
  • Use every enrolled learner in the denominator.
  • A lower bound is a possible minimum, not a claim that unknown statuses are actually incomplete.
Show worked answer for exercise 6

50 percent

  1. Five of ten learners are definitely complete.
  2. The minimum occurs if none of the three unknown learners is complete.
  3. 5 / 10 × 100 = 50%. The maximum would be 8 / 10 × 100 = 80%.

Completion lies between 50% and 80% under these assumptions. The observed-status rate of 5/7 does not identify the whole group's rate.

Common wrong answers

  • 71.428571: This approximately describes only the seven known statuses, not the minimum among all ten learners.
  • 80: This is the upper bound if all three unknown statuses are complete.

7. Separate points from relative growth

Subtract rates when the requested unit is percentage points.

Separate points from relative growth — original synthetic data
PeriodCompletedEnrolled
Before20100
After25100

Assumptions

  • The periods contain comparable groups for this descriptive calculation.
  • No causal effect is inferred.

Independent prompt: How many percentage points did the completion rate increase?

Show hints for exercise 7
  • Express both rates as percentages first.
  • Use subtraction without dividing by the baseline percentage.
Show worked answer for exercise 7

5 percentage points

  1. The rates are 20 / 100 = 20% and 25 / 100 = 25%.
  2. Subtract the percentages: 25 − 20 = 5.
  3. The increase is 5 percentage points; the relative increase is a different quantity.

A change from 20% to 25% is 5 percentage points. Its 25% relative increase uses another denominator and unit.

Common wrong answers

  • 25: This is relative percentage growth, not the percentage-point difference.

8. Find relative growth from a baseline

Use the original count as the denominator of relative change.

Find relative growth from a baseline — original synthetic data
PeriodCompleted projects
Before20
After25

Assumptions

  • These are counts across equally long periods.
  • The original count is nonzero.

Independent prompt: What is the percentage increase in completed projects relative to the original count?

Show hints for exercise 8
  • Subtract to find the increase in projects.
  • The baseline is the original period, not the final period.
Show worked answer for exercise 8

25 percent

  1. The absolute increase is 25 − 20 = 5 projects.
  2. Divide the increase by the original 20 projects: 5 / 20 = 0.25.
  3. Multiply by 100 to express 25% relative growth.

Relative growth compares the change with the original amount. Counts are not rates, so an absolute increase of five projects is not five percentage points.

Common wrong answers

  • 20: Dividing the increase by the final 25 uses the wrong baseline.
  • 5: This is the increase in projects, not its percentage relative to the original count.

9. Interpret a flagged document

Use the requested conditional denominator.

Interpret a flagged document — original synthetic data
Actual document stateFlaggedNot flagged
Has formatting error82
No formatting error3258

Assumptions

  • All 100 documents were checked and the actual state was verified.
  • Each document appears in exactly one cell.
  • This is a synthetic document example, not a model accuracy claim.

Independent prompt: Among flagged documents, what percentage actually has a formatting error?

Show hints for exercise 9
  • The words 'among flagged' determine which column is the denominator.
  • Count both correct and incorrect flags.
Show worked answer for exercise 9

20 percent

  1. There are 8 + 32 = 40 flagged documents.
  2. Eight of those 40 actually have an error.
  3. 8 / 40 × 100 = 20%.

The 80% rate of flagging erroneous documents (8/10) answers a different conditional question. Both quantities can be true at once.

Common wrong answers

  • 80: This is the percentage of erroneous documents that were flagged, reversing the condition.
  • 8: This divides by all 100 documents instead of the 40 flagged documents.

10. Choose the requested middle value

Compute a median without substituting a mean.

Choose the requested middle value — original synthetic data
TaskMinutes
A4
B5
C100
D5
E6

Assumptions

  • All five observations are genuine and equally weighted.
  • The question asks for a median, not a prediction of a future task.

Independent prompt: What is the median task duration?

Show hints for exercise 10
  • Sort the values numerically.
  • Choose the middle position; do not average all values.
Show worked answer for exercise 10

5 minutes

  1. Order the observations: 4, 5, 5, 6, 100.
  2. With five observations, the third is the middle value.
  3. The median is 5 minutes; the mean is 120 / 5 = 24 minutes.

The median is defined by position. The unusually long task affects the mean much more, but it is not automatically an error to delete.

Common wrong answers

  • 24: This is the arithmetic mean, not the median.
  • 100: This is the middle row of the unsorted display; a median requires ordering the values.

11. Compare with explicit subgroup weights

Separate an aggregate comparison from an equally weighted subgroup comparison.

Compare with explicit subgroup weights — original synthetic data
MethodDifficultySuccessfulAttempted
AEasy910
AHard30100
BEasy80100
BHard210

Assumptions

  • Success means the same outcome in every row.
  • Compute a descriptive standardized comparison giving Easy and Hard equal 50% weights for each method.
  • These data do not establish a causal benefit or justify a universal population weighting.

Independent prompt: Under equal Easy/Hard weights, how many percentage points higher is method A's success rate than method B's?

Show hints for exercise 11
  • Compute one rate per method and difficulty.
  • Use the specified 50/50 weights, not the observed numbers of attempts.
Show worked answer for exercise 11

10 percentage points

  1. Method A subgroup rates: 9/10 = 90% and 30/100 = 30%; their equal-weight average is 60%.
  2. Method B subgroup rates: 80/100 = 80% and 2/10 = 20%; their equal-weight average is 50%.
  3. The standardized difference is 60 − 50 = 10 percentage points. Raw aggregate rates would rank B above A because the subgroup mixes differ.

Equal subgroup weights are a chosen comparison policy. The raw aggregates, 39/110 and 82/110, answer a different question; neither automatically estimates a causal effect.

Common wrong answers

  • -39.090909: This approximately subtracts raw aggregate rates, ignoring the explicitly requested equal subgroup weights.
  • 20: This adds the two ten-point subgroup advantages instead of averaging them.

12. Count a union once

Remove the overlap when combining two memberships.

Count a union once — original synthetic data
MembershipLearners
Spreadsheet workshop30
Chart workshop22
Both workshops12

Assumptions

  • Counts refer to distinct learners within each workshop.
  • The twelve learners in both are already included in each of the first two counts.
  • No other workshops are part of this question.

Independent prompt: How many distinct learners attended at least one of the two workshops?

Show hints for exercise 12
  • A learner attending both contributes one to each workshop count.
  • For 'at least one', keep the overlapping learners once.
Show worked answer for exercise 12

40 learners

  1. Adding the workshop counts gives 30 + 22 = 52 memberships.
  2. The twelve learners in both were counted twice.
  3. Subtract them once: 52 − 12 = 40 distinct learners.

The union includes single-workshop and both-workshop learners. Subtracting the intersection twice would count only people who attended exactly one workshop.

Common wrong answers

  • 52: This counts memberships rather than distinct learners.
  • 28: Subtracting the overlap twice counts exactly one workshop, excluding learners who attended both.

Plan practice with less support · Build a recall-and-feedback session · Schedule a later attempt

Original exercise content is CC BY 4.0; the downloadable package states its scope and attribution. Arithmetic checks do not establish teaching outcomes or accessibility in every delivery platform.

Download the standalone practice kit

Make a useful record · No signup

Build a small data-reasoning work sample

Practice calculations and recommendations with three original synthetic business scenarios.

  1. Choose a scenario. Use its dataset below, enter the count and percentage requested, then write a short recommendation that separates evidence from assumptions.
  2. Support queue: A new queue starts empty. During one day, 48 tickets arrive and 36 of those tickets close. No tickets reopen. Count question: How many tickets remain open? Percentage question: What percentage of arriving tickets closed? Reasoning prompt: Identify an additional measure of resolution quality before recommending staffing changes.
  3. Newsletter delivery: One newsletter is sent to 240 addresses. It reaches 228 addresses, and 19 distinct recipients click at least once. Treat all counts as accurate for this exercise. Count question: How many addresses did not receive the newsletter? Percentage question: What percentage of delivered recipients clicked? Round to two decimals. Reasoning prompt: Name a way to assess reader usefulness without treating clicks as proof of value.
  4. Inventory reconciliation: A shelf starts with 80 units. During one day, 28 units sell and 4 other units are damaged and removed. There are no receipts or returns. Count question: How many saleable units remain? Percentage question: What percentage of starting units sold? Reasoning prompt: Identify what else you need before choosing a reorder quantity.
  5. Calculate before checking your answer. Export the result with your reasoning as a practice work sample.

Enter observations you can support. Leave unknowns blank or choose Unknown. Inputs stay in this page; reloading clears them. Do not enter passwords or personal customer information.

Your observations
Write at least 40 characters: explain the denominator, one practical next action, and one thing the data cannot establish. This length check does not grade quality. Do not include private business information.
Try a fictional worked example

Examples demonstrate the tool. They are not your observations and do not count as completed reader work.

Enable JavaScript to calculate and download a result.

Did this result help you decide your next step?

Use this checklist on paper
  1. Practice scenario
  2. Your count answer
  3. Your percentage answer (for 75%, enter 75)
  4. Your recommendation, supporting evidence and limitation — Write at least 40 characters: explain the denominator, one practical next action, and one thing the data cannot establish. This length check does not grade quality. Do not include private business information.

Record the date, source and unknowns, then list what to check next. A filled worksheet is not independent verification.

What this tool can and cannot establish
  • All datasets are invented for practice and describe no real company or person.
  • The two numeric answers are scored automatically. Written reasoning requires your own review against the rubric.
  • A completed exercise is not proof of job readiness, mastery, course completion or certification.

Completed means the required input record was filled, not that every check passed. Where audience measurement is enabled, only fixed completion, export and feedback identifiers are counted; entered values and notes are not sent.

This is a research guide based on cited documentation. It is not a report of firsthand testing. Our editorial method

Make the counting policy explicit

A calculation can be arithmetically correct while answering the wrong question. These twelve original problems ask you to identify the observation, counting rule and denominator before computing a result. Every table is synthetic; none describes a real learner, customer, model or vendor.

The examples cover weighted completion and cost, excess duplicate rows and repeated keys, observed-only averages and completion bounds, percentage points and relative growth, flagged-document precision, median, subgroup weights and overlapping memberships. Use paper or an optional calculator; no account or paid software is needed.

Choose the amount of support

Start with an independent prompt and write your calculation plus one sentence naming the denominator. Open the hints only if you need them, then compare your reasoning with the worked answer and the common wrong answers. The downloadable educator package contains every table, assumption, hint and key.

Worked, partially supported and independent variants use the same numbers. A successful repeat attempt is practice, not evidence that you can solve an unseen problem. For a teaching pilot, ask an educator to review the task and design a changed-number follow-up before claiming transfer.

Preserve what missing and duplicate mean

A real zero is an observation. A null in these tables means not observed, so its treatment depends on the stated question. An observed-only mean excludes missing readings; a completion lower bound keeps all enrolled learners in the denominator and leaves unknown statuses unknown.

Duplicate rows and duplicate keys also answer different questions. Keeping one copy of an exact row does not authorize deleting different records that happen to share a key. Write the policy before copying a formula into a spreadsheet.

Reuse and review boundaries

The original exercise text, synthetic tables and explanatory answer keys are available under CC BY 4.0. Credit Skills Path / Editorial Desk Media, link the material and license, and identify adaptations. This scope excludes existing site software, other publications, unrelated downloads, trademarks and linked third-party material. [1]

Arithmetic is recomputed by automated tests. Educator review has not been obtained, no teaching uses have been observed, and no learning-outcome claim is made. The text-only package includes accessibility adaptation notes; inspect the actual teaching platform and learner needs before relying on them.

Take it with you

Download all twelve exercises and the educator answer key

Download worksheet

Sources & verification

Product details and prices can change. Check the linked provider before buying.

  1. Creative Commons Attribution 4.0 International Accessed 14 Sep 2026

Sources link directly to providers. Product buttons may use separately labeled affiliate links. Read our disclosure.

Your decision at a glance

Compare the options

Full comparison

Documentation-based guidance. No tested ranking or performance score.

Learning subscription

Coursera Plus

Consider it for
Consider Coursera Plus when several included programs fit a realistic study calendar. Compare a single course for a narrow skill, and check whether an existing subscription already covers the work.
Starting cost
Regular US monthly $59 (7-day free trial) or annual $399 upfront with a 14-day money-back guarantee; promotions vary, so confirm at checkout.
Before you choose
Degrees and MasterTrack programs are excluded; some courses are not included. Certificates are not employment outcomes. Check inclusion and the current checkout.

Checked 29 Oct 2026 · Pricing source

View Coursera Plus plans

Direct provider link; no affiliate tracking added by this publication. Link disclosure

Coding courses

Educative

Consider it for
Text-based coding instruction with browser practice. Inspect the exact course and plan before subscribing.
Starting cost
Confirm checkout total, billing term and renewal price for the selected plan.
Before you choose
Educative granted us free review access. This is documentation research; we have not completed or tested a course. Confirm inclusion, renewal and cancellation conditions before paying.

Checked 21 Sep 2026 · Pricing source

View Educative plans

Affiliate link: we may earn a commission on an eligible purchase. Link disclosure

Free courses with paid certificates

Alison

Consider it for
Free CPD-accredited online courses with optional certificate or diploma purchases.
Starting cost
Courses free; certificate/diploma purchase optional — confirm checkout
Before you choose
We have not completed an Alison course. Paid certificates are optional; confirm the recipient accepts the credential before paying.

Checked 17 Sep 2026 · Pricing source

View Alison plans

Affiliate link: we may earn a commission on an eligible purchase. Link disclosure