Nematrian
/

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

Output type / Parameter details

Output type: Double
Parameter NameVariable TypeDescription
InputArrayDouble()Array containing data series to be analysed
WeightArrayDouble()Array containing series to use to weight observations

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