Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Numeric functions

Buy now

Download now

LITlib - Excel Power Functions Pack
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - WeightedMean function
litLIB Help
Product pages :
Quick links:
help index

Numeric - WeightedMean

=WeightedMean(Numbers, Weights)

Calculates the weighted mean of the numbers.

When the weights are all 1 (or otherwise equal) the weighted mean is equal to the unweighted average. The weighted mean is the sum over i of Numbers(i) * Weights(i) devided by the sum of all the weights.

The weights cannot 0 or negative.

Numbers: Cell range where the numbers are stored.
Weights: Cell range where the weights are stored.

=WeightedMean(A1:A10, B1:B10)