Hi guys,
I am using LINEST Array to calculate price elasticity and its related coefficients. For a multi-product portfolio.
Y values: Monthly Price elasticity for each SKU
X Values: Coefficitents for 5 items:
Season (4 separate coefficients)
Relative price level vs substitute products
Right...