Syntha Lab RU

Elasticity from a price and sales table: log-log regression with an interval

From a table of prices and sales over equal periods estimates the price elasticity of demand by least squares in logarithms, shows the confidence interval, the goodness of fit, the forecast of sales and gross profit at a new price and the profit-maximizing price.

Cost and price For whom: Pricing managers and analysts who want to estimate the demand reaction to price from history.

Calculate on your data →

At a glance

What question does it answer?
How sales followed the price, how sure the estimate is and what it promises at a new price.
What data is needed?
A table of periods: the average price excl. VAT and sales in units.
How to read the result?
Example on the default values (10 periods, illustrative data): elasticity −1.73, the interval from −1.92 to −1.54, R² 98.2%; when the price falls from 4,500 to RUB 4,300 sales rise by 8.2%, gross profit per period changes by −RUB 99,838. Example on the default values: Demand elasticity: −1.7 (−1.73); Interval: lower bound: −1.9 (−1.92); Interval: upper bound: −1.5 (−1.54); Standard error of elasticity: 0.1 (0.083). The figures are illustrative: enter your own to see your result.

Why and how to reason

Elasticity shows by how many percent sales change if the price changes by one percent. To estimate it, take real periods with different prices and look at how sales changed. The relationship is non-linear: a rise of 100 from 3,600 affects demand more than from 5,400. So both measures are taken in logarithms, and the slope of the line in logarithms is the elasticity. For ten periods it came out at minus 1.73: a 1% rise in price lowers sales by 1.73%. The interval from minus 1.92 to minus 1.54 shows how reliable the estimate is. R² of 98% says price explains almost all the variability. Cutting the price from 4,500 to 4,300 (−4.4%) gives +8.2% sales, but gross profit falls by 100 thousand: margin per unit fell from 2,300 to 2,100.

When to use it

This is the calculation for the case when you have a history of prices and sales for comparable periods without other strong influences (promotions, stock-outs, season) and need to decide whether to change the price. Do not use it if price changed together with other factors: the estimate will carry the influence of others onto price. Assumptions: elasticity is constant over the price range, periods of equal length, no prices outside the observed range.

How to read the result

First check the interval: it is narrow (−1.92 to −1.54), so the estimate is stable, and both bounds exceed one in absolute value. With elasticity above one in absolute value a price cut raises revenue but not necessarily profit: here +8.2% sales do not cover the loss of margin. The price of maximum gross profit (5,226) is above the present one: the model advises raising the price, but do not go beyond the data range (the maximum observed is 5,400). Check R² and the number of periods: at R² below 60% or fewer than six periods the estimate is unreliable. It is worth keeping the interval in your notes: at the next recalculation you will see whether customer sensitivity to price has changed.

Common mistakes

Typical trap: taking periods with and without promotions, not entering cost, extrapolating beyond the price range, treating a causal link as proven by correlation alone, mixing SKUs of different categories. For reliability confirm the estimate with a small price test on part of the traffic. Be especially careful with short series: ten points give only a guide, and an error in one point shifts the whole result.

What data is needed?

  • A table of periods: the average price excl. VAT and sales in units.
  • The current and the new price.
  • Unit cost for profit.

Inputs

FieldUnitValue in the exampleMeaning
Current price₽4,500The price excl. VAT the change is counted from. The example value is illustrative.
New price₽4,300The price excl. VAT you test. Outside the table range the forecast is unreliable.
Unit cost₽2,200For gross profit and the profit-maximizing price. May be left empty.

How it is calculated

StepFormula
Logarithmsx = ln(price), y = ln(sales)
Elasticitye = Σ(x − x̄)(y − ȳ) ÷ Σ(x − x̄)²; a = ȳ − e × x̄
Intervale ± t(0.975; n − 2) × s ÷ √Σ(x − x̄)²
Forecastsales = exp(a + e × ln(price))
Maximising pricep* = cost × e ÷ (1 + e) when e < −1

Worked numbers

Default values from the app; in the interactive version you enter your own.

Demand elasticity
−1.7 (−1.73)By how many percent sales change when the price rises 1%.
Interval: lower bound
−1.9 (−1.92)
Interval: upper bound
−1.5 (−1.54)
Standard error of elasticity
0.1 (0.083)
R²
98.2 %What share of the scatter in sales the price explains.
Periods in the estimate
10
Sales at the current price (by the model)
3,505 units
Sales at the new price (by the model)
3,791 units
Change in sales
+8.2 %
Change in gross profit
−99,838 ₽Per period, by the model.
Gross profit maximising price
5,226.42 ₽Only within the data range and at constant elasticity.
Sales and price in logarithms with the regression line
Scatter plot: 10 points; regression line: y = 22.689 + −1.727·x7.888.28.48.68.18.28.38.48.58.68.19; 8.578.24; 8.428.29; 8.48.34; 8.248.39; 8.228.43; 8.18.48; 8.18.52; 7.958.56; 7.928.59; 7.84ln price↑ ln sales
  • points
  • regression line: y = 22.689 − 1.727·x
Data as a table
ln priceln sales
8.198.57
8.248.42
8.298.4
8.348.24
8.398.22
8.438.1
8.488.1
8.527.95
8.567.92
8.597.84
Demand curve from the estimate
Scatter plot: 10 points2,0003,0004,0005,0006,0007,0003,0003,5004,0004,5005,0005,5006,0003,600; 5,2703,800; 4,5254,000; 4,4454,200; 3,7804,400; 3,7104,600; 3,3054,800; 3,2955,000; 2,8405,200; 2,7655,400; 2,540Price↑ Sales, units
  • points
  • regression line
Data as a table
PriceSales, units
3,6005,270
3,8004,525
4,0004,445
4,2003,780
4,4003,710
4,6003,305
4,8003,295
5,0002,840
5,2002,765
5,4002,540

The table used in the estimate

PriceSalesBy the modelDeviation
3,600 ₽5,2705,1532.3 %
3,800 ₽4,5254,694−3.6 %
4,000 ₽4,4454,2963.5 %
4,200 ₽3,7803,949−4.3 %
4,400 ₽3,7103,6441.8 %
4,600 ₽3,3053,375−2.1 %
4,800 ₽3,2953,1355.1 %
5,000 ₽2,8402,922−2.8 %
5,200 ₽2,7652,7311.3 %
5,400 ₽2,5402,558−0.7 %

Elasticity from a table answers “how sales followed the price”, not “what will happen”. Prices moved together with the season, advertising and size availability, so check it with a test. For footwear and children’s count by size and the core: elasticity of the end sizes differs.

Nuances and limits

  • Reading the estimate as causal when prices moved with the season and advertising.
  • Forecasting a price outside the table range.
  • Taking out-of-stock periods: sales in them are limited by stock and not demand.

Terms used

Calculate on your data →