After completing the time distribution analysis of price and order volume, it is necessary to conduct a price regional distribution analysis.
First, download and open the “User Price Distribution Analysis” Excel table.
There are three types of data, namely “purchase-date” (purchase time), “item-price” (commodity price), and “ship-state” (shipping state). When conducting price regional distribution analysis, the data required by the operator are “ship-state” and “item-price”, so the “purchase-date” column can be temporarily deleted.
The subsequent operation is to “filter” the “ship-state”, and then select different states and regions to calculate their average customer unit price. The time “filter” operation described in this operation is basically the same, so it will not be repeated here. After completing the “filter” operation and calculating the average customer unit price in each state region, the relevant table is obtained.
Select the data in the table to make a bar chart.
Although this bar chart can be used to compare the average customer unit price in each region, the data in the chart itself is not very different. In order to facilitate comparison, the operator needs to define a “comparison number”, and its numerical calculation rules are as follows:
Comparison number = average customer unit price – lowest average customer unit price
The lowest average customer unit price is 19, so a new data table is obtained based on this value.
Based on the “comparison number” value, a bar chart with more intuitive data comparison is obtained.