Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get Data Analysis Plus tool pack in tools menu Show up. . | Setting up and Configuration of Excel | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
How do I add Data Analysis Tool Pak to my Excel 2000? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data analysis data from a survey | Excel Discussion (Misc queries) |