In Sheets, sales are in C2:C7 and ad spend in B2:B7. Type the formula for the slope of sales on ad spend.
In Sheets, sales are in C2:C7 and ad spend in B2:B7. Type the formula for the slope of sales on ad spend.
Answer
=SLOPE(C2:C7, B2:B7)
known_y first, then known_x: 3.4524. Reversed, it is the slope of ad spend on sales — a different number, no error.
OpenStax Introductory Statistics 1e §12.3 and Introductory Business Statistics 1e §13.4 (CC BY 4.0) — least-squares line, slope reading and residual sign, adapted; data original