| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question - weighted sales/distribution
Hello - I am trying to calculate a weighted distribution problem, and I can't seem to come up with the correct calculation.
BRAND_X 1301512 97 BRAND_Y 691257 84 BRAND_Z 716962 41 BRAND_X had distribution in 97% of our accounts and sales of 1301512. BRAND_Y had distribution in 84% of our accounts and sales of 691257. BRAND_Z had distribution in 41% of our accounts and sales of 716962. How can I calculate the ranking of these items based on their distribution and sales? As you can see from the example, BRAND_Z has good sales but small distribution. Thanks for any assistance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROPORTIONATE DISTRIBUTION - CHALLENGING QUESTION 4 SURE | Excel Discussion (Misc queries) | |||
| Even Distribution of Students now with a Weighted Twist | Excel Worksheet Functions | |||
| Weighted average question | Excel Worksheet Functions | |||
| formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
| Weighted Average Question | Excel Programming | |||
Threaded Mode
