Now I have two Excel spreadsheets, parts of them are 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?
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?
Thanks very much for any idea for any question!
Comment