唉，仍然有那么多的人愿意赌垃圾# Stock
v*0
1 楼
Now I have two Excel spreadsheets as below:
Spreadsheet1
Gene change padj
1 212 0.0006
2 99 0.09
3 15 0.7
4 59 0.456
5 418 0.00001
6 566 0
Spreadsheet2
Gene statistic FDR
1 28 0.0005
2 17 0.007
3 3 0.81
4 8 0.28
5 48 0.002
6 111 0
Using Excel, how can I create one new spreadsheet that only includes the
Genes with both padj and FDR are less than 0.05?
And how can I do this in any other statsitical software, Like R, SPSS?
In addition, how can I first merge these two spreadsheets according to Gene
in Excel?
Thanks very much for any idea for any question!
Spreadsheet1
Gene change padj
1 212 0.0006
2 99 0.09
3 15 0.7
4 59 0.456
5 418 0.00001
6 566 0
Spreadsheet2
Gene statistic FDR
1 28 0.0005
2 17 0.007
3 3 0.81
4 8 0.28
5 48 0.002
6 111 0
Using Excel, how can I create one new spreadsheet that only includes the
Genes with both padj and FDR are less than 0.05?
And how can I do this in any other statsitical software, Like R, SPSS?
In addition, how can I first merge these two spreadsheets according to Gene
in Excel?
Thanks very much for any idea for any question!
