I have some square and rectangular matrices. It doesn't matter how many
rows and columns, or what the numbers are, they are all different.
Also, they are all integer value.

One example is this 4 x 12 matrix:

1 0 0 0
1 -1 0 0
-1 0 0 0
0 1 0 0
0 -1 0 0
0 0 -1 0
-2 1 0 0
1 0 0 0
1 1 0 0
1 1 0 0
-1 -2 0 -1
-2 1 -1 0

It's the variance in field measurements for the same four readings
taken over 12 days. There is a nominal value and the matrix shows the
variance from that nominal. I'm hoping it doesn't matter what that
nominal is.

Can Excel tell me anything meaningful out of this matrix?


--
langba
------------------------------------------------------------------------
langba's Profile: http://www.excelforum.com/member.php...fo&userid=4144
View this thread: http://www.excelforum.com/showthread...hreadid=472173

You can calculate the average absolute variation for each week as the sum of
the absolute values divided by 4. It appears to be growing week-by-week:

0.25
0.25
0.25
0.75
0.25
0.5
0.5
1
1

--
Gary''s Student


"langba" wrote:


I have some square and rectangular matrices. It doesn't matter how many
rows and columns, or what the numbers are, they are all different.
Also, they are all integer value.

One example is this 4 x 12 matrix:

1 0 0 0
1 -1 0 0
-1 0 0 0
0 1 0 0
0 -1 0 0
0 0 -1 0
-2 1 0 0
1 0 0 0
1 1 0 0
1 1 0 0
-1 -2 0 -1
-2 1 -1 0

It's the variance in field measurements for the same four readings
taken over 12 days. There is a nominal value and the matrix shows the
variance from that nominal. I'm hoping it doesn't matter what that
nominal is.

Can Excel tell me anything meaningful out of this matrix?


--
langba
------------------------------------------------------------------------
langba's Profile: http://www.excelforum.com/member.php...fo&userid=4144
View this thread: http://www.excelforum.com/showthread...hreadid=472173