Trying to find anything meaningful from Matrices

L

langba

I have some square and rectangular matrices. It doesn't matter how man
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 reading
taken over 12 days. There is a nominal value and the matrix shows th
variance from that nominal. I'm hoping it doesn't matter what tha
nominal is.

Can Excel tell me anything meaningful out of this matrix
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top