Analyze Pasted Data

Get findings from a pasted table or CSV with magnitudes, caveats, and a clear line between what the data shows and what it can't answer.

Data:
"""
[PASTE CSV, TABLE, OR EXPORTED NUMBERS]
"""

Analyze the data above. The question I'm trying to answer: [YOUR QUESTION]
Context on where this data comes from: [SOURCE, TIME PERIOD, KNOWN QUIRKS: e.g. "Stripe export, Q2, refunds excluded"]

Work in this order:
1. **Describe before analyzing**: what the columns are, row count, time range, and anything odd you notice (gaps, duplicates, outliers, suspicious zeros). If a column's meaning is ambiguous, state the assumption you're making about it in a line starting "ASSUMING:".
2. **Findings**: 3-6 findings ranked by relevance to my question. Each finding: the claim, the numbers behind it (with magnitude; "up 34%, from 1,200 to 1,610", never just "increased"), and its biggest caveat.
3. **Correlation vs. cause**: for any relationship you found, say explicitly whether the data can support a causal claim (it usually can't) and what would be needed to test one.
4. **What this data cannot answer**: the parts of my question that need data I didn't provide, and exactly what to pull.
5. **Next queries**: 2-3 specific follow-up cuts of this data worth running, and what each would confirm or kill.

Rules: compute from the pasted data only; if the data is too small or noisy for a finding to be trustworthy, say "not enough data" for that finding instead of extrapolating. Show your arithmetic for the key numbers so I can spot-check it.

How to use

Spot-check the arithmetic on at least the headline finding: models occasionally miscompute even when the reasoning is sound, which is why the prompt forces the math to be shown. For files over a few hundred rows, use a tool with code execution and this same structure.

Originated fromStan SedberryUpdated
Data analysisintermediate

More business prompts

Build me a monthly budget and a debt payoff plan from these numbers.

Take-home income per month: [AMOUNT, and note if it varies]
Fixed costs: [RENT/MORTGAGE, UTILITIES, INSURANCE, SUBSCRIPTIONS, TRANSPORT, CHILDCARE, with amounts]
Variable spending, last 3 months if known: [GROCERIES, DINING, SHOPPING, ETC.]
Debts: [FOR EACH: name, balan

Budget and Debt Payoff Plan

Turn your real income, bills, and debts into a monthly budget and a payoff schedule with the math shown and the tradeoffs named.

Businessbeginner
Build a 13-week cash flow forecast.

Cash on hand today: [AMOUNT, and which accounts]
Any restricted or committed cash: [AMOUNT AND WHAT IT IS FOR]

Expected inflows:
- Receivables outstanding: [CUSTOMER, AMOUNT, INVOICE DATE, TERMS, and how reliably each pays]
- Recurring revenue: [AMOUNT, BILLING DATE, CHURN ASSUMPTION]
- New sales expe

13-Week Cash Flow Forecast

Build the rolling weekly cash forecast operators actually run on: opening balance, timed inflows and outflows, and the week you run short.

Businessadvanced
Help me set pricing for [PRODUCT/SERVICE].

What it does and who buys it: [PRODUCT + BUYER]
The alternative if they do not buy: [COMPETITOR, IN-HOUSE, SPREADSHEET, DOING NOTHING]
What that alternative costs them: [MONEY, TIME, RISK. Estimate if needed and say so.]
Value we create, quantified if possible: [TIME SAVED, REVENUE GAINED, COST 

Pricing Strategy

Work out what to charge and how to package it: value basis, tier structure, the metric you meter on, and how to test before committing.

Businessadvanced

Search prompts

Find a prompt by title, description, tag, or category.