statistics - data analysis tool
 

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: address is a spam sink
If you wish to email me, try neilevans underscore mudie at hotmail dot com
w: http://groups.msn.com/TheEvansMudieF...ew.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

Neil Evans-Mudie wrote:

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

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" wrote in message
...
Neil Evans-Mudie wrote:

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

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

Neil Evans-Mudie wrote:

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" wrote in message
...

Neil Evans-Mudie wrote:


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