Controlling for Promotions & Seasonality with LINEST
This lesson is part of the course
In this lesson
You show that a price-only regression overstates the elasticity of the Cold Brew 4-pack when price cuts come with promotions, and fix it with LINEST and two dummy variables.
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
- Arc vs Point Elasticity from Real Price Changes Locked
- Log-Log Regression: Elasticity as a Slope Locked
- Controlling for Promotions & Seasonality with LINEST Locked
- Cross-Price Elasticity: Substitutes and Competitors Locked
- Revenue- and Profit-Maximising Price: The Markup Rule Locked
- Demand Curve & Profit Curve: Finding the Peak Locked
- Segment Elasticities: Online vs Store Locked
- Price Test Design & Reading the Results Locked