In Sheets, sales are in C2:C7 and ad spend in B2:B7. Type the formula for R² of the line of sales on ad spend.
In Sheets, sales are in C2:C7 and ad spend in B2:B7. Type the formula for R² of the line of sales on ad spend.
Answer
=RSQ(C2:C7, B2:B7)
0.9972 — CORREL squared. The share of the variation in sales the line explains; no sign, 0 to 1.