Analyze·Intermediate·Playground·15 min·Updated Sep 30, 2026

Find the payroll data-entry error

Scenario

Payroll totals look higher than expected this period.

Mission

Find the one employee record with an impossible hours entry.

Start Files

EmployeeIDNameHoursHourlyRate
EMP-300A. Nguyen8031
EMP-301B. Castillo8050
EMP-302C. Petrov7651
EMP-303D. Osei8240
EMP-304E. Lindgren7943
Preview — first 5 rows of payroll-biweekly.csv

Your task

  1. Scan the Hours column for a value far outside the normal biweekly range.
  2. Confirm it's a data-entry error rather than a legitimate outlier (check the hourly rate and total pay it implies).
  3. Flag the record for correction before payroll runs.

Prompt idea:

Here is a biweekly payroll export for 16 employees. One row has an hours value that's clearly a data-entry error. Find it and tell me why it can't be real.

Check Your Result

Which employee ID has an impossible number of hours logged for the biweekly period?

Need a hint?

A normal biweekly total is well under 90 hours — look for anything wildly outside that range.

Reveal Solution

The solution files contain the completed challenge. Review the approach to see if you missed any edge cases.

Related Workflows

WORK WITH LIMINALS

Make AI useful for your team.

Get practical help with AI consulting or ask about training courses for your team.