The attached template provides the basis for product portfolio analysis.
The template performs the following types of analysis:
- key statistics: total, average, median, standard deviation (total and by feature)
- like-for-like (LFL) analysis
- variance analysis: price, mix and volume effects (total and by feature)
- extracting vehicle features from text description (e.g. "Comfort hatchback 1.6 manual")
- advanced statistical calculations for weighted data