Apply mathematical or statistical techniques to address practical issues in finance, such as derivative valuation, securities trading, risk management, or financial market regulation.
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 42% 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 financial quantitative analyst. Part of my job is to apply mathematical or statistical techniques to address practical issues in finance, such as derivative valuation, securities trading, risk management, or financial market regulation. Context: We use Tableau and Microsoft Power BI; the work draws on economics and accounting, mathematics and computers and electronics. Business question: [fuel cost rise, demand change, process change] Current figures: [paste] Build a scenario model with best/expected/worst cases and formulas. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.
10-minute exercise: Scenario model
AI makes arithmetic mistakes. Recompute anything that matters with a spreadsheet formula.
Rules and regulations vary by place and change often. Confirm against the official source before relying on anything.
Double-check every number. AI can make arithmetic and rounding mistakes.
Importance 4.4/5 · core task · O*NET work activity: Apply mathematical models of financial or business conditions..