| Author |
 Topic  |
|
|
coll@inia.
Spain
125 Posts |
 Posted - 04/20/2009 : 07:18:51 AM
|
Origin Ver. 8pro:
Operating System:WinXP
I work in microarrays data.
I have to compare data on each of the row genes (ii between 15000 to 40000) under situations A and B. I expect to have triplicates for each gene in A and B on due time.
Therefore, I would have a worksheet of data with the following column long names: GeneNumber, A1, A2, A3, B1, B2, and B3 and with 15000 or 40000 rows of genes.
Up to now I manage to place in adjacent columns on the same worksheet both the A mean (A1,A2,A3)and their A sd (A1,A2,A3) and the B mean (B1,B2,B3) and their B sd (B1,B2,B3) for each of the row ii genes.
Could I do a similar job with the corresponding comparison between A and B for T-student and p values for each row ii gene?. What would be the code required?
Thanks for your help!, hasta luego: julio
|
|
|
Echo_Chu
China
Posts |
Posted - 04/27/2009 : 01:36:13 AM
|
Hi,
We have a x-function for it. rowttest2. You can type "rowttest2 -d" to bring up dialog to do t-test for row data.
And if you want to use it in script, base on the data, you can use script as following
rowttest2 irng1:=col(a1)[15000]:col(a3)[40000] irng2:=col(b1)[15000]:col(b3)[40000] statistic:=col(8)[15000:40000] prob:= prob:=col(9)[15000:40000]
Here we assumed the t statistic will be output to 8th column and prob will be output to 9th column |
 |
|
|
coll@inia.
Spain
125 Posts |
Posted - 04/28/2009 : 11:39:47 AM
|
really simple & BEAUTIFUL!!!
I was thinking it did not existed such a function and it seems that 50 more people look at it without knowing it too!.
Thanks so much Echo_Chu |
|
|
| |
Topic |
|
|
|
T student /p values on columns