[this page | pdf | back links]

Function Description

Returns , the weighted mean of a series  given weights  (for ), calculated as follows:




There is no immediately equivalent function in Microsoft Excel, although it can be calculated relatively easily using SUMPRODUCT and SUM.


See Weighted Moments and Cumulants for further details and explanation of terms in this formula. If the weights are equal then returns the same as MnMean.


Contents | Prev | Next

Links to:

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other Statistical functions

-          Computation units used

Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement

Desktop view | Switch to Mobile