View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Whitney Whitney is offline
external usenet poster
 
Posts: 40
Default weighted average

I would like to calculate a weighted average for an overall score.

Example:
5 point scale
Quality - 3 weighted at 50%
Attendance - 4 weighted at 25%
Productivity
Hold Time - 2 weighted at 12.5%
Wrap Up - 3 weighted at 12.5%
Overall Score = average of the above
without weighting = 3
with weighting = ?
What formula can I use for the overall score to calculate a weighted average?