LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
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 04:13 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM
How do I add Data Analysis Tool Pak to my Excel 2000? justin Excel Discussion (Misc queries) 1 January 25th 05 05:35 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Data analysis data from a survey Jessie1 Excel Discussion (Misc queries) 3 December 23rd 04 02:52 PM


All times are GMT +1. The time now is 11:55 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"