Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Minor errata (nitpicking)....
I wrote: The real problem is with your math: the average of averages is not necessarily the same as the average of all. They are equal only [when] the divisors of each average are the same, which is not true in your example. I shouldn't say that is the "only" time they are equal. Of course, there are examples when they are equal by coincidence (e.g. when all the numbers to be averaged are equal). And there are examples when they are "close enough" to equal; for example, equal to 1 decimal place. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is This a Pivot? A SumProduct? A SumPivot? Matrix? | Excel Discussion (Misc queries) | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
Use SUMPRODUCT for a matrix | Excel Worksheet Functions | |||
K-Means, X-Means or other Clustering Algorithms | Excel Programming | |||
Matrix multiplication using sumproduct | Excel Worksheet Functions |