Statistically explain the weight of sales comming from same region
Posted on 2011-09-19
Hi you all geniouses,
I have the attached set of sales. This sales are from a trading company. The company connects vendors and sellers and arranges fleet services for them (more or less like Amazon.com). Basically I can see that there is an obvious impact on purchases (or sales) given that the vendor is local. For instance, Region 8 Vendors sell 83 thousand dollars to buyers within this region, and the second most important buying region is Region #1 with 57 thousand. Of course Region 1 is way greater in terms of population and market size, nonetheless, Region 8 sellers manage to sell considerably more to buyers in its region.
There is indeed also a big impact on sales given the size of the region itself. For example, region 1 is the greatest buyer and seller to all other regions except from same region transactions.
I want to make some smart conclusions on whether making available all the products of all regions to all other regions will have any impact.
Can you help me out, on how to structure this problem?