Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Neil Evans-Mudie
 
Posts: n/a
Default 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


  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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   Report Post  
Neil Evans-Mudie
 
Posts: n/a
Default

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   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get Data Analysis Plus tool pack in tools menu Show up. . epsilon8 Setting up and Configuration of Excel 1 February 11th 05 05:13 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 10:17 PM
How do I add Data Analysis Tool Pak to my Excel 2000? justin Excel Discussion (Misc queries) 1 January 25th 05 06:35 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Data analysis data from a survey Jessie1 Excel Discussion (Misc queries) 3 December 23rd 04 03:52 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"