With prices oscilating between "regular" and "discounted"/"reduced" it is hard to understand where the price is in the average.
Average by itself is prone to outliers, the median is more robust.
For the time range, maybe a month is a reasonable default.
This could be a base value for a relative price: How does a single price compare to a longer term price? Is the "regular" price very much higher than the medium term price, or is the "reduced" price just a little below that?
Could be also relevant to a selection of products, to compare against each other.
With prices oscilating between "regular" and "discounted"/"reduced" it is hard to understand where the price is in the average.
Average by itself is prone to outliers, the median is more robust.
For the time range, maybe a month is a reasonable default.
This could be a base value for a relative price: How does a single price compare to a longer term price? Is the "regular" price very much higher than the medium term price, or is the "reduced" price just a little below that?
Could be also relevant to a selection of products, to compare against each other.
Example: What is a reasonable price per egg for organic chicken eggs size L, and how do they compare over time? Spar and Billa seem to discount them very often but only for a short time.