Identify, analyze, and document problems with program function, output, online screen, or content.
AI finds trends and writes the spreadsheet formulas.
📊 Real AI use (Anthropic Economic Index, Apr 2026 to May 2026): AI completed the task directly in 80% of those conversations; the rest were back-and-forth with the person.
Show prompt & steps
Paste a spreadsheet or table and ask AI to find trends, outliers and totals, or to write the formula you need. It's like having an analyst on call.
Ready-to-use prompt
I work as a software quality assurance analyst / tester. Part of my job is to identify, analyze, and document problems with program function, output, online screen, or content. Context: We use Tableau and SAS; the work draws on computers and electronics, engineering and technology and design. Problem: [delays, errors, defects, protocol issues] Data: [paste logs, indicators, printouts] Find patterns that point to the cause, rank likely causes, and suggest checks and fixes. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.
10-minute exercise: Root-cause from data
AI makes arithmetic mistakes. Recompute anything that matters with a spreadsheet formula.
Importance 4.7/5 · core task · O*NET work activity: Analyze data to identify or resolve operational problems.. Also involves: Troubleshoot issues with computer applications or systems.; Document operational activities..