Program and use computers to store, process, and analyze data.
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 65% of those conversations; the rest were back-and-forth with the person. This label was updated from real usage data.
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 biologist. Part of my job is to program and use computers to store, process, and analyze data. Context: We use IBM SPSS Statistics and The MathWorks MATLAB; the work draws on biology, chemistry and education and training. Data: [paste table] Question: [what relationships matter] Analyze correlations and trends with code or formulas. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.
10-minute exercise: Find trends and relationships
AI makes arithmetic mistakes. Recompute anything that matters with a spreadsheet formula.
Importance 4.1/5 · core task · O*NET work activity: Analyze data to identify trends or relationships among variables.. Also involves: Write computer programming code.; Operate computers or computerized equipment..