That is his original efficiency score times the weight of efficiency 10 divided by the maximum potential weight 10. For the weighted average heres the complete manual equation. Formula to Calculate Percentile Rank.
Formula to Calculate Percentile Rank.
Find the sum of the numbers and divide by the number of integers. In the Excel template a weighted item is denoted by an asterisk. There is no built-in formula in Excel to calculate weighted averages. How to rank based on two columns in Excel.