Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weighted Average of Variance
I am trying to find weighted averages of price variances for several
salespeople. They may have several accounts and they could have exceeded, matched, or missed their sales target. I am trying to find their average variance. This is what I am trying to do but can't figure it out. (# of specific fruit)/(total of all fruit)*(amount above or below target price) ID # Sales Mgr Amt. Above/Below Tgt X1 Smith -$7 X2 Smith $5 X1 Smith -$7 Y1 Jones $10 Y1 Jones $10 Y2 Jones -$15 Y2 Jones -$15 Y2 Jones -$15 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weighted Average | Excel Worksheet Functions | |||
weighted average | Excel Worksheet Functions | |||
weighted average | Excel Discussion (Misc queries) | |||
Weighted Average | New Users to Excel | |||
Weighted Average | New Users to Excel |