# James P. McDonald Week 9

## Microarray Data Analysis

### ZAP1

• Each time point had 4 replicates.
• The dollar sign is important because the formulas must include the same average and same standard deviation when they are pasted down the entire column. WIthout the use of the dollar sign the excel would continue to down the column and use the wrong cells in the formula.
• Genes with p value < 0.05
• t15: 771
• t30: 1150
• t60: 1610
• t90: 364
• t120: 375
• Genes with p value < 0.01
• t15: 189
• t30: 340
• t60: 592
• t90: 73
• t120: 75
• Genes with p value < 0.001
• t15: 20
• t30: 35
• t60: 80
• t90: 7
• t120: 3
• Genes with p value < 0.0001
• t15: 4
• t30: 6
• t60: 8
• t90: 0
• t120: 0
• Genes still significantly changed at p < 0.05 after Bonferroni correction
• t15: 1
• t30: 2
• t60: 0
• t90: 0
• t120: 0
• Keeping the "Pval" filter at p < 0.05, filter the "AvgLogFC" column to show all genes with an average log fold change greater than zero. How many meet these two criteria? (time = t60)
• 786
• Keeping the "Pval" filter at p < 0.05, filter the "AvgLogFC" column to show all genes with an average log fold change less than zero. How many meet these two criteria? (time = t60)
• 824
• Keeping the "Pval" filter at p < 0.05, How many have an average log fold change of > 0.25 and p < 0.05? (time = t60)
• 755
• How many have an average log fold change of < -0.25 and p < 0.05? (time = t60)
• 763
• NSR1 Average Fold Change
• t15: 1.45
• t30: 1.57
• t60: 1.82
• t90: -0.81
• t120: -0.03
• NSR1 P value
• t15: 0.0481
• t30: 0.0023
• t60: 0.0020
• t90: 0.0680
• t120: 0.8963
• NSR1 expression is significantly changed at p < 0.05 at t15, t30, and t60. It is more significant at p < 0.01 at t30 and t60.