Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weighted scores
I've created a scoring form for a call monitoring quality assurance. In the
spreadsheet, there are two scores- the 1st score grades them on their telemarketing skills as well as required standards. The second score grades them on their soft skills. To get the grand total of the whole call, I added both scores and divided by 2. But I would like to somehow give more weight on the 1st score. Is there any way to do this? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weighted scores
=((A2*$M$1)+B2)/(1+$M$1)
where M1 contains the weighting factor -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "April601" wrote in message ... I've created a scoring form for a call monitoring quality assurance. In the spreadsheet, there are two scores- the 1st score grades them on their telemarketing skills as well as required standards. The second score grades them on their soft skills. To get the grand total of the whole call, I added both scores and divided by 2. But I would like to somehow give more weight on the 1st score. Is there any way to do this? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
Take out judges scores | Excel Worksheet Functions | |||
Problem Importing Fixed Width Data | New Users to Excel | |||
Football Scores | Excel Discussion (Misc queries) | |||
Golf Handicap Using Last 5 Scores | Excel Worksheet Functions |