Tutorvo

Fitting the Model: Regression with LINEST

Lesson 4 of 816 minLab

This lesson is part of the course

In this lesson

You fit sales = base + TV adstock + Search + Social with LINEST, read the coefficients in the right order, check R² and build the fitted sales line.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Exploring Weekly Sales vs. Media SpendLab14 min Locked
  2. Adstock: How Advertising Carries OverLab15 min Locked
  3. Diminishing Returns: The Saturation CurveLab15 min Locked
  4. Fitting the Model: Regression with LINESTLab16 min Locked
  5. Decomposition: Base vs. Channel ContributionsLab15 min Locked
  6. ROI and Marginal ROI per ChannelLab15 min Locked
  7. Budget Reallocation: Same Money, More SalesLab16 min Locked
  8. Multi-Touch Attribution Rules on a Path TableLab17 min Locked