WeightedMean
[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.
NAVIGATION LINKS
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