Do ads move your sales, or is it price?
Everyone has a theory about what drives the numbers. Regression settles it: it measures how much each factor moves your outcome, and puts a p-value on each so you know which effects are real and which are noise.
Analytics Advanced Regression free
After you install, this is the model to open.
What Actually Drives Your Sales?
- In your spreadsheet, click the Sortia icon in the strip of icons down the right-hand edge. No strip? Click the arrow at the bottom-right to open it. You can also use Extensions, then Sortia, then Open Sortia.
- Click Start from a template and put that name in the search box.
- Pick the card with that name and click Load this template. It arrives on a new tab with real numbers already in it.
The answer
What the regression finds:
- Fit (R²)
- 0.99
- Ad spend
- +5.5 /$1 · p<.001
- Price
- −15.6 /$1 · p=.003
- Both real?
- Yes
Both are genuine drivers here: each extra $1 of ad spend adds about 5.5 in sales (p < 0.001), and each $1 of price costs about 15.6 (p = 0.003), together explaining 99% of the variation. A p-value under 0.05 means it is signal, not luck. Replace the columns with your own outcome and suspects: sales, tips, sign-ups, anything.
The model
Fit Sales = b0 + b1·(Ad spend) + b2·(Price) across your history. The full output includes R², coefficients, p-values, and confidence intervals.
| Outcome (Y) | Sales |
| Possible drivers (X) | Ad spend, Price |
| History | 8 periods |
| Fits | Y = b0 + b1·X1 + b2·X2 |
Once it is in your sheet
- The model arrives with real numbers in it and runs as it stands, so you can press the button first and understand it second.
- Change the numbers to yours. The sheet marks which cells are inputs and which hold formulas, and most labels carry a note explaining the row.
- Press the run button at the bottom of the panel. It is labeled for the tool you are in, and the result lands on its own tab, with a written reading of it beside the figures.
Never used Google Sheets? Start here goes the whole way, in seven steps, and assumes nothing.
Next question
- Which subscribers are about to cancel?Churn Early-Warning Scorecard
- How good is each team, really?Power Ratings & Spread Predictor
- How many survey responses do you actually need?Survey Sample Size Planner
- Version B is up 18%. Is that a real win or just noise?Did the A/B Test Actually Win?
- Why are most of your flags false alarms?Bayes Flip: P(A|B) vs P(B|A)
- Your dashboard says stores win. Does the data agree?Simpson's Paradox Detector
Every model like this one, and the method behind them: Statistics in Google Sheets.