LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 829
Default Sumproduct in matrix means

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is This a Pivot? A SumProduct? A SumPivot? Matrix? RJB Excel Discussion (Misc queries) 1 May 13th 09 07:31 AM
How can I transpose nXm matrix to mXn Matrix MIHir Excel Worksheet Functions 2 August 9th 08 11:44 AM
Use SUMPRODUCT for a matrix Learn-more Excel Worksheet Functions 3 May 23rd 08 10:26 AM
K-Means, X-Means or other Clustering Algorithms Jim[_65_] Excel Programming 0 June 9th 07 09:46 PM
Matrix multiplication using sumproduct Rasoul Khoshravan Excel Worksheet Functions 3 October 16th 06 11:55 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"