In Sheets, type the formula that predicts sales at an ad spend of 12 from sales in C2:C7 and ad spend in B2:B7.
In Sheets, type the formula that predicts sales at an ad spend of 12 from sales in C2:C7 and ad spend in B2:B7.
Answer
=FORECAST.LINEAR(12, C2:C7, B2:B7)
54.71 — but 12 is outside the 2–10 range of the data: extrapolation. The formula computes it; the analyst decides whether to quote it.
OpenStax Introductory Statistics 1e §12.5 (CC BY 4.0) — the extrapolation example shape, adapted; data original