statistics - data analysis tool

[Neil Evans-Mudie]

Hi,

Could anybody give me any pointers how to statisically analyse the below
data matrix. Cols (1999 - 2002) are independent Years, Rows are dependent
categories (a - n). I am using Excel 2000 & data analysis tool (I have no
access to higher end stat software like spss & statview512).

Cheers,

Neil Evans-Mudie
-. . .. .-.. / .----. ... --- -. .. -.-. .----. / . ...- .- -.
.... -....- -- ..- -.. .. .

e: (e-mail address removed) address is a spam sink
If you wish to email me, try neilevans underscore mudie at hotmail dot com
w: http://groups.msn.com/TheEvansMudieFamily/_whatsnew.msnw?&pps=k

Data:
1999 2000 2001 2002
a 4638.00 4142.00 3654.00 2813.00
b 10082.00 7202.00 6896.00 5607.00
c 7308.00 14075.00 14232.00 13687.00
d 30.00 30.00 26.00 41.00
e 1822.00 2666.00 2445.00 211.00
f 5222.00 5091.00 5759.00 4734.00
g 473.00 745.00 912.00 232.00
h 17207.00 13671.00 12110.00 6304.00
I 26079.00 12604.00 11602.00 7672.00
j 7295.00 6841.00 6852.00 5448.00
k 1061.00 1137.00 972.00 1081.00
l 5273.00 6369.00 7578.00 875.00
m 39461.00 34426.00 37340.00 24487.00
n 4283.00 14273.00 25481.00 15234.00

 

[Jerry W. Lewis]

Could anybody give me any pointers how to statisically analyse the below
data matrix. Cols (1999 - 2002) are independent Years, Rows are dependent
categories (a - n).

What kind of analysis do you want to perform?

I am using Excel 2000 & data analysis tool (I have no
access to higher end stat software like spss & statview512).

R (a dialect of the S language) is free
http://www.r-project.org/

Jerry

 

[Neil Evans-Mudie]

Jerry,

No sure exactly, but I am trying find any significant data points or trends
in the matrix. Would really appreciate some pointers.

The values all relate to the same measure (a performance count). Cols are
independent years and rows are dependent categories. I could easily
normalise these figures and express them as a rate if this opens other
possibilities (matrix for this is enclosed below).

I'm guessing that trends across the years might be fruitful or data points
within a year.

Any help gratefully received. TIA.

Regards, Neil

Data:

1999 2000 2001 2002
a 0.69 0.70 0.71 0.74
b 0.55 0.77 0.82 0.80
c 0.80 0.83 0.85 0.86
d 0.67 0.47 0.50 0.73
e 0.81 0.77 0.76 0.74
f 0.70 0.80 0.82 0.80
g 0.59 0.78 0.82 0.62
h 0.74 0.71 0.75 0.73
I 0.55 0.71 0.77 0.79
j 0.63 0.70 0.75 0.80
k 0.68 0.55 0.61 0.67
l 0.79 0.81 0.81 0.64
m 0.73 0.82 0.85 0.88
n 0.58 0.89 0.93 0.28

 

[Jerry W. Lewis]

If you don't know where you are going, how will you know when you get
there? I would start by plotting the data.

Jerry