Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates. When you take a ...

Open Microsoft Excel. Enter the data to be averaged in column A. For example, if you had three regular tests, a midterm and a final, you might enter grades of 85, 100, 90, 80, 95 in cells A1 ...