Collect and analyze data on customer demographics, preferences, needs, and buying habits to identify potential markets and factors affecting product demand.
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 market research analyst / marketing specialist. Part of my job is to collect and analyze data on customer demographics, preferences, needs, and buying habits to identify potential markets and factors affecting product demand. Context: We use Tableau and SAS; the work draws on sales and marketing, administration and management and customer and personal service. Data: [sales, demographics] Goal: [buying, product decisions] Find trends and recommendations. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.
10-minute exercise: Consumer trend analysis
AI makes arithmetic mistakes. Recompute anything that matters with a spreadsheet formula.
Importance 3.9/5 · core task · O*NET work activity: Analyze consumer trends..