Description: 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.
Example: =WeightedMean(A1:A10,
B1:B10)
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
