A weighted average on the other hand considers one or more numbers in the range to be worth more or have a greater weight than the other numbers. Draw a table with two columns with one column contains values the other contains their weights. Suppose your teacher says The test.
SUMPRODUCTweights values SUMweights.
In the Insert Calculated Field dialog box please type Weight Average in the Name box type AmountWeight please change the formula based on your field names in the Formula box and then click the OK button. Draw a table with two columns with one column contains values the other contains their weights. Ive included one for you. This is because Excel doesnt provide a function in the Pivot Table that automatically calculates the weighted average.