1. Product Price Volatility Analysis
E-commerce AnalystBackground
The analyst needs to compare the price range of three different product categories to identify which items have the most volatile pricing.
Problem
Standard bar charts do not show the min-max range or outliers effectively.
How to use
Input the min, max, and median values for each product category into the Data Ranges field and select 'Line' style.
[{"label": "Electronics", "min": 100, "max": 500, "median": 250, "outliers": [50, 600]}, {"label": "Clothing", "min": 20, "max": 150, "median": 60}, {"label": "Home", "min": 50, "max": 300, "median": 120, "outliers": [400]}]Outcome
A clear range chart showing the price spread for each category, with red markers highlighting price outliers outside the standard range.