(No of Sales) (Sum total of Sales Val) (Avg Cust Age) (Combined household income) Region Sales_Vol Sales_Val Av_CustAge Household_ Inc North 562 £29,200.89 42 19-26k South 259 £10,561.52 26 18-22k East 678 £18,549.88 22 11-15k West 189 £13,609.01 47 39-55k Key Factors: Company is based in North-East of the country base level pdts: £30-£40, mid level pdt £35-£45, and leading pdts >£45 The new product is aimed to technology-savy customers that are more likely to spend their money. The main goal of the new pdt is sell as many units as possible & retail at £48.99

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Help me please-I need to identify hierarchy of regions & find regions to most desirable to least from below table.Thank You.

	(No of Sales)	(Sum total of Sales Val)	(Avg Cust Age)	(Combined household income)
Region	Sales_Vol	Sales_Val	Av_CustAge	Household_ Inc
North	562	£29,200.89	42	19-26k
South	259	£10,561.52	26	18-22k
East	678	£18,549.88	22	11-15k
West	189	£13,609.01	47	39-55k

Key Factors:
Company is based in North-East of the country
base level pdts: £30-£40, mid level pdt £35-£45, and leading pdts >£45
The new product is aimed to technology-savy customers that are more likely to spend their money.
The main goal of the new pdt is sell as many units as possible & retail at £48.99